undo的基本管理及监听器的配置

提高undo_rentention以防止ora-01555

alter system set undo_retention=5400;
alter tablespace undotbs retention guarantee;

关于监听器的三个文件

• 下面提供参考资料
  
  • listener.ora
  • tnsname.ora
  • sqlnet.ora

监听器的配置

• 编辑listener.ora文件

[oracle@dick dbs]$ cd $ORACLE_HOME/network/admin
[oracle@dick admin]$ ls
samples  shrept.lst
[oracle@dick admin]$ vim listener.ora
[oracle@dick admin]$ cat listener.ora 
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (SID_NAME=PROD)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
    )
  )

# 默认监听，端口是1521
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dick.localdomain)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

# 自己另外的监听，端口是1526
LSNR2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dick.localdomain)(PORT = 1526))
    )
  )

• 修改参数local_listener和启动监听

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=dick.localdomain)(PORT=1526))' sid='PROD';
[oracle@dick admin]$ lsnrctl start
[oracle@dick admin]$ lsnrctl start lsnr2
SQL> alter system register;

使用默认监听器和使用专用服务连接

[oracle@dick admin]$ lsnrctl stop
[oracle@dick admin]$ lsnrctl stop lsnr2
[oracle@dick admin]$ lsnrctl start
[oracle@dick admin]$ lsnrctl start lsnr2
SQL> alter system register;

System altered.

SQL> conn system/oracle@//dick.localdomain:1521/PROD
Connected.

[oracle@dick admin]$ ls
listener.ora  samples  shrept.lst
[oracle@dick admin]$ vim sqlnet.ora
[oracle@dick admin]$ cat sqlnet.ora 
ES.DIRECTORY_PATH=(tnsnames, ezconnect)
[oracle@dick admin]$ vim tnsnames.ora
[oracle@dick admin]$ cat tnsnames.ora 
prod=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=dick.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=dedicated)
  )
)

SQL> conn system/oracle@prod

利用lsnr2来使用共享服务连接

[oracle@dick admin]$ vim tnsnames.ora
[oracle@dick admin]$ cat tnsnames.ora 
prod=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=dick.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=dedicated)
  )
)
prod_s=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=dick.localdomain)(PORT=1526))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=shared)
  )
)


SQL> alter system set sessions=300 scope=spfile;

System altered.

SQL> alter system set shared_server_sessions=200 scope=both;

System altered.

SQL> alter system set dispatchers='(PROTOCOL=TCP)(DISPATCHERS=3)' scope=both;

System altered.

SQL> alter system set max_dispatchers=10 scope=both;

System altered.

SQL> alter system set max_shared_servers=30 scope=both;

System altered.

SQL> alter system register;

System altered.

SQL> conn system/oracle@prod_s
Connected.
SQL>