I can not start SAP system

[Former Member]

I have problem about starting SAP system. I executed stopsap command. After that I rebooted the HPUX system. And I try to execute startsap command.System gives me

message below.

brckxits:bxdadm 22> startsap

Checking ORC Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

17:27:59 11.04.2007 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.2006

• 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 2240) is already running .....

************************************************************************

saposcol already running

ABAP Database ORC must be started on remote server

brckxits:bxdadm 23>

[Former Member · Accepted solution]

HI,

Start the Oracle data base seperately and then execute the startsap.

Incase you had MaxDB, the startsap would start your database as well as the engine but incase of ORacle you have to manually start the oracle data base and then execute the startsap as without starting the database your SAP will NOT start...

cheers

NAveen.H

[Former Member · Accepted solution]

Hi Naveen,

I tryed that you said. Firts I started Oracle using brtools and after that I executed startsap command. Result was the same. System gave same message.

Maybe starting type of oracle is problem.

The message that system gave could be giving some knowledge about how to start Oracle.

Thank for your interest.

[Former Member]

I solved:

1- Start Oracle listener

>lsnrctl start

2- Start j2ee

>startj2eedb

3- start SAP

>startsap

[Former Member]

Hi,

I get a following message when i try to start SAP using STARTSAP.

maltr35:sbdadm 16> startsap

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

***********************************************************************

• This is Saposcol Version COLL 20.94 640 - AIX v10.35 5L-64 bit 070216

• 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 4448328) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/SBD/SYS/exe/run/startdb

Trying to start SBD database ...

Log file: /home/sbdadm/startdb.log

/usr/sap/SBD/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

The STARTDB.LOG states that the DATABASE is already OPEN with error code 0012.

<b>I tried to start the oracle manually and tried starting sap using startsap R3. then it gives me the following error. </b>

maltr35:sbdadm 15> startsap R3

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

***********************************************************************

• This is Saposcol Version COLL 20.94 640 - AIX v10.35 5L-64 bit 070216

• 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 4448328) is already running .....

************************************************************************

saposcol already running

Database SBD must be started first

ALSO STARTED THE LISTERNER AND STARTED THE DATABASE AND TRIED STARTING SAP STILL IT FAILS WITH THE FIRST ERROR MESSAGE MENTIONED ABOVE, KINDLY LET ME KNOW WHAT SHOULD BE DONE.

[Former Member]

.....<i>Trying to start SBD database ...

Log file: /home/sbdadm/startdb.log

/usr/sap/SBD/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed</i>

The problem is with DB starting up.

Check the startdb.log file for errors.

Additionally check .<b>dbenv_xxx.sh</b> file if there is a command to export ORA_NLS33 variable.