Clone to new box
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Apr 2005 07:56:40 -0600
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
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
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@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
