hp-ux下安装了oracle10G,并在同一台机子上安装了两个数据库实例test1和test2;其中在参数中我把test1加进去了,所以它是默认的数据库,启动时,我是手工启动的,所有的em,数据库启动正常问题:
第1个问题、但是监听启动中,test1启动正常,而test2启动不正,我用netmgr配置好了两个监听,第一个是针对test1的端口号为1521;第二个是针对test2;端口号为1522;其它IP一样。我用lsnrctl start LISTENER1时报如下错误:(LISTENER1是为test2配 置的监听名)
Starting /opt/oracle/product/10.2.0/bin/tnslsnr: please wait...TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/network/log/listener1.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1522)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
HPUX Error: 226: Address already in useListener failed to start. See the error message(s) above...$ lsnrctl startLSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 04-APR-2009 12:54:31Copyright (c) 1991, 2005, Oracle. All rights reserved.TNS-01106: Listener using listener name listener has already been started
$
第2个问题:
象我这种双实例数据数,要怎么样做成它都能自动启动,包括em,数据库、各自监听,希望给出代码?谢谢
第1个问题、但是监听启动中,test1启动正常,而test2启动不正,我用netmgr配置好了两个监听,第一个是针对test1的端口号为1521;第二个是针对test2;端口号为1522;其它IP一样。我用lsnrctl start LISTENER1时报如下错误:(LISTENER1是为test2配 置的监听名)
Starting /opt/oracle/product/10.2.0/bin/tnslsnr: please wait...TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/network/log/listener1.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1522)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
HPUX Error: 226: Address already in useListener failed to start. See the error message(s) above...$ lsnrctl startLSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 04-APR-2009 12:54:31Copyright (c) 1991, 2005, Oracle. All rights reserved.TNS-01106: Listener using listener name listener has already been started
$
第2个问题:
象我这种双实例数据数,要怎么样做成它都能自动启动,包括em,数据库、各自监听,希望给出代码?谢谢
TNS-01106: Listener using listener name listener has already been started
==============================================================================
很显然配置有问题,仔细观察一下 listener.ora,根据错误提示应该很容易发现问题。
那么另一个,你需,比如:lsnrctl start listener_inst2
cd /home/oracle
. ./.profile
export ORACLE_SID=sid2
sqlplus /nolog <<EOF
conn user/passwd@SID
conn / as sysdba;
startup;
exit;
EOF;
conn user/passwd@SID 把密码去掉?用OS认证就可以?