on 02-20-2012 9:08 PM
Hi All,
I have some problems during the installation of NetWeaver (ABAP & JAVA).
Its a Distribued System.
I have some problems during the installation of the 'Database Instance' on Oracle.
Windows could not start the Oracle...TNSListener service on Local Computer.
Error 1067 has occurred: The process terminated unexpectedly
I have re-creating the service, but its doesn't work...
Please advice,
Cheung
did you try go to Oracle home and start the listener ?
1). oracle\SID\112\bin > lsnrctl start
2). Also try to do tnsping <SID> from the server
3). Check the note 82751 for Windows System Error 1067
4). Use Oracle metalink 334695.1 (How To Troubleshoot iSQL*Plus Startup Issues On Microsoft Windows NT/2000/2003)
Note 758563 - Oracle Metalink access for SAP customers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arjun thank you for your reply.
When i do the following:
1). oracle\SID\112\bin > lsnrctl start
I am logged in as <SiD>adm
i got the following error:
TNS-12560: TNS: protocol adapter error
TNS-00530: protocol adapter error
2). Also try to do tnsping <SID> from the server
i got no errors
I already checked these notes but doesn't help...
3). Check the note 82751 for Windows System Error 1067
4). Use Oracle metalink 334695.1 (How To Troubleshoot iSQL*Plus Startup Issues On Microsoft Windows NT/2000/2003)
Note 758563 - Oracle Metalink access for SAP customers
Check your TNSNAMES.ora and listener.ora for errors.
this is the listener.ora:
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = P11.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = P11)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = P21.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = P21)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = P31.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = P31)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = P41.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = P41)
)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = P51.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = P51)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = ORA2001)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = P11)
(ORACLE_HOME = D:\oracle\P11\102)
)
(SID_DESC =
(SID_NAME = P21)
(ORACLE_HOME = D:\oracle\P21\102)
)
(SID_DESC =
(SID_NAME = P31)
(ORACLE_HOME = D:\oracle\P31\102)
)
(SID_DESC =
(SID_NAME = P41)
(ORACLE_HOME = D:\oracle\P41\102)
)
(SID_DESC =
(SID_NAME = P51)
(ORACLE_HOME = D:\oracle\P51\102)
)
Are you able to start the database successfully ?
Yes, i can start the database successfully
Can you please paste the TNSPING <SID> output ?
D:\oracle\P21\102\BIN>tnsping P21
TNS Ping Utility for 64-bit Windows: Version 10.2.0.4.0 - Production on 20-FEB-2
012 22:51:17
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
NWS2002\sapmnt\P21\SYS\profile\oracle\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP
.WORLD)(PROTOCOL = TCP)(HOST = ORA2001)(PORT = 1527))) (CONNECT_DATA = (SID = P2
1) (GLOBAL_NAME = P21.WORLD)))
OK (20 msec)
Hi,
Seems it is windows issue for me from the below log provided by you.
Windows could not start the Oracle...TNSListener service on Local Computer.
Error 1067 has occurred: The process terminated unexpectedly
Please restart your server and start the Listener service manually. Let me know the result.
Regards,
Venkata S Pagolu
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.