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.
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