cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Problem While Installing Enterprice Protal on windows.

Go to solution
Former Member

on ‎10-01-2011 10:22 AM

0 Kudos

Dear Experts,

I am not sure is this the correct category to open this thread or not. badly i need the help from your experiance

I am installing EP CORE On Windows2003 Server, DB is Oracle 10.2.0.2 and it is net weaver 2004s

SR2

Error :

-

ERROR 2011-10-01 12:23:56

CJS-30071 Execution of UTL tool 'C:\j2sdk1.4.2_12\bin\java.exe -classpath C:\usr\sap\DEV\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx256m com.sap.engine.offline.OfflineToolStart com.sap.sl.ut.manager.UtlMain
avinash/sapmnt/DEV/SYS/global/security/lib/tools/iaik_jce.jar;
avinash/sapmnt/DEV/SYS/global/security/lib/tools/iaik_jsse.jar;
avinash/sapmnt/DEV/SYS/global/security/lib/tools/iaik_smime.jar;
avinash/sapmnt/DEV/SYS/global/security/lib/tools/iaik_ssl.jar;
avinash/sapmnt/DEV/SYS/global/security/lib/tools/w3c_http.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/sap.comsl.ut.infoprovider_lib.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/sap.comsl.ut.manager.offline.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/antlr.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/exception.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/jddi.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/logging.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/offlineconfiguration.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/opensqlsta.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/sap.comtcsdtcvlimpl.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/SDMutil.jar;C:/usr/sap/DEV/SYS/global/sltools/sharedlib/SLUtil.jar;C:\usr\sap\DEV\JC00\exe\ojdbc14.jar -activated -prod_name=NetWeaver -usage_name=AS -usage_vendor=sap.com -log=UTL_activate_usages.log -action=true -sid=DEV -dsn=jdbc/pool/DEV -ssprops=C:/usr/sap/DEV/SYS/global/security/data/SecStore.properties -ssk=C:/usr/sap/DEV/SYS/global/security/data/SecStore.key' aborts due to database connection error with return code 64.<br>DIAGNOSIS: The connection parameters are wrong or the database server is shutdown.<br> SOLUTION: Check 'UTL_activate_usages.log' and 'C:/Program Files/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/UTL.java.log' for more information.

when I tried to check the Logs from 'UTL_activate_usages.log' and 'UTL.java.log'

Logs from 'UTL_activate_usages.log:

<!LOGHEADER[START]/>

<!HELP[Manual modification of the header may cause parsing problem!]/>

<!LOGGINGVERSION[1.5.3.7185 - 630]/>

<!NAME[UTL_activate_usages.log]/>

<!PATTERN[UTL_activate_usages.log]/>

<!FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %7s: %m)]/>

<!ENCODING[Cp1252]/>

<!LOGHEADER[END]/>

Oct 1, 2011 9:12:27 AM Info : Successfully parsed!

Oct 1, 2011 9:12:27 AM Info : Executing command Activate...

Oct 1, 2011 9:12:27 AM Info : Establishing DB connection...

Oct 1, 2011 9:12:42 AM Info : Connecting succeeded!

Oct 1, 2011 9:12:42 AM Info : Checking for preconditions..

Oct 1, 2011 9:12:46 AM Info : Usage type state check : usage type AS/sap.com from productNetWeaver is available in the SAP system and there is no record for it in BC_SL_ACTIVE_PARTS

Oct 1, 2011 9:12:46 AM Info : Successfully checked!

Oct 1, 2011 9:12:46 AM Info : Activating usage typeAS/sap.com from productNetWeaver...

Oct 1, 2011 9:12:46 AM Info : Operation successful.

Oct 1, 2011 9:12:46 AM Info : Successfully executed. The cmd call return TRUE. Return code: 0

Oct 1, 2011 11:39:02 AM Info : Successfully parsed!

Oct 1, 2011 11:39:02 AM Info : Executing command Activate...

Oct 1, 2011 11:39:02 AM Info : Establishing DB connection...

Oct 1, 2011 11:39:25 AM Path : Exception : The DataBase is down or the connection parameters are wrong: -sid=DEV -dsn=jdbc/pool/DEV -ssprops=C:/usr/sap/DEV/SYS/global/security/data/SecStore.properties -ssk=C:/usr/sap/DEV/SYS/global/security/data/SecStore.key -keyphrase=null

java.lang.Exception

at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1141)

at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:413)

at com.sap.exception.BaseException.<init>(BaseException.java:302)

at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:96)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:215)

at com.sap.sl.ut.manager.persistence.db.InfoManager.activateUsageType(InfoManager.java:124)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.activateUsageType(DataBaseInfoFactory.java:1063)

at com.sap.sl.ut.manager.command.Activate.execute(Activate.java:44)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:60)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)

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

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

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

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

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

Caused by: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

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

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)

at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:293)

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

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.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connectViaSecureStore(DBConnection.java:159)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connect(DBConnection.java:171)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:213)

at com.sap.sl.ut.manager.persistence.db.InfoManager.activateUsageType(InfoManager.java:124)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.activateUsageType(DataBaseInfoFactory.java:1063)

at com.sap.sl.ut.manager.command.Activate.execute(Activate.java:44)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:60)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)

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

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

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

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

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

-

Logs from UTL.java.log:

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

-

As I could see in the logs Database is Down I was trying to start the Oracle instance it is giving the below error :

C:\Documents and Settings\Administrator>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 1 14:48:12 2011

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name: system

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

-

I am struck at this point could you please help me out how to proceed further or would you need any more details required i am happy to provide.

Thanks Regards,

Avinash I

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎10-01-2011 1:22 PM
0 Kudos 
)
> Caused by: java.sql.SQLException: ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> As I could see in the logs Database is Down I was trying to start the Oracle instance it is giving the below error :
> C:\Documents and Settings\Administrator>sqlplus "/as sysdba"
> 
> SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 1 14:48:12 2011
> 
> Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
> 
> ERROR:
> ORA-12560: TNS:protocol adapter error
> 
> 
> Enter user-name: system
> Enter password:
> ERROR:
> ORA-12560: TNS:protocol adapter error
> 
> Avinash I

Hello Avinash,

Please verify the environment variables for the user sidadm - ORACLE_HOME & ORACLE_SID

Please verify the LISTENER is running or not.

Since this is a windows environment, please verify all the required Oracle services are up or not.

  • You must had patched oracle to latest patch set if not bound to any good reason.

Thanks

Show replies
Show replies

Answers (3)

Answers (3)

Former Member
‎10-02-2011 9:39 AM
0 Kudos

hi even i am not sure about how it went down. In the mean time i am working n that too why it went down.

As i am new bee i am doing up to my extent. still i would need inputs from experts.

Thanks Regards,

Avinash I.

Show replies
Show replies
Former Member
‎10-02-2011 6:27 AM
0 Kudos

HI ,

Thanks to all of you .

I have checked the suggestions you have mentioned above. but every thing was fine all the required env variables was set properly.

I have terminated the installation and i have login through <SID>adm then i have broughtup the database instance and i have started the sapinst again it went smooth without any issues.

Thanks Experts.

Thanks Regards,

Avinash. I

Show replies
Show replies
Former Member
‎10-02-2011 7:49 AM
0 Kudos 
 but every thing was fine 
 i have broughtup the database instance and i have started the sapinst again it went smooth without any issues.
> 
. I

Hello,

Not everything was fine - Database wasn't up !

>>i have broughtup the database instance

The question arises, how it went down ? Anyways, nice to hear you continued with the installation !

Thanks

Former Member
‎10-01-2011 2:44 PM
0 Kudos

Hi Avinash,

Please verify that the oracle has been installed correctly, along with the required patches.

Also confirm that the listener and other oracle services are running properly and that the required env variables are set for the DB user.

Follow the installation guide and you should be good. Good luck

Regards,

Varun

Show replies
Show replies
Ask a Question