共享模式配置：ORA-12514: TNS:listener could not resolve SERVICE_NAME

显示全部楼层 · 2009-9-27 10:21:22

env: oracle9i
1 alter dispatcher parameter.
idle> alter system set dispatchers="(protocol=tcp)(service=demo)(dispatchers=1)";
alter system set dispatchers="(protocol=tcp)(service=demo)(dispatchers=1)"

*
ERROR at line 1:
ORA-02066: missing or invalid DISPATCHERS text
(错误是由双引号引起的，要用单引号，真够晕的！)
idle>alter system set dispatchers='(PROTOCOL=TCP)(SERVICE=demo)(DISPATCHERS=1)';
System altered.
idle>shutdown immediate;
idle>startup
[oracle@redhat admin]$ ps -ef|grep oracle
oracle2636 10 14:51 ?00:00:00 ora_d000_demo
idle>alter system set dispatchers='(PROTOCOL=TCP)(SERVICE=demo)(DISPATCHERS=2)';
System altered.
idle>shutdown immediate;
idle>startup
[oracle@redhat admin]$ ps -ef|grep oracle
oracle2636 10 14:51 ?00:00:00 ora_d000_demo
当配置两个时，在后台也只看到一个Dipatchers进程，难道Dispatcher进程的数据量是由系统动态决定的
吗？
2 Setting the Initial Number of Shared Servers
The SHARED_SERVERS initialization parameter specifies the number of shared server processes
that you want to create when an instance is started up.SHARED_SERVERS is a dynamic
initialization parameter and can be changed using an ALTER SYSTEM statement.
(Oracle启动时默认启动多少个Shared Server Processes)
idle> alter system set shared_servers=4;
idle> show parameter shared_servers
NAME
TYPE
VALUE
------------------------------------ ---------------------- -------
shared_servers
integer
4

[oracle@redhat admin]$ ps -ef|grep oracle
oracle2624 10 14:51 ?00:00:00 ora_s000_demo
oracle2626 10 14:51 ?00:00:00 ora_s001_demo
oracle2628 10 14:51 ?00:00:00 ora_s002_demo
oracle2630 10 14:51 ?00:00:00 ora_s003_demo
可以看到有四个Server Processes.
3 add entry for file tnsnames.ora
SHARED =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.176)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demo)
(SERVER = shared)
)
)
DEDICATED =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.176)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demo)
(SERVER = dedicated)
)
)
ANYTHING =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.176)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demo)
)
)
配置Shared Server processes mode tns server
listener.ora 如下
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mydb)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = mydb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.176 )(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
4 test
[oracle@redhat oracle]$ sqlplus mouse/mosue@shared
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
监听器不能解析Service_Name 这是怎么回事呢？

千问 · 2009-9-27 10:21:22

alter system set dispatchers= '(PROTOCOL=TCP)(DISPATCHERS=2)'你这样看看

千问 · 2009-9-27 10:21:22

lsnrctl service listener
看看shared service是否已经登陆到listener上了。
看看登陆的service name是不是demo。
有没有db_domain。

千问 · 2009-9-27 10:21:22

问题已解决，
没有搞清sqlnet.ora, tnsname.ora, listener.ora三个文件的关系．具体参见http://space.itpub.net/10248702/viewspace-615606

千问 · 2009-9-27 10:21:22

listener 里面用mydb
结果tnsname 里面用(SERVICE_NAME = demo)连