cancel
Showing results for 
Search instead for 
Did you mean: 

sap Listener cannot be started 1067

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Check your TNSNAMES.ora and listener.ora for errors.

Are you able to start the database successfully ?

Can you please paste the TNSPING <SID> output ?

Former Member
0 Kudos

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)

Former Member
0 Kudos

If P21 is your database SID, why do you have P11 to P51 in the listener.ora? Please remove the entries other than P21 and try again.

Former Member
0 Kudos

Arjun,

i am using P21 as listener and also for the other P11 to P51

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Venkata,

I also have restarting the Oracle-server, but its doesn't work....

Cheung

Former Member
0 Kudos

Hi,

Please find this link [http://www.codeweblog.com/listener-listener-oracle-error-1067-process-terminated-unexpectedly/]

Regards,

Venkata S Pagolu

Former Member
0 Kudos

Hi,

For windows 1067 error, deleting and recreating the service also helps.

FInd the link for creating the service [http://support.microsoft.com/kb/251192]

Regards,

Venkata S pagolu