Query All Users: SELECT * from all_users; register monitoring manually: Alter system register;oracle password expiration setting 1, query select * from Dba_profiles where profile= ' Default ' and Resource_name= ' password_life_time '; 2, lifting limit alter profile DEFAULT limit Password_life_time UNLIMITED; 3, unlock locked user alter username user_name account unlock; 4 Modify locked user password ALTER user NEWJW identified by newjw; #ifconfigTYPE =ethernet #网卡类型DEVICE =eth0 #网卡接口名称ONBOOT =yes #系统启动时是否自动加载BOOTPROTO =static #启用地址协议--static: Static Protocol- -BOOTP protocol--DHCP Protocol ipaddr=192.168.1.11 #网卡IP地址NETMASK =255.255.255.0 #网卡网络地址GATEWAY =192.168.1.1 #网卡网关地址DNS1 = 10.203.104.41 #网卡DNS地址HWADDR =00:0c:29:13:5d:74 #网卡设备MAC地址BROADCAST =192.168.1.255 #网卡广播地址网卡接口关闭与激活 [[email Protected] ~]# ifdown eth0 #关闭网络 [[email protected] ~]# ifup eth0 #启动网络 Network services start and Close method one: [[email protected] ~ ]# Service Network Stop #关闭网络服务 [[email protected] ~]# service network start #启动网络服务 [[email protected] ~]# Servi Ce network restart #重启网络服务方法二: [[email protected] ~]#/etc/init.d/network StOp[[email protected] ~]#/etc/init.d/network start[[email protected] ~]#/etc/init.d/network restart 1. Back up one or more users individually: D:>exp scott/tiger file= Export File d:>exp system/manager owner= (user 1, user 2,..., user n) file= export file Back up one or more tables separately exp System/manager tables= (User 1. Table 1, User 2. Table 2) file=a.dmp cpio.gz file decompression method downloaded 10201_database_linux_x86_64. cpio.gz file, decompression method is as follows: 1. Gunzip 10201_database_linux_x86_64.cpio.gz get 10201_database_linux_x86_64.cpio file 2. CPIO-IDMV <10201_database_linux_x86_64.cpio can be extracted from the current directory 2. Args= '-j-server-xms200m-xmx1024m-xloggc:./log/gc.log-xx:maxnewsize=256m-xx:maxpermsize=256m-djava.awt.headless =true ' (1) j-server-xms200m-xmx1024m where-xms200m indicates initial memory size at startup,-xmx1024m maximum memory footprint. (2)-xx:maxnewsize=256m-xx:maxpermsize=256m: The size of the memory's permanent storage area (3)-djava.awt.headless=true solves the problem that the Linux/unix captcha picture cannot display.
Some Oracle Foundation