on 03-17-2011 11:22 AM
Dear Experts,
Our production system rebooted due to some electricity issue and since then we are not able to start SAP. We are on oracle 10g and AIX OS. We have done all the options but no avail.
Following is screen output when I run command : "startsap".
startsap
Checking ABC Database
----
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
----
*************************************************************************
This is Saposcol Version COLL 20.94 700 - AIX v10.35 5L-64 bit 070123*
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 884754) is already running .....*
**************************************************************************
saposcol already running
Running /usr/sap/ABC/SYS/exe/run/startdb
Trying to start ABC database ...
Log file: /home/ABCadm/startdb.log
No SQLNet V2 connect to ABC available.*
Check that the listener is running: "lsnrctl status".
Start the listener as user oraABC: "lsnrctl start".
/usr/sap/ABC/SYS/exe/run/startdb: Terminating with error code 14
DB startup failed
prodserver:ABCadm 2>
Any help & advice to solve this issue will be appreciated.
Thanks Mark for your Help
I have checked Oracle Home directory. But I didn't find any file related to your suggestion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mark
As I am Novice user, however I have check /oracle/SID/ directory for .sapenv., .dbenv. files but I didn't find any file.
Then I have executed "env" command as a "root", Output is written below.
env
_=/usr/bin/env
MABCATH=/usr/dt/man:/usr/share/man
SESSIONTYPE=dt
DTDATABASESEARCHPATH=//.dt/types,/etc/dt/appconfig/types/%L,/etc/dt/appconfig/types/C,/usr/dt/appconfig/types/%L,/usr/dt/appconfig/types/C
LANG=en_US
LOGIN=root
G_BROKEN_FILENAMES=1
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/dt/bin:/usr/bin/X11:/sbin:/usr/java14_64/jre/bin:/usr/java14_64/bin
DTUSERSESSION=root-192.168.0.180-0
XMICONBMSEARCHPATH=//.dt/icons/%B%M.bm://.dt/icons/%B%M.pm://.dt/icons/%B:/etc/dt/appconfig/icons/%L/%B%M.bm:/etc/dt/appconfig/icons/%L/%B%M.pm:/etc/dt/appconfig/icons/%L/%B:/etc/dt/appconfig/icons/C/%B%M.bm:/etc/dt/appconfig/icons/C/%B%M.pm:/etc/dt/appconfig/icons/C/%B:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B
SESSION_SVR=atpserver
LC__FASTMSG=true
WINDOWID=23068728
IC_DOCUMENT_SERVER_TYPE=STANDALONE
EDITOR=/usr/dt/bin/dtpad
LOGNAME=root
MAIL=/var/spool/mail/root
DTSCREENSAVERLIST=StartDtscreenSwarm StartDtscreenQix StartDtscreenFlame
StartDtscreenHop StartDtscreenImage StartDtscreenLife StartDtscreenRotor
StartDtscreenPyro StartDtscreenWorm StartDtscreenBlank
IC_DOCUMENT_SERVER_MACHINE_NAME=standalone
LOCPATH=/usr/lib/nls/loc
TERMINAL_EMULATOR=dtterm
USER=root
AUTHSTATE=compat
SAPINST_JRE_HOME=/usr/java14_64/jre
XFORCE_INTERNET=True
DEFAULT_BROWSER=Mozilla
DISPLAY=192.168.0.180:0.0
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
JAVA_HOME=/usr/java14_64
DTAPPSEARCHPATH=//.dt/appmanager:/etc/dt/appconfig/appmanager/%L:/etc/dt/appconfig/appmanager/C:/usr/dt/appconfig/appmanager/%L:/usr/dt/appconfig/appmanager/C
HOME=/
IC_DOCUMENT_SERVER_PORT=64111
IC_DOCUMENT_DIRECTORY=/opt/IBM/aix
XMICONSEARCHPATH=//.dt/icons/%B%M.pm://.dt/icons/%B%M.bm://.dt/icons/%B:/etc/dt/appconfig/icons/%L/%B%M.pm:/etc/dt/appconfig/icons/%L/%B%M.bm:/etc/dt/appconfig/icons/%L/%B:/etc/dt/appconfig/icons/C/%B%M.pm:/etc/dt/appconfig/icons/C/%B%M.bm:/etc/dt/appconfig/icons/C/%B:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B
TERM=dtterm
PWD=/
TZ=INDST+5:30
XMBINDDIR=/usr/dt/lib/bindings
DTHELPSEARCHPATH=//.dt/help/root-192.168.0.180-0/%H://.dt/help/root-192.168.0.18-0/%H.sdl://.dt/help/root-192.168.0.18-0/%H.hv://.dt/help/%H://.dt/help/%H.sdl://.dt/help/%H.hv:/etc/dt/appconfig/help/%L/%H:/etc/dt/appconfig/help/%L/%H.sdl:/etc/dt/appconfig/help/%L/%H.hv:/etc/dt/appconfig/help/C/%H:/etc/dt/appconfig/help/C/%H.sdl:/etc/dt/appconfig/help/C/%H.hv:/usr/dt/appconfig/help/%L/%H:/usr/dt/appconfig/help/%L/%H.sdl:/usr/dt/appconfig/help/%L/%H.hv:/usr/dt/appconfig/help/C/%H:/usr/dt/appconfig/help/C/%H.sdl:/usr/dt/appconfig/help/C/%H.hv
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/dt/nls/msg/%L/%N.cat:/usr/dt/lib/nls/msg/%L/%N.cat:/usr/dt/lib/nls/msg/%l/%t/%c/%N.cat:/usr/dt/lib/nls/msg/%l/%c/%N.cat
If you need I will send you output of "env" command as a "ora<SID>" & <SID>adm
Thanks for all your support
Hi,
Could you past the environment for both users...
the orasid and sidadm environments should show the following like :
TERM=xterm
AUTHSTATE=compat
SHELL=/usr/bin/csh
HOME=/oracle/SID
USER=orasid
PATH=/oracle/SID/102_64/bin:.:/oracle/SID:/usr/sap/SID/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin
TZ=GMT0BST,M3.5.0,M10.5.0
LANG=en_GB
LOCPATH=/usr/lib/nls/loc
LC__FASTMSG=true
ODMDIR=/etc/objrepos
LOGNAME=orasid
LOGIN=orasid
SAPSYSTEMNAME=SID
DIR_LIBRARY=/usr/sap/SID/SYS/exe/run
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=SID
dbs_ora_schema=SAPSR3
ORACLE_SID=SID
DB_SID=SID
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/SID/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/SID
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/en_US/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/lib/nls/msg/en_US/%N.cat
LIBPATH=/usr/lib:/lib:/usr/sap/SID/SYS/exe/run:/oracle/SID/102_64/lib
All very important information for programs to run etc.
Mark
Hi Mark,
Thank you very much for all your help and suggestion.
I checked all the environment variable suggested by you with my production system. Added Missing Environment Variables via Export Command, & rebooted the server. When System restarted I tried to use "SU" command and "VOILA". I didn't see that old "%" sign.
Once again I would like to thank all the experts replied to my question. All your help is really appreciated.
Mark I have rewarded you full points. Issue Resolved please close it.
Ahsan Rizvi
Hello Rizvi
Login with SIDADM
run trans -d And check the trans.log file.
U will get proper solution in that file. And if possible than share trans.log with us.
Regards.
Nirav Kundaria
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is your listener running ?
su - ora<sid>
start the listener lsnrctl start
Try again
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.