Primary数据库的配置
[oracle@RAC1 ~]$ hostname
RAC1
[oracle@RAC1 ~]$ more /etc/hosts
192.168.1.100 RAC1
192.168.1.101 RAC2
192.168.1.200 RAC1-vip
192.168.1.201 RAC2-vip
192.168.2.100 RAC1-priv
192.168.2.101 RAC2-priv
127.0.0.1 localhost
[oracle@RAC1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 22 12:34:48 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/ora10g/arch/
Oldest online log sequence 79
Next log sequence to archive 81
Current log sequence 81
SQL> select name from v$archived_log;
NAME
--------------------------------------------------------------------------------
racdb2
/opt/ora10g/arch/1_77_708527513.dbf
/opt/ora10g/arch/1_78_708527513.dbf
/opt/ora10g/arch/1_79_708527513.dbf
/opt/ora10g/arch/1_80_708527513.dbf
racdb2
racdb2
racdb2
racdb2
97 rows selected
SQL> create pfile='/tmp/initracdb1.ora' from spfile;
File created.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@RAC1 ~]$ ll /tmp/initracdb1.ora
[oracle@RAC1 ~]$ more /tmp/initracdb1.ora
racdb1.__db_cache_size=92274688
racdb1.__java_pool_size=4194304
racdb1.__large_pool_size=4194304
racdb1.__shared_pool_size=62914560
racdb1.__streams_pool_size=0
*.audit_file_dest='/opt/oracle10g/admin/racdb1/adump'
*.background_dump_dest='/opt/oracle10g/admin/racdb1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='+DATA/racdb1/controlfile/current.256.708527525','+DATA/racdb1/controlfile/current.257.708527525'
*.core_dump_dest='/opt/oracle10g/admin/racdb1/cdump'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='racdb1'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='racdb1'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdb1XDB)'
*.fal_client='racdb2'
*.fal_server='racdb1'
*.job_queue_processes=10
*.log_archive_config='dg_config=(racdb1,racdb2)'
*.log_archive_dest_1='LOCATION=/opt/ora10g/arch/ VALID_FOR=(all_logfiles,all_roles) db_unique_name=racdb1'
*.log_archive_dest_2='service=racdb2 valid_for=(online_logfiles,primary_role) db_unique_name=racdb2'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.standby_file_management='auto'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle10g/admin/racdb1/udump'
[oracle@RAC1 admin]$ more listener.ora
# listener.ora Network Configuration File: /opt/oracle10g/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle10g/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = racdb1)
(ORACLE_HOME = /opt/oracle10g/product/10.2.0/db_1)
(SID_NAME = racdb1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RAC1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
[oracle@RAC1 admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle10g/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
racdb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = racdb1)
)
)
racdb2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = racdb2)
)
)
[oracle@RAC1 admin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-JAN-2010 12:39:25
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 22-JAN-2010 12:33:51
Uptime 0 days 0 hr. 5 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle10g/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RAC1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "racdb1" has 2 instance(s).
Instance "racdb1", status UNKNOWN, has 1 handler(s) for this service...
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdb1XDB" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdb1_XPT" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@RAC1 admin]$
阅读(2743) | 评论(0) | 转发(0) |
