Question:
Hi Guys,
Im installing SAP IDES 4.7 on W2003 enterprise, DB oracle 9i with patches 9.2.0.4.0
During the installation of Database instance, error occured for step "Database load(post processing)".
I did try to started the service for Listener and ORAIDEservice, but i still can not get rid out of the prob.
This is the sqlnet log file:
*****************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(SDU=32768)(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=sapides47)(PORT=1527))(CONNECT_DATA=(SID=IDE)(GLOBAL_NAME=IDE.WORLD)(CID=(PROGRAM=E:\usr\sap\IDE\SYS\exe\run\R3load.exe)(HOST=SAPIDES47)(USER=ideadm))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.2.0 - Production
Time: 27-APR-2016 11:42:09
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 538
TNS-00538: Message 538 not found; product=NETWORK; facility=TNS
nt secondary err code: 65
nt OS err code: 0
**********************************************************
After the problem above occured, i found out below:
1. can not ping <hostname>, error "host unreachable".
2. can not tnsping <hostname>, error "TNS:protocol adapter error".
Im using "sapides47" as my hostname for SAP and Oracle. While for computer name is SAPIDES47.
I did double check on my HOSTS file, it is correct. This is my entry added at HOSTS file:
192.168.1.2 sapides47 SAPTRANSHOST
192.168.1.2 -> is the IP address used for my server
sapides47 -> i did tried on big caps, but still can not ping
Im confuse and blur now, because mixing up the problem.
Need your expert comment here.
Thanks in advance.
Answer:
>1. can not ping <hostname>, error "host unreachable".
If you can not ping your own Host ID, then every time you use that Host ID, you will get an error situation.
Check that the hosts file is located under: \<WinDir>\system32\drivers\etc\hosts.
It must contain the entry <IP #> <Host ID> <Possible Alias>.
Try to ping yourself via "ping localhost".
If that one also doesn't work, verify TCP/IP status via "ipconfig /all".
>2. can not tnsping <hostname>, error "TNS:protocol adapter error".
TNS has its own control daemon.
It is called "tnslsnr".
Try to run it as ""tnslsnr status" to verify status.
>Im using "sapides47" as my hostname for SAP and Oracle. While for computer name is SAPIDES47
The host ID should always be spelled *exactly* the same way, including casing.
Normally on Windows it shouldn't matter, but since TCP/IP comes from the Unix world, where casing does matter, you can never be 100% sure.
So better safe than sorry.
It sounds to me like your TCP/IP is not configured right.
If you can't ping localhost and/or ipconfig /all shows up errors, then you need to correct those first before continuing.
Answer:
Hi Odin,
Thanks for your comment.
Below are the attach error on the command that i executed:
1. C:\> tnsping IDE_SAPIDES47
******-----------------------------------------------------------------------------
C:\Documents and Settings\Administrator>tnsping ide_sapides47
TNS Ping Utility for 32-bit Windows: Version 9.2.0.4.0 - Production on 30-APR-20
16 12:35:58
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\oracle\dbides47\ora920\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = sapides47)(PORT = 1527))) (CONNECT_DATA = (SID = IDE) (SERVER = DEDICATE
D)))
TNS-12560: TNS:protocol adapter error
******-----------------------------------------------------------------------------
2. C:\> tnsping IDE
******-----------------------------------------------------------------------------
C:\Documents and Settings\Administrator>tnsping ide
TNS Ping Utility for 32-bit Windows: Version 9.2.0.4.0 - Production on 30-APR-20
16 12:36:33
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\oracle\dbides47\ora920\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 = sapides47)(PORT = 1527))) (CONNECT_
DATA = (SID = IDE) (GLOBAL_NAME = IDE.WORLD)))
TNS-12560: TNS:protocol adapter error
******-----------------------------------------------------------------------------
3. C:\> ping localhost
******-----------------------------------------------------------------------------
TNS Ping Utility for 32-bit Windows: Version 9.2.0.4.0 - Production on 30-APR-20
16 12:34:03
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\oracle\dbides47\ora920\network\admin\sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=localhost)
)(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
******-----------------------------------------------------------------------------
4. C:> lsnrctl status
******-----------------------------------------------------------------------------
C:\Documents and Settings\Administrator>lsnrctl status
LSNRCTL for 32-bit Windows: Version 9.2.0.4.0 - Production on 30-APR-2016 12:37:
51
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=IDE.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.4.0 - Produc
tion
Start Date 30-APR-2016 12:28:02
Uptime 0 days 0 hr. 9 min. 49 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\dbides47\ora920\network\admin\listener.ora
Listener Log File C:\oracle\dbides47\ora920\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDE.WORLDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sapides47)(PORT=1527)))
Services Summary...
Service "IDE" has 1 instance(s).
Instance "IDE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
******-----------------------------------------------------------------------------
5. and this is my host file
******-----------------------------------------------------------------------------
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
127.0.0.1 localhost
192.168.1.2 sapides47 SAPTRANSHOST
******-----------------------------------------------------------------------------
192.168.1.2 is my server's ip address. I did checked so many times where i really can not find the problem. Pls give your opinion.
FYI, before i use the above commands i did make sure that listener and OraServiceIDE is started.
Pls comment.
Thanks in advance.
Answer:
>TNS-12560: TNS:protocol adapter error
Hold it right there.
Your TNS listener is not configured right.
Check the parameter file(s): "listener.ora", "tnsames.ora" and "sqlnet.ora".
You text output posted seems to be mangled.
Please repeat the results for:
"ping localhost"
and
"ipconfig /all"
Also, make sure that the tnslsnr is started.
"tnslsnr start".
"lsnrctl" should have done that by itself, but that sometimes fails.
Answer:
Hi Odin,
I did tried on ping localhost and ipconfig /all. Below are the logs:
ping localhost
*********************************************************
C:\Documents and Settings\Administrator>ping localhost
Pinging sapides47 [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Ping statistics for 127.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
*********************************************************
ipconfig /all
*********************************************************
C:\Documents and Settings\Administrator>ipconfig /all
Windows IP Configuration
Host Name . . . . . . . . . . . . : sapides47
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Broadcast
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
Ethernet adapter Local Area Connection 2:
Media State . . . . . . . . . . . : Media disconnected
Description . . . . . . . . . . . : VIA Rhine II Fast Ethernet Adapter
Physical Address. . . . . . . . . : 00-11-D8-90-E6-BD
*********************************************************
Other than that, i did tried on tnslsnr start, but it doesn't has any effect.
Pls comment.
Thanks in advance.
Answer:
Since your media is disocnnected, I hope you are not referring to any outside Domain Name during the installation.
But you should be able to ping sapides47 (casing!).
Now please check/post the log files under ".../saptrace/background" & ".../saptrace/usertrace" as well as the install log files of SAPinst.
Answer:
Seems your network is not configured right...
Please post the contents of your listener.ora and sqlnet.ora , located under
%ORACLE_HOME%/network/admin.
Rgds,
Claudio
Answer:
I agree that he has some networking issues, but I do not think they are the (only) cause of his problems.
Otherwise the error should have been during the DB CONNECT phase.
But the error orrured during the DB LOAD phase, that is why I think he must also check the "..\usertrace" & "..\background" log files.
Answer:
Hi Odin,
My problem reseolved. Problem was due to during the installation i did not connect my server to network thus it leads to can ping sapides47 all the time. And lead to failed of installing DB instance.
Thanks for the help given.