Problem Starting SAP with Oracle

[Former Member]

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.

[Former Member · Accepted solution]

Thanks Mark for your Help

I have checked Oracle Home directory. But I didn't find any file related to your suggestion.

[Former Member · Accepted solution]

Hi,

they are 'attributes'

So from the home of ora<sid>

ls -lta

you will see all the . files

Mark

[former_member266290 · Accepted solution]

Hi

Reboot your server again and check if all the filesystems are mounted properly.

If so, then login as ora<SID> user and start listener.

Regards

[Former Member · Accepted solution]

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.

1. 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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Hi,

Is your listener running ?

su - ora<sid>

start the listener lsnrctl start

Try again

Mark

[Former Member]

I did all troubleshooting.

Now I am getting this eror.

1. su - oraabc*

% lsnrctl start

lsnrctl: Command not found.

%

[Former Member]

Hi,

The '%' tells me your environment is not setup properly....

check your:

.sapenv

.dbenv

under ora<sid> and <sid>adm

Mark

[Former Member]

Where exactly we can find these files?

The '%' tells me your environment is not setup properly....

check you .sapenv

.dbenv