START SAP

[Pankaj K. Bharne]

hi
this is my startdb.log
/home/gmdadm/startdb.log


pankaj

[Pankaj K. Bharne]

hi after doing R3trans -d
the new log file generated named trans.log
which is attach ...


pankaj

[Volker Borowski]

Hi,

the trans.log is not complaining about missing libs anymore. What did you do to fix it?

Environment for gmdadm and oragmd looks OK to me.

Environment for root is not relvant, because
you should not do anything with root which is realated to SAP.
Your root-Environment has a bug concerning
the SHLIB_PATH/LD_LIBRARAY_PATH and ORA_NLS33 setting, but again, it is not relevant, as you should not do anything with this.

So you did

su - oragmd
lsnrctl start
exit
su - gmdadm
R3trans -d

???

This seems weird to me. It should work.
What about your ORACLE_HOME location. Has it been affected by your previous disk corruption, or can you safely assume it is OK?

Does it work to do as gmdadm

sqlplus /
select * from SAPUSER
exit

If this does not work, does

sqlplus sapr3/sap
exit

work out ok as gmdadm.

If either of the two work, I am lost.
I'd start refreshing R3trans then.

Volker

[Pankaj K. Bharne]

Hi volkar..!
yes ORACLE_HOME=oracle/GMD/920_64
its ok....!

and yes i did
su oragmd
lsnrctl start

su gmdadm
(initially i did STARTSAP but it displayed too many messages related to db an R3trans )
so i did
R3trans -d
(it also gives error message which log file is already attach)one important thing that after performing this command or startsap,it at the same time if db stared then it shut automatically and gives error message

--ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
HPUX-ia64 Error: 13: Permission denied

then i restared the SERVER
and start db again through sql (oragmd)
--DB open fine

now i did another option ie
R3trans -x
it display another set of error message which are attach here.

now as u told i login with gmdadm and sqlprompt and did
sql>startup
then it displyed same error
ORA 27121
and HP ux permission denied

BUT with Oragmd user
the db is already started and work fine.
ie su oragmd
sql>startup
alreday stared ....
sql>archive log list
it disply all details properly

so now with gmdadm db is not stared but oragmd it was alreday stared and work fine...

so wht to do now sir...??

plz reply sir.

Thanks

[Jean-Luc Oudart]

Hi

there is an issue using your listener. It's either down or your configuration (SAP) does not match the listener config.

When you access oracle directly it woks. You should try over SQLnet (eg sqlplus /@) to narrow down the pb.
>>> ETW000 [dblink ,00428] ***LOG BY0=>ORA-12541: TNS:no listener

Regards
Jean-Luc

[Pankaj K. Bharne]

HI....

I Got the solution.....

there is absence of tnsnames.ora and sqlnet.ora which are used for a connet are always loacted on the host on which the link of a client(such as R3) is requested. i refer
--sap note 491174
--sap note 445038
--sap note 395514
--sap note 583861
also change the permission and ownship of /$ORACLE_HOME/bin which is
--chmod 6751 oracle
--chown ora(sid) oracle
--chgrp dba oracle

the critical problem is solved...now


thanks to everyone

-- special thanks to volker..

thanks again


Pankaj..!