Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2063037
  • 博文数量: 632
  • 博客积分: 10716
  • 博客等级: 上将
  • 技术积分: 8402
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-01 22:35
文章分类

全部博文(632)

文章存档

2019年(20)

2018年(4)

2017年(37)

2016年(22)

2015年(1)

2013年(12)

2012年(20)

2011年(19)

2010年(20)

2009年(285)

2008年(192)

分类: Oracle

2010-01-22 22:17:42

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]$ 
阅读(1614) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册