R3trans check finished with return code: 12, *** ERROR: Startup of database

[former_member303766]

Hi Basis experts,

i have done system copy with option offline backup/restore.

system was installed successfully and stuck at the last phase i.e system was asking for DDIC password and after wrong try it has been locked, i tried with sap* with default password "PASS" but it was not successfull.

from SQL login it tried to locate sap* user on 000 client in table USR02, but it is not there. I inserted a parameter "login/no_automatic_user_sapstart = 0" in default profile and restarted the server but sap* user not created ()verified through table usr02)

i not able to start system by startsap, it has the following error:

biqadm> startsap

Checking BIQ Database

-

---

Database is not available via R3trans

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

Trying to start BIQ database ...

Log file: /export/home/biqadm/startdb.log

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

DB startup failed

if i stating DB seperately with user ORA<SID>, it's opening and then after STARTSAP is working with user <SID>ADM and system get started. but again login issue....

please suggest what can be do?

*startdb.log is as ................*

Used parameter files:

/usr/sap/BIQ/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 = BIWQAS) (PORT = 1527))) (CON

NECT_DATA = (SID = BIQ) (GLOBAL_NAME = BIQ.WORLD)))

OK (10 msec)

tnsping: V2 connect to BIQ

----

---

Tue Aug 16 16:25:46 IST 2011

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

----

---

Tue Aug 16 16:25:47 IST 2011

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

----

---

Tue Aug 16 16:26:10 IST 2011

starting database

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 16 16:26:10 2011

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 2097152000 bytes

Fixed Size 2140184 bytes

Variable Size 1070520296 bytes

Database Buffers 1023410176 bytes

Redo Buffers 1081344 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

----

---

Tue Aug 16 16:26:30 IST 2011

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

R3trans check finished with return code: 12

*** ERROR: Startup of database failed

Notify Database Administrator.

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

[former_member303766]

problem resolved by provided 6755

thanks

[Former Member]

Hello,

these are two different problems, we have locked DDIC (first) and we cannot start the system via sidadm (second).

First logon as sidadm and run R3trans -x. This will create file trans.log in the current directory with some more details. Please post the error, then we see further.

You also should check then environment variables of sidadm, do they all point to the right SID and path?

regards

Christian

[former_member303766]

my OS is Solaris 5.10..

trans.log outout is as follows...

4 ETW000 R3trans version 6.14 (release 701 - 19.01.11 - 11:44:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 16.08.2011 - 18:17:54

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Tue Aug 16 18:17:54 2011 510 0.000510

4 ETW000 [ dev trc,00000] db_con_init called 52 0.000562

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 127 0.000689

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/BIQ/SYS/exe/run/dboraslib.so' ... 144 0.000833

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/BIQ/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 65540 0.066373

4 ETW000 [ dev trc,00000] Library '/usr/sap/BIQ/SYS/exe/run/dboraslib.so' loaded 244 0.066617

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/BIQ/SYS/exe/run/dboraslib.so

4 ETW000 108 0.066725

4 ETW000 [ dev trc,00000] Version of '/usr/sap/BIQ/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.134)

4 ETW000 890 0.067615

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/BIQ/SYS/exe/run/dboraslib.so

4 ETW000 98 0.067713

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/BIQ/SYS/exe/run/dboraslib.so

4 ETW000 173 0.067886

4 ETW000 [ dev trc,00000] New connection 0 created 112 0.067998

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 154 0.068152

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 60 0.068212

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 62 0.068274

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 142 0.068416

4 ETW000 [ dev trc,00000] -->oci_init1 522 0.068938

4 ETW000 [ dev trc,00000] Oracle Client Version: '10.2.0.2.0', (dbsl 701 090311, non-unicode) 347 0.069285

4 ETW000 [ dev trc,00000] Default connection: tnsname ='BIQ' 64 0.069349

4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='WE8DEC', nchar='AL16UTF16', uc_ln=1) 98 0.069447

4 ETW000 [ dev trc,00000] Application info callback registered. 65 0.069512

4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=0=OCI_DEFAULT) returned 0 (for default NLS handle)

4 ETW000 34019 0.103531

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=1011fcf60) 139 0.103670

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=101200ae8) 88 0.103758

4 ETW000 [ dev trc,00000] NLS env.: lang=414D45524943414E 255 0.104013

4 ETW000 [ dev trc,00000] terr=414D4552494341 72 0.104085

4 ETW000 [ dev trc,00000] char=574538444543 68 0.104153

4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.WE8DEC'

4 ETW000 98 0.104251

4 ETW000 [ dev trc,00000] charset='WE8DEC', ncharset='AL16UTF16', UNI_ASC=FALSE 61 0.104312

4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPECP's password 103 0.104415

4 ETW000 [ dev trc,00000] Connecting as /@BIQ on connection 0 (nls 0) ... (dbsl 701 090311, non-unicode)

4 ETW000 119 0.104534

4 ETW000 [ dev trc,00000] Allocating service context handle for con_hdl=0 83 0.104617

4 ETW000 [ dev trc,00000] Allocating server context handle 92 0.104709

4 ETW000 [ dev trc,00000] Attaching to DB Server BIQ (con_hdl=0,svchp=101200a18,srvhp=1012037c8)

4 ETW000 169 0.104878

4 ETW000 [ dev trc,00000] Assigning server context 1012037c8 to service context 101200a18 92744 0.197622

4 ETW000 [ dev trc,00000] Allocating user session handle 113 0.197735

4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=101200a18, srvhp=1012037c8, usrhp=1011fd778)

4 ETW000 125 0.197860

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 17737 0.215597

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 129 0.215726

4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 76 0.215802

4 ETW000 ORA-27121: unable to determine size of shared memory segment

4 ETW000 SVR4 Error: 13: Permission de

4 ETW000 [ dev trc,00000] nied

4 ETW000 152 0.215954

4 ETW000 [ dev trc,00000] server_detach(con_hdl=0,stale=1,svrhp=1012037c8) 61 0.216015

4 ETW000 [ dev trc,00000] Detaching from DB Server (con_hdl=0,svchp=101200a18,srvhp=1012037c8)

4 ETW000 116 0.216131

4 ETW000 [ dev trc,00000] Deallocating server context handle 1012037c8 from con_hdl=0 7693 0.223824

4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1034' 159 0.223983

4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1034 72 0.224055

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con_hdl=0, rc=1034) 94 0.224149

4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1034 71 0.224220

4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 75 0.224295

4 ETW000 ORA-27121: unable to determine size of shared memory segment

4 ETW000 SVR4 Error: 13: Permission de

4 ETW000 [ dev trc,00000] nied

4 ETW000 200 0.224495

4 ETW000 [ dev trc,00000] SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034. 82 0.224577

4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 1034 performing CON [dblink#4 @ 433] 120 0.224697

4 ETW000 [ dblink ,00433] ***LOG BY0=>ORA-01034: ORACLE not available 85 0.224782

4 ETW000 ORA-27121: unable to determine size of shared memory segment

4 ETW000 SVR4 Error: 13: Permission denied [dblink#4 @ 433]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'BIQ'"

[Former Member]

Hello,

startsap tries to logon with user <sid>adm with os authentication to get the password of the schema user to connect the SAP workprocesses. It seems as if your user <sidadm> is not allowed to connect to the database with OS authentication. You can verify this by running

sqlplus / as sysdba

as <sid>adm, i think this will fail. In this case you have to create user ops$<sid>adm in your database with 'identified externally', create table <sid>adm.sapuser and use brconnect to set the new password for your schema user.

Good luck, and please tell me if it works (or not).

Christian

[former_member303766]

Hi Christian,

thanks you for your prompt response. i tried to connect with <sid>adm, it working, you can see the output

biqadm> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 16 18:57:26 2011

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

Connected to:

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

With the Partitioning, Data Mining and Real Application Testing options

SQL>

i think there is problem with DB shared memory as seen in last log that i sent

"ORA-27121: unable to determine size of shared memory segment"

[nirmal_konchada]

Hi Birendra,

Check the authorizations of your oracle binary

$ORACLE_HOME/bin/oracle

More info on the note 583861

Also check the permissions for files in bin directory. It must be 6751.

Regards,

Nirmal.K

[Former Member]

Hello,

so would you please check if table ops$SAPECP.sapuser exists?

Please also check if the Oracle listener is started, enter as ora<sid>

lsnrctl status

Thanks

Christian

Edited by: Christian Rose on Aug 17, 2011 7:58 AM