on 11-05-2009 5:20 AM
Dear Experts,
i am new to unix, we are using ecc5.0 on hp-ux platform.we have two system landscape development and production.actually my problem is with development server..2 days back system got struct up.i tried to ping the server ip its pinging fine.and i tried to open telnet but its not connecting.i tried to shutdown the unix server but it says no command.after that i manually shutdown the system after getting proper approval.
After restarting server it is connecting through telnet .
i triied to start the service by command But it showing like this
#startsap all
sh:sapstart :not found
cd /usr/sap
ls
KBackup SP_17_20 TPD hot index.log oracopy sapmnt tmp tpdadm1
KKK SSS devux.log index.full lost+found put templog tpdadm trans
cd /usr/sap/tpd
sh: /usr/sap/tpd: not found.
Message is showing like this .i cannot acess that SID folder.
Even i wast trying to find dev_w0 file but i am not getting that,
What process i have to check please tell me in step by step.
please help me in this regard.
Regards,
Naveen
Edited by: Naveen N on Nov 5, 2009 10:57 AM
Edited by: Naveen N on Nov 5, 2009 10:58 AM
restored backup..and started the services..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naveen,
Just a suggetion: Then you may close this thread....this will allow the experts to divert their looks.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We have replaced backup into the system and the system got up..
Sorry, i thought that you have restored entire system(from source)....anyway good work!
Check why the mount point got corrupted, may help you to avoid the same in future.
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do we recover the same file which is not visible in the path..
Ex:
/usr/sap/SID/TPD
In TPD we have DVEBMGS00 and SYS...Where SYS folder doesnt visible in the same folder,. can we recover without backup the files in unix.??
why not Naveen.....just try to understand(have a look in other system) what exactly SYS contains....those you can easily resore/copy from some other system and rename.
And there would be some disk failure or something if you lost these particular FS(if it is seperate mount point)....check the same from your side(take help from OS admin).
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We have replaced backup into the system and the system got up..
Big adventure for a small problem
Issue seems related to typological error when tried to access SID, *nix is case sensitive and cannot identify the SID with sid.
And suggesting you to read the *nix fundamentals on permissions.
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Roy,
I don't think this as a small issue because This is not related to case sensitive issue.this happens while system is running all files are there once stopped it is not there in the path...Even i tried and searched for it.i search with case sensitive before restoring backup...
Do we recover the same file which is not visible in the path..
Ex:
/usr/sap/SID/TPD
In TPD we have DVEBMGS00 and SYS...Where SYS folder doesnt visible in the same folder,. can we recover without backup the files in unix.??
regards,
Naveen
Unix is case sensitive so to access /usr/sap/TPD you must cd /usr/sap/TPD. The dev_w0 file will be located in /usr/sap/TPD/DVEBMGS*/work
As mentioned you start sap using your tpdadm user not root.
--
Nelis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I tried With tpdadm user it is going upto /usr/sap after that it is not going furthur.
su tpdadm
$ cd usr/sap
$ ls
KBackup SSS hot lost+found sapmnt tpdadm
KKK TPD index.full oracopy templog tpdadm1
SP_17_20 devux.log index.log put tmp trans
$ cd usr/sap/tpd
su: usr/sap/tpd: not found.
$ cd usr/sap/TPD
su: usr/sap/TPD: not found.
$
Please check it..
Naveen
Try with below command
su - tpdadm
<hostname>:tpdadm 1% startsap ---> it starts DB as well as SAP
<hostname>:tpdadm 1% startsap r3 -
> If DB is already started
<hostname>:tpdadm 1% stopsap -
> It stops DB as well as SAP
<hostname>:tpdadm 1% stopsap r3 ---> Stops only SAP Application
To check whether SAP is started or not
<hostname>:tpdadm 1% ps -ef | grep TPD ---> it will shows all the process related with TPD SID - dw work process
Edited by: Mahesh Chedde on Nov 5, 2009 9:44 AM
Hi Naveen
You are trying to access as
# su tpdadm
$ cd usr/sap
$ ls
KBackup SSS hot lost+found sapmnt tpdadm
KKK TPD index.full oracopy templog tpdadm1
SP_17_20 devux.log index.log put tmp trans
here TPD directory exists.(all capital letters)
so either try as1.
$cd TPD (not /TPD)
2.
or $ cd /usr/sap/TPD (not usr/sap/TPD)
not as
$ cd usr/sap/tpd
su: usr/sap/tpd: not found.
$ cd usr/sap/TPD
su: usr/sap/TPD: not found
With Regards
Supriya
Dear Experts,
Iam posting all logs please check and help me in this regard..
devux:tpdadm> cat trans.log
4 ETW000 R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 09.11.2009 - 12:59:47
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Mon Nov 9 12:59:47 2009
1149 0.001149
4 ETW000 [dev trc ,00000] db_con_init called
39 0.001188
4 ETW000 [dev trc ,00000] create_con (con_name=R/3)
272 0.001460
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/TPD/SYS/exe/run/dbo
raslib.sl' ...
4 ETW000
130 0.001590
4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Unable to find
library 'libclntsh.sl.9.0'. -> DLENOACCESS (0,Error 0)
4 ETW000
1717 0.003307
4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/TPD
/SYS/exe/run/dboraslib.sl'
4 ETW000
44 0.003351
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY
('/usr/sap/TPD/SYS/exe/run') or dbms_type ('ORA')"
devux:tpdadm> R3trans -d
This is R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY
('/usr/sap/TPD/SYS/exe/run') or dbms_type ('ORA')"
R3trans finished (0012).
devux:tpdadm> env
_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/u
sr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:
/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/o
pt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/
man:/opt/mx/share/man:/usr/dt/share/man:/opt/samba/man:/opt/resmon/share/man:/op
t/scr/share/man://opt/perl/man:/opt/graphics/common/man:/opt/hparray/share/man/%
L:/opt/hparray/share/man:/opt/hpnpl//man
THREAD=NOPS
SHLIB_PATH=/usr/sap/TPD/SYS/exe/run:/usr/sap/TPD/SYS/exe/runU
ORACLE_PSRV=TPD
PATH=/usr/sap/TPD/SYS/exe/runU:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparr
ay/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11
:/usr/contrib/bin/X11:/opt/mx/bin:/opt/resmon/bin:/opt/scr/bin:/opt/ignite/bin:/
/opt/perl/bin:/opt/graphics/common/bin:/usr/sbin/diag/contrib:/opt/hpnpl//bin:/o
racle/TPD/920_64/bin:/usr/sap/TPD/SYS/exe/run:/home/tpdadm:.
NLS_LANG=AMERICAN_AMERICA.WE8DEC
COLUMNS=80
ORACLE_BASE=/oracle
EDITOR=vi
LOGNAME=tpdadm
dbs_ora_tnsname=TPD
ORACLE_SID=TPD
ERASE=^H
PS1=devux:tpdadm>
DB_SID=TPD
DIR_LIBRARY=/usr/sap/TPD/SYS/exe/run
ORA_NLS=/oracle/TPD/920_64/ocommon/NLS_723/admin/data
dbs_ora_schema=SAPR3
SHELL=/usr/bin/sh
ORA_NLS32=/oracle/TPD/920_64/ocommon/NLS_733/admin/data
SAPDATA_HOME=/oracle/TPD
ORA_NLS33=/oracle/TPD/920_64/ocommon/nls/admin/data
HOME=/home/tpdadm
TERM=ansi
ORACLE_HOME=/oracle/TPD/920_64
PWD=/home/tpdadm
TZ=IST-5:30
dbms_type=ORA
SAPSYSTEMNAME=TPD
LINES=60
devux:tpdadm> ps -ef | grep saposcol
tpdadm 21937 21677 0 08:51:55 pts/tb 0:00 grep saposcol
tpdadm 3580 1 0 Nov 6 ? 3:04 saposcol -l
devux:tpdadm> saposcol -l
-l
08:52:46 10.11.2009 LOG: Effective User Id is root
***********************************************************************
This is Saposcol Version COLL 20.95 640 - V2.7.0 2008-03-12 HP-UX PA-RISC
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 3580) is already running .....
************************************************************************
Naveen
Dear Experts,
Iam posting all logs please check and help me in this regard..
devux:tpdadm> cat trans.log
4 ETW000 R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 09.11.2009 - 12:59:47
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Mon Nov 9 12:59:47 2009
1149 0.001149
4 ETW000 [dev trc ,00000] db_con_init called
39 0.001188
4 ETW000 [dev trc ,00000] create_con (con_name=R/3)
272 0.001460
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/TPD/SYS/exe/run/dbo
raslib.sl' ...
4 ETW000
130 0.001590
4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Unable to find
library 'libclntsh.sl.9.0'. -> DLENOACCESS (0,Error 0)
4 ETW000
1717 0.003307
4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/TPD
/SYS/exe/run/dboraslib.sl'
4 ETW000
44 0.003351
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY
('/usr/sap/TPD/SYS/exe/run') or dbms_type ('ORA')"
devux:tpdadm> R3trans -d
This is R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY
('/usr/sap/TPD/SYS/exe/run') or dbms_type ('ORA')"
R3trans finished (0012).
devux:tpdadm> env
_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/u
sr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:
/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/o
pt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/
man:/opt/mx/share/man:/usr/dt/share/man:/opt/samba/man:/opt/resmon/share/man:/op
t/scr/share/man://opt/perl/man:/opt/graphics/common/man:/opt/hparray/share/man/%
L:/opt/hparray/share/man:/opt/hpnpl//man
THREAD=NOPS
SHLIB_PATH=/usr/sap/TPD/SYS/exe/run:/usr/sap/TPD/SYS/exe/runU
ORACLE_PSRV=TPD
PATH=/usr/sap/TPD/SYS/exe/runU:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparr
ay/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11
:/usr/contrib/bin/X11:/opt/mx/bin:/opt/resmon/bin:/opt/scr/bin:/opt/ignite/bin:/
/opt/perl/bin:/opt/graphics/common/bin:/usr/sbin/diag/contrib:/opt/hpnpl//bin:/o
racle/TPD/920_64/bin:/usr/sap/TPD/SYS/exe/run:/home/tpdadm:.
NLS_LANG=AMERICAN_AMERICA.WE8DEC
COLUMNS=80
ORACLE_BASE=/oracle
EDITOR=vi
LOGNAME=tpdadm
dbs_ora_tnsname=TPD
ORACLE_SID=TPD
ERASE=^H
PS1=devux:tpdadm>
DB_SID=TPD
DIR_LIBRARY=/usr/sap/TPD/SYS/exe/run
ORA_NLS=/oracle/TPD/920_64/ocommon/NLS_723/admin/data
dbs_ora_schema=SAPR3
SHELL=/usr/bin/sh
ORA_NLS32=/oracle/TPD/920_64/ocommon/NLS_733/admin/data
SAPDATA_HOME=/oracle/TPD
ORA_NLS33=/oracle/TPD/920_64/ocommon/nls/admin/data
HOME=/home/tpdadm
TERM=ansi
ORACLE_HOME=/oracle/TPD/920_64
PWD=/home/tpdadm
TZ=IST-5:30
dbms_type=ORA
SAPSYSTEMNAME=TPD
LINES=60
devux:tpdadm> ps -ef | grep saposcol
tpdadm 21937 21677 0 08:51:55 pts/tb 0:00 grep saposcol
tpdadm 3580 1 0 Nov 6 ? 3:04 saposcol -l
devux:tpdadm> saposcol -l
-l
08:52:46 10.11.2009 LOG: Effective User Id is root
***********************************************************************
This is Saposcol Version COLL 20.95 640 - V2.7.0 2008-03-12 HP-UX PA-RISC
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 3580) is already running .....
************************************************************************
Naveen
Hi
ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Unable to find
library 'libclntsh.sl.9.0'. -> DLENOACCESS (0,Error 0)
Check the OSS Note 538849 - UNIX: DLENOACCESS when loading dboraslib and libclntsh. This will resolve your issue.
also check Note 403004 - Database connect using R3trans fails
Also check your environment varriables are correctly set as per oss Note 180430 - Installing the ORACLE client software for UNIX
Hope this helps.
Thanks,
Shambo
Dear Naveen,
Please follow [this Link|http://help.sap.com/saphelp_nw70/helpdata/en/5d/c4dd9b9d91dd458e9e5c0386edeb86/content.htm].
Start your sap system by switching to <SID>adm user.
Regards,
Bhavik G. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.