SAPSTART failing

[Former Member]

I installed R/3, in Solaris 10, Oracle DB. CI & DB instance all installed fine, I could connect to the SAP thru GUI once. After that, I stopped SAP and tried to start it again - it fails to start.

When I do the "sapstart" ; this is the error I am getting:

-

---

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

Trying to start BAC database ...

Log file: /home/bacadm/startdb.log

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

DB startup failed

-

---

I checked all the parameters like dbname, tnsnames.ora, listener.ora files - and find no name mismatch.

When I try "R3trans -d" I get the following output.

$ R3trans -d

This is R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'BAC'"

R3trans finished (0012).

$

Any help would be greatly appreciated.

Thanks

Venkat

[Former Member]

Hi

Run the <b>transaction SICK or SM28</b> for SAP Initial Inconsistency Check.

This should solve your problem as it will tell ya the inconsistency in you system.

Looking at the message it seems therez some inconsistency in your system.

Regards

Sumit Jain

**Reward with points if useful

[Former Member]

Hi, i have this message after stopsap and lsnrctl stop in HPUX ECC6.0 Sr2.

After a few moments , and take a deep breath i see my /oraarch is 100%.

I made space in the file system and i see the beautiful messages

"Instance Service on host XXXXX started"

Bye.

.

[Former Member]

Hi Venkat,

Try to start Oracle manually (e.g. through sqlplus) and check if any errors occur.

Regards,

Mike

[Former Member]

Hi Mike:

Thanks for the response.

I have no problem starting & shutting down the DB. It works fine by itself.

When it tries to do it as the SAP Admin via "sapstart" command it fails with error 12 (error_dbinconsistent).

I seperately ran the R3trans command - here is output below.

Output:

This is R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'GDA'"

R3trans finished (0012).

gemsun:oragda>

How can error 12 be corrected?. Any help?

On the same thing - thought it could be something to do with the logging into the SAP - I tried this:

I checked for the SAPUSER table...

here it is.

SQL> c/*/owner, table_name/

1* select owner, table_name from all_tables

SQL> /

OWNER TABLE_NAME

-

---

-

---

OPS$BACADM SAPUSER

SQL> select * from OPS$GDAADM.SAPUSER;

USERID PASSWD

-

---

-

---

SAPGDA-CRYPT V01/0014ZctvSB67Wv386p/O3GU=

Does this mean the system is not allowing the OPS$ user to login?.

Thanks

Venkat

[Former Member]

Hi,

I have it resolved.

This was the issue.

The .dbenv_gemsun.sh file has the CLIENT_NLS33 parameter was set to wrong and it was not connecting.

After setting it to the correct value - it is fine now.

But I have another issue now, when I connect to the SAP using GUI, it complains the following.

<b>RUNTIME Errors START_CALL_SICK

SHRT TEXT

DATABASE INCONSISTENCY: START TRANSACTION SICK

the current program had to be terminated

OS release SunOS 5.10 Generic Sun4U is not supported with this kernel (640)</b>

And I when exit out of it - and go to the SAP EASY ACCESS, and select Tools - > system status, I see the following as the installed components.

<b>SAP_BASIS

SAP_ABA

PI_BASIS

SAP_BW</b>

I see - I am missing the Logistics, Accounting sub-trees from the menu. (I am new to the SAP Basis)

Thanks

Venkat

[Former Member]

Hi Vankat

I Have the smae problem in the my system

But i dident get <b>CLIENT_NLS33</b> parameter in <b>.dbenv_development.sh</b> file

there is <b>ORA_NLS33</b> are there but how to check this is right path or not

And same message i am getting when i login and check in <b>SICK or SM28</b> T-code

Please help me to come out from this problem

U can mail me on vishal.kalekar@gmail.com

Regards

Vishal Kalekar