|
1.centos 无密码共享文件夹 (1) 安装samba yum -y install samba samba-client (2)修改配置文件 vim /etc/samba/smb.conf # See smb.conf.example for a more detailed config file or # read the smb.conf manpage. # Run 'testparm' to verify the config is correct after # you modified it. [global] workgroup = SAMBA security = user passdb backend = tdbsam map to guest = Bad User printing = cups printcap name = cups load printers = yes cups options = raw [homes] comment = Home Directories valid users = %S, %D%w%S browseable = No read only = No inherit acls = Yes [printers] comment = All Printers path = /var/tmp printable = Yes create mask = 0600 browseable = No [print$] comment = Printer Drivers path = /var/lib/samba/drivers write list = @printadmin root force group = @printadmin create mask = 0664 directory mask = 0775 [rpt] path = /rpt_data comment = temp Directories writable = yes browseable = yes guest ok = yes rpt是我添加的要共享的配置信息,samba v4.1.1版本不支持share和server，当security设置为 user后需要加一行map to guest = Bad User才能允许无密码访问。 (3)开放端口 firewall-cmd --permanent --add-port=139/tcp firewall-cmd --permanent --add-port=445/tcp systemctl restart firewalld #(重启防火墙) 关闭SELinux vi /etc/selinux/config 将SELINUX=enforcing改为SELINUX=disabled (4)重启服务 #重启smb和nmb服务 systemctl restart smb systemctl restart nmb 在Windows系统上按下“win+r”键，输入"\\共享文件夹的IP地址" 2.oracle的表变量 表变量的定义 type temp_table is table of RPT_SALSES_FGS_DAILY_temp%rowtype index by binary_integer; temp_fgs temp_table; 表变量的赋值 select * bulk collect into temp_fgs from fgs_xc 将表变量的值插入到RPT_SALSES_FGS_DAILY_temp表中，并且temp_fgs 字段与RPT_SALSES_FGS_DAILY_temp字段相对应 for i in 1..temp_fgs.COUNT loop INSERT INTO RPT_SALSES_FGS_DAILY_temp VALUES temp_fgs (i); end loop; (责任编辑：IT) |