[font=Times New Roman][i]
HELLO ORACLE GURUS ...
I AM NEW TO THIS ORACLE DB...
I INSTALLED TWO ORACLE DATABASES(926_32) IN D(EPT) and E(NWD) DRIVES ON ONE HOST(PW100).
WHILE INSTALLING I GAVE THE DB SID'S NWD AND EPT.
AFTER INSTALLING WHEN I LOOK INTO THE
(SID:EPT)D:\ORACLE\NETWORK\ADMIN> LSNRCTL STATUS.....IT SHOWS BELOW
D:\oracle\network\admin>LSNRCTL STATUS
LSNRCTL for 32-bit Windows: Version 9.2.0.6.0 - Production on 31-JUL-2007 18:00:
30
Copyright © 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=NWD.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Produc
tion
Start Date 31-JUL-2007 16:06:37
Uptime 0 days 1 hr. 53 min. 53 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File E:\oracle\network\admin\listener.ora
Listener Log File E:\oracle\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NWD.WORLDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NWDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pw100)(PORT=1527)))
Services Summary...
Service "NWD" has 1 instance(s).
Instance "NWD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
D:\oracle>TNSPING EPT
TNS Ping Utility for 32-bit Windows: Version 9.2.0.6.0 - Production on 31-JUL-20
07 18:18:32
Copyright © 1997 Oracle Corporation. All rights reserved.
Used parameter files:
E:\oracle\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
(SID:NWD)E:\ORACLE\NETWORK\ADMIN> LSNRCTL STATUS
LSNRCTL for 32-bit Windows: Version 9.2.0.6.0 - Production on 31-JUL-2007 18:00:
30
Copyright © 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=NWD.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Produc
tion
Start Date 31-JUL-2007 16:06:37
Uptime 0 days 1 hr. 55 min. 53 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File E:\oracle\network\admin\listener.ora
Listener Log File E:\oracle\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NWD.WORLDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NWDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pw100)(PORT=1527)))
Services Summary...
Service "NWD" has 1 instance(s).
Instance "NWD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
E:\oracle>TNSPING NWD
TNS Ping Utility for 32-bit Windows: Version 9.2.0.6.0 - Production on 31-JUL-20
07 18:17:46
Copyright © 1997 Oracle Corporation. All rights reserved.
Used parameter files:
E:\oracle\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (C
OMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = pw100) (PORT = 1528))) (CONNECT_D
ATA = (SID = NWD) (GLOBAL_NAME = NWD.WORLD)))
TNS-12541: TNS:no listener
IT'S VERY URGENT .....AM FACING PROBLEM WHILE INSTALLING SAP SYSTEM ON TOP OF ORACLE.
FULL POINTS WILL BE ASSIGNED FOR CORRECT ANSWER
THANKS IN ADVANCE
JANAKIRAM