How to build libraries manually in Oracle

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