1748074 Members
5356 Online
108758 Solutions
New Discussion юеВ

Re: START SAP

 

START SAP

HI,
I recover whole offline backup dbs and through sql prompt i open the db.initally there are some problems with control files but now my db is OPEN.
now by sidadm user i try to start the SAP by using command --startsap. but it returns error(Log file STARTDB.LOG) is attach.
to solve the error i did
--R3trans -d
which create another log file named trans

--even after DB can Open and file permissions are right i unable to start sap

-- sap ecc 5.0, oracle 9.2,HPUX os, is in use
-- any info requires then provide
plz help me in start sap

thanks ...!
15 REPLIES 15

Re: START SAP

Hi
trans log file is attach here




Thanks...!
Jean-Luc Oudart
Honored Contributor

Re: START SAP

can you post the alert log file (or extarct for today) to check any oracle error.

your log suggests there is an issue starting oracle.
#
Regards
Jean-Luc
fiat lux
Volker Borowski
Honored Contributor

Re: START SAP

Hi,

this message
DlLoadLib: dlopen()= Unable to find library 'libclntsh.so.9.0

Looks like some of your filesystem stuff
may not fully been recoverd from your crash.

Please check
- environment for user gmdadm, so in case the HOME of gmdadm was lost in your crash, you might need to re-adjust the environment.

- binaries of SAP Kernel
-> /sapmnt/GMD/exe...
should be present, if faulty, download corresponding kernel archives for your platform from SAPNET and extract freshly.

- Oracle client SW in /oracle/client/92x_64
if not present -> download from SAPNET.
Watch it when extracting, needs to be done in correct location. There is a special sapnote for installing the 9.2 client SW.



So far it looks like R3trans can not resolve some shared libs. Either they are not there or the library path does not resolve them due to faulty environment.

Interesting output would be (done as gmdadm)

ls -l /oracle/client/92x_64
env


Volker

Re: START SAP

hi sir

here is attachment of my alert_sid.log file
and trans.log file after changing some env path


plz go through it and reply as early as possible


thanks...!


Re: START SAP

hi

this is trans log file after some changes in env file



pankaj
Volker Borowski
Honored Contributor

Re: START SAP

ok,

and what changes did you do ?????

It still complains about not finding the
client shared libraray.
So you need to work on that.
Is the lib in place in the .../92x_64 dir?
Is the libpath pointing to that directory.
Did you check put the note for the client sw
(think it was #539922 )

Volker

Re: START SAP

hi
this is my env through oracle user(ORAGMD)


plz check it


pankaj

Re: START SAP

Hi this is my env through ADM user
(GMDADM)


pankaj

Re: START SAP

hi

this is env through root user

in this env i try to change
LD_libray_path=
LD_LIBRARY_PATH=/oracle/GMD/920_64/lib64:/usr/lib:/oracle/GMD/920_64/rdbms/lib:/oracle/GMD/920_64/network/lib

to
LD_LIBRARY_PATH=/oracle/GMD/920_64/lib:/usr/lib:/oracle/GMD/920_64/rdbms/lib:/oracle/GMD/920_64/network/lib

but it restore the original one
and error message is same
all the location are at the same place as mention..

pankaj