Unable to start 2nd oracle database

From: Chris cc (lazyboy_2k@yahoo.com)
Date: Mon Jan 22 2007 - 19:12:12 EST


Hi All,

I have installed 2 databases (9i & 10g) & configured 9i & 10g listeners on a 2 node Veritas clusters which are installed Sol 10. The 10g listener starts up & shutdowns w/o any problem, however, I'm unable to startup the 9i listener. I have already tried to replace a virtual name to a virtual ip, but it still doesn't work correctly. Does anyone know what else do I need to configure in order to get an 9i listener to work? Also as you notice, it keeps pointing over to my oracle 10g & I don't understand why? Any helps/suggestions are appreciated.

$ cat listener.ora
ora9idb_lsnr =
        (ADDRESS_LIST=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ora9idb_lsnr)(PORT=1521))
        )

SID_LIST_ora9idb_lsnr =
      (SID_LIST =
                (SID_DESC =
                        (GLOBAL_DBNAME = ora9idb)
                        (ORACLE_HOME = /oraclesw/product/9.2.0.1.0)
                        (SID_NAME = ora9idb)
                )
        )

$ cat tnsnames.ora
ora9idb =
        (DESCRIPTION =
               (ADDRESS_LIST =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = ora9idb_lsnr)(PORT = 1521))
                )
                (CONNECT_DATA =
                        (SID = ora9idb)
               )
         )

$ lsnrctl start

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 22-JAN-2007 15:00:52

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /oraclesw/product/9.2.0.1.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
System parameter file is /oraclesw/product/10.2.0/network/admin/listener.ora
Log messages written to /oraclesw/product/9.2.0.1.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-phys1)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
Start Date 22-JAN-2007 15:00:52
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oraclesw/product/10.2.0/network/admin/listener.ora
Listener Log File /oraclesw/product/9.2.0.1.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-phys1)(PORT=1521)))
The listener supports no services
The command completed successfully

Any helps are appreciated.

Thx,
-Chris

 
---------------------------------
Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:41:30 EDT