1, the establishment password file, uses in the SYS user remote login authentication (remote_login_passwordfile=exclusive), the position $ORACLE _home/dbs/orapwsid. Create command: ORAPWD
[Oracle@work dbs]$ orapwd File=orapwprod password=oracle entries=5
Remote_login_passwordfile
1 None deny sys user from remote connection
2) Exclusive SYS users can connect from remote
3) share multiple libraries can share password files
Sql>alter SYSTEM SET remote_login_passwordfile=none scope=spfile "Deny remote login"
2. Create init parameter file
[Oracle@oracle DBS] $more the Initdw.ora |grep-v ' ^# ' |grep-v ' ^$ ' >initlx02.ora
Create a Directory
[Oracle@oracle dbs]$ mkdir-p $ORACLE _base/admin/lx02/bdump
[Oracle@oracle dbs]$ mkdir-p $ORACLE _base/admin/lx02/cdump
[Oracle@oracle dbs]$ mkdir-p $ORACLE _base/admin/lx02/udump
[Oracle@oracle dbs]$ mkdir-p $ORACLE _base/oradata/lx02 "Where to store control files"
modifying initialization files
[Oracle@oracle dbs]$ VI Initlx02.ora
Db_name = lx02
Sga_target = 300M
Db_block_size = 8192
Pga_aggregate_target = 30M
Db_cache_size = 80M
Shared_pool_size = 60M
PARALLEL_THREADS_PER_CPU = 4
Optimizer_mode = Choose
Star_transformation_enabled = True
Db_file_multiblock_read_count = 16
Query_rewrite_enabled = True
query_rewrite_integrity = Trusted
Background_dump_dest = $ORACLE _base/admin/lx02/bdump
User_dump_dest = $ORACLE _base/admin/lx02/udump
Core_dump_dest = $ORACLE _base/admin/lx02/cdump
Control_files = $ORACLE _base/oradata/lx02/control01.ctl
Undo_management = Auto
Undo_tablespace = Rtbs