Clone to new box

From: Bryan Wells <bunjibry_at_gmail.com>
Date: Thu, 7 Apr 2005 07:56:40 -0600
Message-ID: <b78d5a2005040706561f1e2df8@mail.gmail.com>

Newbie here...
Help! Apparently I have goofed somewhere. oops, i mean created another learning experience. i cloned two 9.2.0.5 <http://9.2.0.5> instances on w2k from an old production environment. everything seems to be running better, faster, yea! right?

well, i cant hit as sys remotely via sql*plus or OEM to what is now production. investigating the OEM issue via google, metalink, et.al. i have found the following in %ORACLE_HOME%\network\log\nmiconf.log:

DBSNMP for 32-bit Windows: release 9.2.0.0.0 - Production on 06-APR-05 17:04:30
Discovering services on lon1-gdw1 configured on host addresses { lon1-gdw1.global.sunrise.medical 10.5.1.100 <http://10.5.1.100>} Warning : Listener LISTENER defined in
d:\oracle\ora9i\network\admin\listener.ora will be skipped because, it does not have a corresponding NT service entry Warning : Skipping OracleOraHome9iTNSListener : Could not find corresponding listener definition in {d:\oracle\ora9i\network\admin\listener.ora}

Warning : No Listener found for SID CRN. CRN will be skipped
Warning : No Listener found for SID CRN1. CRN1 will be skipped
Warning : No Listener found for SID GDWP. GDWP will be skipped

Could not determine location of emtab.

D:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 9.2.0.5.0 - Production on 07-APR-2005 07:53:
12

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lon1-gdw1)(PORT=1521)))
STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.5.0 - Produc tion
Start Date 06-APR-2005 12:22:07
Uptime 0 days 19 hr. 31 min. 6 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File D:\oracle\ora9i\network\admin\listener.ora Listener Log File D:\oracle\ora9i\network\log\listener.log Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lon1-gdw1.global.sunrise.medical
)(PO
RT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lon1-gdw1.global.sunrise.medical
)(PO
RT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lon1-gdw1.global.sunrise.medical
)(PO
RT=2100))(Presentation=FTP)(Session=RAW)) Services Summary...
Service "CRN" has 2 instance(s).

Instance "CRN", status UNKNOWN, has 1 handler(s) for this service...
Instance "CRN", status READY, has 1 handler(s) for this service...
Service "CRN1" has 2 instance(s).

Instance "CRN1", status UNKNOWN, has 1 handler(s) for this service... Instance "CRN1", status READY, has 1 handler(s) for this service... Service "CRN1XDB" has 1 instance(s).
Instance "CRN1", status READY, has 1 handler(s) for this service... Service "GDWP" has 2 instance(s).
Instance "GDWP", status UNKNOWN, has 1 handler(s) for this service... Instance "GDWP", status READY, has 2 handler(s) for this service... Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully

D:\>
The OracleOraHome9iTNSListener is set to restart Automatically but it will not, and i cant get it to start manually either. I assume i messed up when creating the listener file for the new instances as well as when i did the Oracle install. i am continuing to run this down, but wanted some senior counseling since i am the only real DBA on site. your comments, experience and advice is greatly appreciated.

-- 
Bryan S Wells - DBA Newbie
bunjibry_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 07 2005 - 10:00:33 CDT