Error initializing database engine

[Former Member]

Hey Techies,

On MDM application server, we have completed:

1. Oracle Client 10.2.0.1 installation

2. MDM/MDS/MDIS 5.5 SP06 Hotfix 9 installation.

tnsping to the DB server is successful.

NOTE: MDM Application and DB server are on different host

- > Following env settings are done on MDM application server:

LD_LIBRARY_PATH=/mdmmdmopt/MDM/lib:/usr/local/lib/sparcv9:/oracle/product/10.2.0/client_1/lib:/oracle/product/10.2.0/client_1/instantclient/:/oracle/product/10.2.0/client_1/instantclient32/

LIBPATH=/mdmopt/MDM/lib:/usr/local/lib/sparcv9:/oracle/product/10.2.0/client_1/lib:/oracle/product/10.2.0/client_1/instantclient/:/oracle/product/10.2.0/client_1/instantclient32/

LIBRARY_PATH=/mdmopt/MDM/lib:/usr/local/lib/sparcv9:/oracle/M30/lib:/oracle/M30/instantclient_10202

LOGNAME=mdm

MAIL=/var/mail/mdm

MDM_HOME=/mdmopt/MDM

ORACLE_HOME=/oracle/product/10.2.0/client_1/

PATH=/mdmopt/MDM/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/oracle/product/10.2.0/client_1/bin

SHELL=/usr/bin/sh

SHLIB_PATH=/mdmopt/MDM/lib::

But, from the MDM console, when we are trying to Unarchive the repository after giving the database authentication dertails, the system is prompting with the following error: "Error initializing database engine".

Please revert with the feasible solutions for the stated problem.

[Former Member]

1) Please make sure that your database and listener is up and running.

2) You will have to create "DBMS Server" on MDM console with same name as Oracle instance ID. This you should get in same dialog box (i.e. Unarchive repository)

3) Then, provide User Id and password to connect to database.

I think you are not doing one of the above 3 steps correctly.

Thanks,

Bhushan

[Former Member]

Hey Techies,

Please refer the following lines from the logfile:

<Open ts-long="11:33:39 GMT, Thursday, June 26, 2008" ts="2008/06/26

11:33:39.067 GMT" pid="14555" host="MDMP" compile-type="RELEASE

_32">

<Version ts="2008/06/26 11:33:39.066 GMT" tid="1" entry-no="0"><Server>5.5.62.58</Server><Build>Built on 2008-Jun-06</Build>

<Repository major="1" minor="264"/></Version>

<Trace ts="2008/06/26 11:33:39.069 GMT" tid="1" entry-

no="3">mds Configured for CPU Count of 1<LF/></Trace>

<Trace ts="2008/06/26 11:33:39.081 GMT" tid="1" entry-

no="4">NCS Library &apos;ncs.so&apos; loaded successfully</Trace>

<Error ts="2008/06/26 11:33:40.209 GMT" tid="1" entry-

no="5">Unable to register server in System Landscape Directory: Call t

o SLDREG Utility in /usr/sap/sldreg failed, Error = 0x100.<LF/>Set

proper value for parameter &apos;SLDReg Utility Path&apos; in server

conf

iguration file.<LF/>If you are not using SLD, set parameter &apos;SLD

Registration&apos; to false in server configuration file so that the s

erver does not try to register with SLD. This will avoid this error in

the future.</Error>

<Error ts="2008/06/26 11:34:44.667 GMT" tid="8" entry-

no="7">Oracle Initialization Failed -- likely missing libraries/dlls</

Error>

<Error ts="2008/06/26 11:34:44.667 GMT" tid="8" entry-

no="8">OCI Init</Error>

<Error ts="2008/06/26 11:34:44.667 GMT" tid="8" entry-

no="9">ERROR CODE=-1 ||| Failed to intitialize Oracle shared library.<

LF/>Last CMD: <LF/></Error>

<Error ts="2008/06/26 11:34:44.669 GMT" tid="8" entry-

no="10">ERROR CODE=-1 ||| Failed to intitialize Oracle shared library.

<LF/>Last CMD: <LF/></Error>

-

---

We are using OS:Solaris 10.

We have set the SLD to false in MDS.ini file.Please suggest if any more changes need to be done in the file.

As per the MDM instguide, we have also made soft links in the Oracle client home/lib.

But, still we are facing the same error.

Kindly, help to resolve it further.

Please suggest, if any changes need to be made w.r.t the environment variables.

[Former Member]

Hi Aakash,

Here as per my understanding problem is while suppying userid, password and Database instance name it is not able o understand DB instance name. If you supply the host name of the instance some times it will correct the problem.

if you are using MSSQL then you can see your error in SQL instance folder called SQL Log files.In Log file you can see the exact error also.based on error you can correct it.

Please try to supply the host name or IP address of DB instance you may overcome this problem.

Hope it helps you.

Regards,

RDNPrasad.