OCM(三)

以此记录每一次OCM练习的过程，发现其中缺少的部分并补完。

共享服务器参数

alter system set sessions = 300 scope=spfile;
alter system set shared_server_sessions = 200 scope=spfile;
alter system set circuits = 200 scope=spfile;
shutdown immediate
startup
alter system set dispatchers = '(protocol=tcp)(dispatchers=3)';
alter system set max_dispatchers = 10;
alter system set shared_servers = 10;
alter system set max_shared_servers = 30;
复制

监听设置

vi $ORACLE_HOME/network/admin/listener.ora
--------------------------
LISTENER =
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1521))
    )
  )

SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=PROD1.oracle.com)
      (SID_NAME=PROD1)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
    )
    (SID_DESC=
      (GLOBAL_DBNAME=EMREP.oracle.com)
      (SID_NAME=EMREP)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
    )
  )
-------------------------
lsnrctl start
vi $ORACLE_HOME/network/admin/listener.ora
-------------------------
LSNR2 =
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1526))
    )
  )
-------------------------
lsnrctl start LSNR2
sqlplus / as sysdba
alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1526)))';
复制

• 动态注册

vi tnsnames.ora
--------------------------
dynamic_reg=
  (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1521))
    (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1526))
  )
---------------------------
sqlplus / as sysdba
alter system set local_listener='dynamic_reg';
复制

TNS配置

cp $ORACLE_HOME/network/admin/samples/tnsnames.ora tnsnames.ora
vi tnsnames.ora
---------------------------
PROD=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=PROD1.oracle.com)
      (server=dedicated)
    )
  )

PROD_S=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1526))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=PROD1.oracle.com)
      (server=shared)
    )
  )

RACDB=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01.example.com)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=RACDB)
      (server=dedicated)
    )
  )

PROD2=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=PROD2.oracle.com)
      (server=dedicated)
    )
  )

EMREP=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=even.oracle.com)(PORT=1621))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=EMREP.oracle.com)
      (server=dedicated)
    )
  )

PROD3=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=even.oracle.com)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=PROD3.oracle.com)
      (server=dedicated)
    )
  )
--------------------------
sqlplus system/oracle@prod
sqlplus system/oracle@prod_s
复制