Skip to Content
avatar image
Former Member

Error at Configure Oracle Server Network in DB instance

Hi,

We are in the process of installing Prodcution server ERP6.0 with EHP5, Oracle 11.2.0.2 on Microsoft Windows 2008 R2 cluster. The Window Clusterwas set up by OS team. We have installed successfully Oracle 11.2.0.2 software and Oracle Fail Safe 3.4.2 on both notdes.We have installed First Node configuration successfully.

Now we started the DB instance on First Node and we are facing issue in the pahse "Configure Oracle Server Network". It saying cannot start Oracle Listner. When manually tried to start the listner it is not starting.

Please find below the sapinst.log

INFO 2011-12-05 14:50:42.732

Node cluster.exe.log already exists.

INFO 2011-12-05 14:50:42.748

Output of cluster.exe RESOURCE "SAP ITP NetName" is written to the logfile cluster.exe.log.

INFO 2011-12-05 14:50:42.763

Execution of the command "cluster.exe RESOURCE "SAP ITP NetName"" finished with return code 0. Output:

Listing status for resource 'SAP ITP NetName':

Resource Group Node Status

-


-


-


-


SAP ITP NetName SAP ITP itererppd1 Online

INFO 2011-12-05 14:50:42.795

Node getClusterDrive.vbs.log already exists.

INFO 2011-12-05 14:50:42.795

Output of cscript.exe /b getClusterDrive.vbs "Cluster Disk 2" is written to the logfile getClusterDrive.vbs.log.

INFO 2011-12-05 14:50:42.873

Execution of the command "cscript.exe /b getClusterDrive.vbs "Cluster Disk 2"" finished with return code 0. Output:

G:

INFO 2011-12-05 14:50:42.997

Working directory changed to C:/Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/HA/DB.

INFO 2011-12-05 14:50:43.231

Execute step setPermissions of component |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0

INFO 2011-12-05 14:50:43.294

Working directory changed to C:/Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/HA/DB.

INFO 2011-12-05 14:50:43.497

Execute step setDbenvEnvironment of component |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0

INFO 2011-12-05 14:50:43.731

Working directory changed to C:/Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/HA/DB.

INFO 2011-12-05 14:50:43.965

Execute step doCleanOldNetworkFiles of component |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0

INFO 2011-12-05 14:50:44.152

Working directory changed to C:/Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/HA/DB.

INFO 2011-12-05 14:50:44.355

Execute step doNetworkConfigurationServer of component |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0

INFO 2011-12-05 14:50:44.760

Creating file C:\Program Files\sapinst_instdir\ERPEhP5\AS-ABAP\ORA\HA\DB\lsnrctl.log.

INFO 2011-12-05 14:50:44.776

Output of E:\oracle\ITP\11202\bin\lsnrctl stop LISTENER is written to the logfile lsnrctl.log.

WARNING 2011-12-05 14:50:46.398

Execution of the command "E:\oracle\ITP\11202\bin\lsnrctl stop LISTENER" finished with return code 1. Output:

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 05-DEC-2011 14:50:44

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error

INFO 2011-12-05 14:50:46.476

Creating file E:\oracle\ITP\11202\NETWORK\ADMIN\listener.ora.

INFO 2011-12-05 14:50:46.617

Creating file E:\oracle\ITP\11202\NETWORK\ADMIN\tnsnames.ora.

INFO 2011-12-05 14:50:46.726

Copied file 'E:/oracle/ITP/11202/NETWORK/ADMIN/sqlnet.ora' to 'E:/oracle/ITP/11202/NETWORK/ADMIN/sqlnet.1.ora'.

INFO 2011-12-05 14:50:46.726

Removed file E:\oracle\ITP\11202\NETWORK\ADMIN\sqlnet.ora.

INFO 2011-12-05 14:50:46.726

Creating file E:\oracle\ITP\11202\NETWORK\ADMIN\sqlnet.ora.

INFO 2011-12-05 14:50:46.882

Working directory changed to C:/Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/HA/DB.

INFO 2011-12-05 14:50:47.100

Execute step doNetworkConfigurationClient of component |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0

INFO 2011-12-05 14:50:47.365

Creating directory
erp-clus-app\sapmnt\ITP\SYS\profile\oracle.

INFO 2011-12-05 14:50:47.631

Creating file
erp-clus-app\sapmnt\ITP\SYS\profile\oracle\tnsnames.ora.

INFO 2011-12-05 14:50:47.755

Creating file
erp-clus-app\sapmnt\ITP\SYS\profile\oracle\sqlnet.ora.

INFO 2011-12-05 14:50:47.927

Working directory changed to C:/Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/HA/DB

INFO 2011-12-05 14:50:48.161

Execute step StartListener of component |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0

INFO 2011-12-05 14:50:48.473

Creating file C:\Program Files\sapinst_instdir\ERPEhP5\AS-ABAP\ORA\HA\DB\lsnrctl.log.

INFO 2011-12-05 14:50:48.473

Output of E:\oracle\ITP\11202\bin\lsnrctl stop LISTENER is written to the logfile lsnrctl.log.

WARNING 2011-12-05 14:51:09.689

Execution of the command "E:\oracle\ITP\11202\bin\lsnrctl stop LISTENER" finished with return code 1. Output:

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 05-DEC-2011 14:50:48

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp-clus-db)(PORT=1527))

TNS-12535: TNS:operation timed out

TNS-12560: TNS:protocol adapter error

TNS-00505: Operation timed out

64-bit Windows Error: 60: Unknown error

INFO 2011-12-05 14:51:12.403

Creating file C:\Program Files\sapinst_instdir\ERPEhP5\AS-ABAP\ORA\HA\DB\lsnrctl.log.

INFO 2011-12-05 14:51:12.403

Output of E:\oracle\ITP\11202\bin\lsnrctl start LISTENER is written to the logfile lsnrctl.log.

WARNING 2011-12-05 14:51:38.268

Execution of the command "E:\oracle\ITP\11202\bin\lsnrctl start LISTENER" finished with return code 1. Output:

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 05-DEC-2011 14:51:12

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting tnslsnr: please wait...

Failed to open service <OracleITP11202TNSListener>, error 1060.

TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production

System parameter file is E:\oracle\ITP\11202\network\admin\listener.ora

Log messages written to E:\oracle\diag\tnslsnr\itererppd1\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ITP.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ITPipc)))

Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp-clus-db)(PORT=1527))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

64-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...

ERROR 2011-12-05 14:51:38.268

CJS-00095 Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\ITP\11202/bin/lsnrctl indicates an error. SOLUTION: For more information, see log file lsnrctl.log.

ERROR 2011-12-05 14:51:38.268

CJS-00095 Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\ITP\11202/bin/lsnrctl indicates an error. SOLUTION: For more information, see log file lsnrctl.log.

ERROR 2011-12-05 14:51:38.284

FCO-00011 The step StartListener with step key |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0|StartListener was executed with status ERROR ( Last error reported by the step: Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\ITP\11202/bin/lsnrctl indicates an error. SOLUTION: For more information, see log file lsnrctl.log.).

INFO 2011-12-05 14:51:38.549

Creating file C:\Program Files\sapinst_instdir\ERPEhP5\AS-ABAP\ORA\HA\DB\__instana_tmp.xml.

INFO 2011-12-05 14:57:23.574

An error occured and the user decided to retry the current step: "|NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0|StartListener".

INFO 2011-12-05 14:57:25.914

Working directory changed to C:/Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/HA/DB.

INFO 2011-12-05 14:57:26.351

Creating file C:\Program Files\sapinst_instdir\ERPEhP5\AS-ABAP\ORA\HA\DB\lsnrctl.log.

INFO 2011-12-05 14:57:26.367

Output of E:\oracle\ITP\11202\bin\lsnrctl stop LISTENER is written to the logfile lsnrctl.log.

WARNING 2011-12-05 14:57:47.583

Execution of the command "E:\oracle\ITP\11202\bin\lsnrctl stop LISTENER" finished with return code 1. Output:

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 05-DEC-2011 14:57:26

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp-clus-db)(PORT=1527))

TNS-12535: TNS:operation timed out

TNS-12560: TNS:protocol adapter error

TNS-00505: Operation timed out

64-bit Windows Error: 60: Unknown error

INFO 2011-12-05 14:57:47.707

Creating file C:\Program Files\sapinst_instdir\ERPEhP5\AS-ABAP\ORA\HA\DB\lsnrctl.log.

INFO 2011-12-05 14:57:47.723

Output of E:\oracle\ITP\11202\bin\lsnrctl start LISTENER is written to the logfile lsnrctl.log.

WARNING 2011-12-05 14:58:13.073

Execution of the command "E:\oracle\ITP\11202\bin\lsnrctl start LISTENER" finished with return code 1. Output:

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 05-DEC-2011 14:57:47

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production

System parameter file is E:\oracle\ITP\11202\network\admin\listener.ora

Log messages written to E:\oracle\diag\tnslsnr\itererppd1\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ITP.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ITPipc)))

Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp-clus-db)(PORT=1527))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

64-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...

ERROR 2011-12-05 14:58:13.089

CJS-00095 Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\ITP\11202/bin/lsnrctl indicates an error. SOLUTION: For more information, see log file lsnrctl.log.

ERROR 2011-12-05 14:58:13.089

CJS-00095 Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\ITP\11202/bin/lsnrctl indicates an error. SOLUTION: For more information, see log file lsnrctl.log.

ERROR 2011-12-05 14:58:13.104

FCO-00011 The step StartListener with step key |NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0|StartListener was executed with status ERROR ( Last error reported by the step: Error return code. DIAGNOSIS: Return code 1 of executable E:\oracle\ITP\11202/bin/lsnrctl indicates an error. SOLUTION: For more information, see log file lsnrctl.log.).

INFO 2011-12-05 14:58:13.338

Creating file C:\Program Files\sapinst_instdir\ERPEhP5\AS-ABAP\ORA\HA\DB\__instana_tmp.xml.

The "Listener.log"

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 05-DEC-2011 14:57:47

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production

System parameter file is E:\oracle\ITP\11202\network\admin\listener.ora

Log messages written to E:\oracle\diag\tnslsnr\itererppd1\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ITP.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ITPipc)))

Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp-clus-db)(PORT=1527))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

64-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...

Thanks & Regards,

Sreekanth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 08, 2011 at 07:31 AM

    Hi,

    Can you share your listener.ora details please. It seems some issue in the file.

    Additionally please check whether windows firewall is off and port 1527 is not blocked.

    Regards,

    Deepak Kori

    Edited by: deepakkori on Dec 8, 2011 1:06 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 09, 2011 at 07:11 AM

    Hi,

    find below the listener.ora contents. We have made entry for erp-clus-db(IP address) in the DNS. Its not pinging but NSLOOKUP resolving the IP and FQHN.

    ADMIN_RESTRICTIONS_LISTENER = on

    LISTENER =

    (ADDRESS_LIST =

    (ADDRESS =

    (PROTOCOL = IPC)

    (KEY = ITP.WORLD)

    )

    (ADDRESS=

    (PROTOCOL = IPC)

    (KEY = ITP)

    )

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = erp-clus-db)

    (PORT = 1527)

    )

    )

    STARTUP_WAIT_TIME_LISTENER = 0

    CONNECT_TIMEOUT_LISTENER = 10

    TRACE_LEVEL_LISTENER = 16

    SID_LIST_LISTENER =

    (SID_LIST =

    (SID_DESC =

    (SID_NAME = ITP)

    (ORACLE_HOME = E:\oracle\ITP\11202)

    )

    )

    Thanks,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 09, 2011 at 07:13 AM

    Hi,

    The windows fire wall is disabled, and 1527 port is not blocked

    Thanks,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sreekanth,

      Please check C:\Windows\System32\drivers\etc\hosts file has the IP address and hostname defined.

      Or else if you use DNS, is nslookup gives the proper output.

      Let us know the output of lsnrctl status <LISTENER_NAME>.

      Also, kindly recheck your listener.ora and tnsnames.ora files for typo mistakes.

      Br,

      Venky

  • avatar image
    Former Member
    Dec 09, 2011 at 07:58 AM

    Hi,

    We are using DNS and find below the output of nslookup. And we tried with host entries in Drivers\etc\hosts then also having same issue.

    and below that find listener status & tnsping also.

    C:\Users\admin>nslookup erp-clus-db

    Server: intocs.iter-india.org

    Address: 192.168.10.237

    Name: erp-clus-db.iter-india.org

    Address: 192.168.10.122

    C:\Users\itpadm>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 09-DEC-2011 13:20

    :09

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP.WORLD))

    TNS-12541: TNS:no listener

    TNS-12560: TNS:protocol adapter error

    TNS-00511: No listener

    64-bit Windows Error: 2: No such file or directory

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP))

    TNS-12541: TNS:no listener

    TNS-12560: TNS:protocol adapter error

    TNS-00511: No listener

    64-bit Windows Error: 2: No such file or directory

    Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp-clus-db)(POR

    T=1527))

    TNS-12535: TNS:operation timed out

    TNS-12560: TNS:protocol adapter error

    TNS-00505: Operation timed out

    64-bit Windows Error: 60: Unknown error

    C:\Users\itpadm>tnsping ITP

    TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 09-DEC-2

    011 13:20:36

    Copyright (c) 1997, 2010, Oracle. All rights reserved.

    Used parameter files:

    E:\oracle\ITP\11202\network\admin\sqlnet.ora

    Used TNSNAMES adapter to resolve the alias

    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP

    .WORLD) (PROTOCOL = TCP) (HOST = erp-clus-db) (PORT = 1527))) (CONNECT_DATA = (S

    ID = ITP) (GLOBAL_NAME = ITP.WORLD)))

    TNS-12535: TNS:operation timed out

    C:\Users\itpadm>

    Thanks & Regards,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      C:\Users\itpadm>lsnrctl status

      LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 09-DEC-2011 13:20

      :09

      Copyright (c) 1991, 2010, Oracle. All rights reserved.

      Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP.WORLD))

      TNS-12541: TNS:no listener

      TNS-12560: TNS:protocol adapter error

      TNS-00511: No listener

      64-bit Windows Error: 2: No such file or directory

      Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ITP))

      TNS-12541: TNS:no listener

      TNS-12560: TNS:protocol adapter error

      TNS-00511: No listener

      64-bit Windows Error: 2: No such file or directory

      Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp-clus-db)(POR

      T=1527))

      TNS-12535: TNS:operation timed out

      TNS-12560: TNS:protocol adapter error

      TNS-00505: Operation timed out

      64-bit Windows Error: 60: Unknown error

      Above error implies your listener is not running.

      C:\Users\itpadm>tnsping ITP

      TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 09-DEC-2

      011 13:20:36

      Copyright (c) 1997, 2010, Oracle. All rights reserved.

      Used parameter files:

      E:\oracle\ITP\11202\network\admin\sqlnet.ora

      Used TNSNAMES adapter to resolve the alias

      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP

      .WORLD) (PROTOCOL = TCP) (HOST = erp-clus-db) (PORT = 1527))) (CONNECT_DATA = (S

      ID = ITP) (GLOBAL_NAME = ITP.WORLD)))

      TNS-12535: TNS:operation timed out

      Above error implies that there is some issue in hostname resolution and listener not running.

      Could you please recheck your hostfile entry whether loopback adapter

      Regards,

      Deepak Kori

  • avatar image
    Former Member
    Dec 13, 2011 at 11:56 AM

    Hi All,

    Thanks for the help.

    Actually i followed the Installation guide in which first they have mentioned to start the Database installation, but when i raised OSS SAP said first we need to create Oracle failsafe group in Oracle Failsafe manager and then continue with the installation. That solved by issue. It might be a installation guide mistake.

    Thanks,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Shamil,

      Before starting DB instance installation, complete the creation Oracle failsafe group in Oracle failsafe manager and the proceed to DB instance installation.

      Regards,
      Sreekanth