on 10-05-2011 10:22 PM
I am installing ECC 6.O on Oracle 11G , Oracle SW has been insalled successfully , but sapinst stopped at "Configure Oracle network step" with the error as below
orahrd> tail -50 log.xml
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>
</txt>
</msg>
<msg time='2011-10-05T16:44:29.640-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>Started with pid=7012392
</txt>
</msg>
<msg time='2011-10-05T16:44:29.643-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD.WORLD)))
</txt>
</msg>
<msg time='2011-10-05T16:44:29.649-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD)))
</txt>
</msg>
<msg time='2011-10-05T16:44:29.656-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=HRD)(PORT=1527))
</txt>
</msg>
<msg time='2011-10-05T16:44:29.656-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>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
IBM/AIX RISC System/6000 Error: 68: Can't assign requested address
</txt>
</msg>
<msg time='2011-10-05T16:44:29.661-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD.WORLD)))
</txt>
</msg>
<msg time='2011-10-05T16:44:29.662-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='sapdv24'
host_addr='10.63.212.108'>
<txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD)))
</txt>
I got around the problem by replacing host name with IP address in tnsname.ora file
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> I am installing ECC 6.O on Oracle 11G , Oracle SW has been insalled successfully , but sapinst stopped at "Configure Oracle network step" with the error as below
Did you install the Oracle software when sapinst requested you to do so or did you install it before you started sapinst?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Markus, Thanks for yor reply
Yes , Oracle 11G SW has been inistalled when sapinst prompted, and it is stopping just after oracle server sw install and client sw install at "Configure Oracle Server network" step and canot strat the listener and ends up with error
TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
System parameter file is /oracle/HRD/112_64/network/admin/listener.ora
Log messages written to /oracle/HRD/112_64/log/diag/tnslsnr/sapdv24/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD)))
Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=HRD)(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
IBM/AIX RISC System/6000 Error: 68: Can't assign requested address
Listener failed to start. See the error message(s) above..
Check
> the trans.log from R3trans -x
> the listener.ora
> the tnsnames.ora
> the sqlnet.ora
> the listener.log
> the environment variables of <sid>adm and ora<sid>
Check the result of the following:
lsnrctl status
tnsping <SID>
connect /@<SID>
Regards,
Vincent
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vincent ,
Thanks for your reply.
Listener is not running and ends up with error
TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
System parameter file is /oracle/HRD/112_64/network/admin/listener.ora
Log messages written to /oracle/HRD/112_64/log/diag/tnslsnr/sapdv24/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=HRD)))
Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=HRD)(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
IBM/AIX RISC System/6000 Error: 68: Can't assign requested address
with tnsping I am getting the following
orahrd> tnsping HRD
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 06-OCT-2011 04:45:31
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
/oracle/HRD/112_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = HRD) (PORT = 1527))) (CONNECT_DATA = (SID = HRD) (GLOBAL_NAME = HRD.WORLD)))
TNS-12535: TNS:operation timed out
check database is running or not then check listener is running or not if running try tnsping command see if it replied by oracle or not.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.