1.备份
[oracle@db1 ~]$ ps -ef | grep oracle | wc -l
75
2.
[oracle@db1 ~]$ sqlplus system/Oracle2013@orcl1
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 28 19:08:11 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
3.
SQL> select username,server from v$session where username='SYSTEM';
USERNAME SERVER
------------------------------------------------------------ ------------------
SYSTEM DEDICATED
4.
[oracle@db1 ~]$ ps -ef | grep oracle | wc -l
80
5.
SQL> show parameter shared_servers
NAME TYPE VALUE
------------------------------------ ---------------------- -----------------------------
max_shared_servers integer
shared_servers integer 1
SQL> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ---------------------- -----------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=orcl1XDB)
max_dispatchers integer
[oracle@db1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/
[oracle@db1 dbs]$ ls
hc_orcl1.dat hc_orcl.dat init.ora initorcl1.ora lkORCL1 orapworcl1 spfileorcl1.ora
[oracle@db1 dbs]$ vim initorcl1.ora
###########################################
# File Configuration
###########################################
control_files=("/u01/app/oracle/oradata/orcl/control01.ctl", "/u01/app/oracle/fast_recovery_area/orcl/control02.ctl")
db_recovery_file_dest="/u01/app/oracle/fast_recovery_area"
db_recovery_file_dest_size=4385144832
###########################################
# Miscellaneous
###########################################
compatible=11.2.0.4.0
diagnostic_dest=/u01/app/oracle
memory_target=843055104
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Security and Auditing
###########################################
audit_file_dest="/u01/app/oracle/admin/orcl/adump"
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
###########################################
# Shared Server
###########################################
shared_servers = 2
dispatchers="(PROTOCOL=TCP) (DISPATHERS=2)"
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1