ams_pool_size=0
test2.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/test/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='+ZBDBA/test/controlfile/current.261.870904273','+ZBDBA/test/controlfile/current.260.870904273'
*.db_block_size=8192
*.db_create_file_dest='+ZBDBA'
*.db_domain=''
*.db_name='test'
*.db_recovery_file_dest='+ZBDBA'
*.db_recovery_file_dest_size=4621074432
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
test1.instance_number=1
test2.instance_number=2
*.memory_target=786432000
*.open_cursors=300
*.processes=150
*.remote_listener='node-cluster-scan:1521'
*.remote_login_passwordfile='exclusive'
test2.thread=2
test1.thread=1
test2.undo_tablespace='UNDOTBS2'
test1.undo_tablespace='UNDOTBS1'
配置环境变量:
[oracle@zbdba1 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/products/11.2.0
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=test1
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
创建目录:
mkdir -p /opt/oracle/admin/test/adump
8、启动数据库
sqlplus / as sysdba
startup
查看日志:
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /opt/oracle/products/11.2.0
System name: Linux
Node name: zbdba1
Release: 2.6.32-279.el6.x86_64
Version: #1 SMP Wed Jun 13 18:24:36 EDT 2012
Machine: x86_64
Using parameter settings in server-side pfile /opt/oracle/products/11.2.0/dbs/inittest1.ora
System parameters with non-default values:
processes = 150
memory_target = 752M
control_files = "+ZBDBA/test/controlfile/current.261.870904273"
control_files = "+ZBDBA/test/controlfile/current.260.870904273"
db_block_size = 8192
compatible = "11.2.0.4.0"
cluster_database = TRUE
db_create_file_dest = "+ZBDBA"
db_recovery_file_dest = "+ZBDBA"
db_recovery_file_dest_size= 4407M
thread = 1
undo_tablespace = "UNDOTBS1"
instance_number = 1
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=testXDB)"
remote_listener = "node-cluster-scan:1521"
audit_file_dest = "/opt/oracle/admin/test/adump"
audit_trail = "DB"
db_name = "test"
open_cursors = 300
diagnostic_dest = "/opt/oracle"
Cluster communication is configured to use the following interface(s) for this instance
169.254.126.87
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sun Feb 08 03:18:08 2015
PMON started with pid=2, OS id=15720
Sun Feb 08 03:18:08 2015
PSP0 started with pid=3, OS id=15722
Sun Feb 08 03:18:09 2015
VKTM started with pid=4, OS id=15724 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Feb 08 03:18:09 2015
GEN0 started with pid=5, OS id=15728
Sun Feb 08 03:18:09 2015
DIAG started with pid=6, OS id=15730
Sun Feb 08 03:18:09 2015
DBRM started with pid=7, OS id=15732
Sun Feb 08 03:18:09 2015
PING started with pid=8, OS id=15734
Sun Feb 08 03:18:09 2015
ACMS started with pid=9, OS id=15736
Sun Feb 08 03:18:09 2015
DIA0 s