Startsap failing for BI system

[Former Member]

Hi guys,

Hope someone can assist.

Firstly, I am running NW 7.01, on RHEL 5.4 or Oracle 10g.

I did the installation last night, and logged on and everything ran perfectly. Overnight, I shut the system down, and when I go in today, and tried to start the system up, I get an error.

Now, the listener starts perfectly, the database can start manually through SQL, so it's neither of those two.

When I run startsap, I get this error...

vbdadm 51> startsap

Checking VBD Database

-

---

Database is not available via R3trans

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

Trying to start VBD database ...

Log file: /home/vbdadm/startdb.log

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

DB startup failed

And if I run R3trans -d or R3trans -x

I get this output...

vbdadm 56> R3trans -d

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

R3trans: symbol lookup error: /usr/sap/VBD/SYS/exe/run/dboraslib.so: undefined symbol: OCIClientVersion

Here is the output of the startdb.log from my home dir.

vbdadm 52> more /home/vbdadm/startdb.log

-

---

Wed Sep 1 13:11:32 SAST 2010

LOGFILE FOR STARTING ORACLE

Trying to start VBD database ...

-

---

Wed Sep 1 13:11:32 SAST 2010

checking required environment variables

ORACLE_HOME is >/oracle/VBD/102_64<

ORACLE_SID is >VBD<

-

---

Wed Sep 1 13:11:32 SAST 2010

check initora

-

---

Wed Sep 1 13:11:32 SAST 2010

check initora

-

---

Wed Sep 1 13:11:32 SAST 2010

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 01-SEP-2010 13:11:32

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

/usr/sap/VBD/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = zamdc20163) (PORT = 1527))) (CONNECT_DATA = (SID = VBD) (GLOBAL_N

AME = VBD.WORLD)))

OK (0 msec)

tnsping: V2 connect to VBD

-

---

Wed Sep 1 13:11:32 SAST 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 127

Database not available

-

---

Wed Sep 1 13:11:32 SAST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Wed Sep 1 13:11:33 SAST 2010

starting database

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 1 13:11:33 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 9177137152 bytes

Fixed Size 2098784 bytes

Variable Size 4613736864 bytes

Database Buffers 4546625536 bytes

Redo Buffers 14675968 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

-

---

Wed Sep 1 13:11:41 SAST 2010

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 127

• ERROR: Startup of database failed

Notify Database Administrator.

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

Any help would be greatly appreciated.

Thank you.

[Former Member]

try instantclient and update brtools

[former_member314282]

Hi All,

As I recently encountered the SAME issue, and needed answers, I decided it would be smart to post the solution here. So here is what I did.

Issue resolved, took a day or so, but here are the fixes implemented.

First, you installed the Oracle Client incorrectly, so that it changed all the symbolic links in the Oracle Client directory to version 10.1.0.3 (which isn't supported). I changed them back to 10.2.0.2, which then fixed the issue below :

R3trans: symbol lookup error: /usr/sap/ES4/SYS/exe/run/dboraslib.so: undefined symbol: OCIClientVersion

R3trans: symbol lookup error: /usr/sap/EQ5/SYS/exe/run/dboraslib.so: undefined symbol: OCIClientVersion

And then I also had to unlock the SAPSR3 and SAPES4 user in SQLPLUS.

SQL> select account_status from dba_users;

ACCOUNT_STATUS

-

---

OPEN

OPEN

OPEN

OPEN

OPEN

LOCKED(TIMED)

LOCKED

EXPIRED & LOCKED

EXPIRED & LOCKED

EXPIRED & LOCKED

10 rows selected.

SQL> alter user sapsr3 account unlock;

User altered.

SQL> commit

2 ;

Commit complete.

[Former Member]

Check the version of Oracle client executables, If required extract the new Oracle client executables and try again.

Thanks

Madan Patil

[Former Member]

Hi ,

First try shutdown immediate; from sqlplus .

and then try to startup .

it may be help .

su - sidadm

sqlplus /nolog

connect /as sysdba

shutdown immediate;

startup

let me know any issues.

Regards

[Former Member]

Wow, how do I fix the formatting? It looks terrible.

[Former Member]

Not sure about this; but first I would check if Linux environment variables are set correctly for users <ora>sid and <sid>adm, as described in the installation guide.

And as for formatting:

This is a feature of SDN, in order to discourage long posts

I made your post readable for me by clicking 'reply' and " (for 'quote').

regards

[Former Member]

I see! Thanks for the information.

I have set all the usual parameters for my <SID>adm user, but what different parameters should be set for the ora<user> ? I'm confused how that would affect the startsap command, which is a <sid>adm command.

I saw in a forum to try to execute the dboraslib.so using my <sid>adm user, and I get this output. Is this normal?

zamdc20163:vbdadm 56> dboraslib.so

Segmentation fault

zamdc20163:vbdadm 57> /oracle/client/10x_64/instantclient/libclntsh.so.10.1

Segmentation fault

Thanks!

[Former Member]

What's the result of this command :

With user <sid>adm

tnsping SID

Regards,

David.

[former_member204746]

add user abdadm as a member of Unix group dba.