AnsweredAssumed Answered

Oracle error in Service Desk

Question asked by rkalidh87 on Jun 19, 2015
Latest reply on Jun 19, 2015 by rkalidh87

Hi,

 

Am trying to install SD 12,5 in Solaris machine with Oracle 11 G DB. while running PDM_Configure am getting below error in logs.

 

Able to connect DB via SQLPLUS.

 

06/19 10:44:27.396 INFO  SetupMDB.java          240 Starting Setup MDB...

06/19 10:44:27.400 INFO  SetupMDB.java          390 The command is /bin/sh /opt/CA/ServiceDeskManager/add-ons/mdb/oracle/setupmdb.sh -PRECHECK -DBVENDOR=oracle -DBDRIVER=Service_Desk -WORKSPACE=Service_Desk -DBHOST=testserver -DBNAME=MDB -DBPORT=1521 -ORA_SERVICE_NAME=MDB -DBUSER=SYS -DBPASSWORD=mdbadmin -MDB_ADMIN_PSWD=mdbadmin -ORA_TBLSPACE_PATH=/emstest/Oracle/app/oracle/oradata/MDB -JRE_DIR=/opt/CA/SharedComponents/JRE/1.6.0_00 -MDB_TARGET_DIR=/opt/CA/ServiceDeskManager/temp/mdb_oracle -MDB_COMMON_DIR=/opt/CA/SharedComponents/Mdb

06/19 10:44:27.402 INFO  ProcessUtilities.java   424 Executing command:  /bin/sh /opt/CA/ServiceDeskManager/add-ons/mdb/oracle/setupmdb.sh -PRECHECK -DBVENDOR=oracle -DBDRIVER=Service_Desk -WORKSPACE=Service_Desk -DBHOST=testserver -DBNAME=MDB -DBPORT=1521 -ORA_SERVICE_NAME=MDB -DBUSER=SYS -DBPASSWORD=<SYS PASSWORD> -MDB_ADMIN_PSWD=<MDB PASSWORD> -ORA_TBLSPACE_PATH=/emstest/Oracle/app/oracle/oradata/MDB -JRE_DIR=/opt/CA/SharedComponents/JRE/1.6.0_00 -MDB_TARGET_DIR=/opt/CA/ServiceDeskManager/temp/mdb_oracle -MDB_COMMON_DIR=/opt/CA/SharedComponents/Mdb

06/19 10:44:30.408 INFO  SetupMDB.java          448 DATE=2015-06-19

06/19 10:44:30.439 INFO  SetupMDB.java          448 TIME=10:44:30.00

06/19 10:44:30.501 INFO  SetupMDB.java          448 MDB_DESTINATION=/opt/CA/SharedComponents/Mdb/Solaris

06/19 10:44:30.503 INFO  SetupMDB.java          448 MDB_TARGET_DIR=/emstest/ServiceDesk/temp/mdb_oracle

06/19 10:44:33.786 INFO  SetupMDB.java          448 NUMBER_CONNECTIONS=1

06/19 10:44:33.788 INFO  SetupMDB.java          448 CONNECTION_LIST=SYS

06/19 10:44:33.789 INFO  SetupMDB.java          448 CREATING_MDBADMIN=yes

06/19 10:44:33.790 INFO  SetupMDB.java          448 CREATING_DATA_TBLSPACE=MDB_DATA

06/19 10:44:33.792 INFO  SetupMDB.java          448 CREATING_DATA_TBLSPACE_SIZE=400

06/19 10:44:33.793 INFO  SetupMDB.java          448 CREATING_INDEX_TBLSPACE=MDB_INDEX

06/19 10:44:33.794 INFO  SetupMDB.java          448 CREATING_INDEX_TBLSPACE_SIZE=100

06/19 10:44:35.924 INFO  SetupMDB.java          448 ERR_MESSAGE=Unable to connect to the database

06/19 10:44:35.925 INFO  SetupMDB.java          448 ERR_INFO=Url: jdbc:oracle:thin:@//localhost:1521/MDB

06/19 10:44:35.927 INFO  SetupMDB.java          448 ERR_INFO=User: SYS

06/19 10:44:35.928 INFO  SetupMDB.java          448 ERR_INFO=ErrorCode: 17002

06/19 10:44:35.930 INFO  SetupMDB.java          448 ERR_INFO=Io exception: The Network Adapter could not establish the connection

06/19 10:44:36.288 INFO  SetupMDB.java          448 RC=17

06/19 10:44:36.539 INFO  ProcessUtilities.java   572 Process /bin/sh completed with exit code 17

06/19 10:44:36.542 ERROR SetupMDB.java          468 Setup MDB returns code 17

06/19 10:44:36.544 ERROR SetupMDB.java          489 MDB RC   : 17

06/19 10:44:36.546 ERROR SetupMDB.java          490 MDB Error: Unable to connect to the database

06/19 10:44:36.548 ERROR SetupMDB.java          491 Check mdb logs at /opt/CA/ServiceDeskManager/temp/mdb_oracle.

06/19 10:44:36.550 ERROR OracleDatabasePage.java   712 SetupMDB returned: Unable to connect to the database

 

 

 

please help to fix this.

Outcomes