NW70 Installation Error - Central Instance

[Former Member]

Hi All

I am trying to install the EP & BI and successfully finished Central Services Instance and and Database Instance, and when I started installing the Central Instance on App Server, after I entered the path of Oracle Client and click on next its throwing the error, Please see few lines of error:

-

---

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:149)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:236)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)

at com.sap.inst.jsourcecheck.TaskProcessor.process(TaskProcessor.java:69)

at com.sap.inst.jsourcecheck.SourceChecker.doRun(SourceChecker.java:217)

at com.sap.inst.jsourcecheck.SourceChecker.run(SourceChecker.java:146)

at com.sap.inst.jsourcecheck.JSourceCheck.startAppJob(JSourceCheck.java:231)

at com.sap.inst.lib.app.CommandLineApp.doMain(CommandLineApp.java:111)

at com.sap.inst.jsourcecheck.JSourceCheck.main(JSourceCheck.java:252)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:302)

... 17 more

-

---

Can you please check this and give your suggestions to solve this

Thanks

Sri

[Former Member]

Hello Srikar,

Every SAP system would have one central instance only. You can have multiple dialog instances (or "application servers"). I think there is some confusion here.

With Regards.

Ruchit.

[Former Member]

Hi

I am doing a Distributed system Installation, so firstly I have installed Central Services Instance(SCS) on Application Server, Database Instance on Database Server successfully, now I am coming back to Application Server and doing a Central Instance where I am getting struck.

Is this the right approach ?

Thanks

Srikar

[Former Member]

Hello Srikar,

Let me check this.

Regards.

Ruchit.

[Former Member]

Hello Srikar,

Just for clarification what kind of installation are you doing. Is that ABAP+JAVA or JAVA stand alone ?

Regards.

Ruchit.

[Former Member]

Hi All

I am trying to do a Distributed System Based on AS ABAP & AS JAVA, when we select this option we have 3 steps to go:

1. Central Services Instance (SCS)

2. Database Instance

3. Central Instance

I am done with step 1 on application host (i.e server, we have 2 servers for this), and step 2 on database host, now for the step 3 I have logged on the application host and started the Central Instance installation, when I am trying to give the path of Oracle Client its throwing the error listed above.

I hope the scenario is clear now.

Thanks

Sri

[Former Member]

Hello Srikar,

Are you able to connect to be database server from application host ?

Also is your database up and running ?

Regards.

Ruchit.

[Former Member]

Hi Ruchit

Database is up and running, I could login and do a select statement also.

When I ping the DB IP from APP its successful.

Thanks

Sri

[Former Member]

Hello Srikar,

One thing since you are using ABAP+JAVA what about ASCS installation ?

Regards.

Ruchit.

[Former Member]

Hi Ruchit ASCS installation is only required for High Availability installation right. I am not doing a High Availability Installation here.

Thanks

Sri

[Former Member]

Hello Srikar,

Yeah that is right.

Regards.

Ruchit.

[Former Member]

Hi Srikar,

Did you give correct details of DB server and message server details, also check if your listner is up.

Regards

KVR

[Former Member]

Hi Ruchit I was just checking some other log files, actually the APP server is trying to call the DB server name with the hostname, but we have not included the IP's in DNS, so we need to change the hostname to IP address. See the below error in system.log file:

-

---

#1.5^H# #1221844546278#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[main,5,main]##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#17002#<null>#Io exception: The Network Adapter could not establish the connection#jdbc:oracle:thin:@omtr-sap-ddbp:1527:DBP#<null>#

-

---

Is there anything that we need to change the jdbc:oracle:thin string ?

Thanks

Sri

[Former Member]

Hi KVR Listener is up and running and my concern is only the DB hostname ? System is picking up the hostname where it can not resolve the hostname, let me know where all do I need to change the hostname to DB IP address ?

Thanks

[Former Member]

check what is given in listener.ora, /oracle/<SID>/102_64/network/admin

[Former Member]

Hi KVR it was the hostname which was there in tnsnames.ora, I changed it to the IP address of DB server and retried, again its still failing with the same error. Please suggest.

Thanks

Sri

[Former Member]

what is the port number in both the cases, did you check the listener.ora?

[Former Member]

Its 1527, below is the stuff from listener.ora

-

---

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DBP.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DBP)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = omtr-sap-ddbp)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = DBP)

(ORACLE_HOME = /oracle/DBP/102_64)

)

)

-

---

Thanks

Sri

[Former Member]

omtr-sap-ddbp is your dbhost?

[Former Member]

Oops Sorry guys, the problem was resolved after adding the IP's of DB hostname in the DNS by resolving the IP's of DB host.

Thanks for all the Inputs !!!

Regards

Sri

[Former Member]

Why are you installing central instance on app server?