cancel
Showing results for 
Search instead for 
Did you mean: 

DB startup Failed :Terminating with error code 12

Former Member
0 Kudos

hi all,

we have restore online backup + redolog from DEV to test Server successfully. Test server SID is different , db is oracle , OS is solaris 5.10

now when we start sap on test server , it generate error

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

DB startup failed

while we can start db through sql successfully

plz guide

Regards

Khan

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi,

I meant OPS$SIDADM as the OPS$USER.

Please follow the below steps to authorise the new OPS$SIDADM.

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

OPS$TRGSIDADM - New OPS$SIDADM

OPS$SRCSIDADM - Old OPS$SIDADM

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

SQL> Create user OPS$SIDADM identified externally;

SQL> Grant connect, resources to OPS$SIDADM with admin option;

SQL> Grant DBA to OPS$SIDADM;

SQL> Grant SAPDBA to OPS$SIDADM;

SQL>Create table OPS$TRGSIDADM.SAPUSER as select * from OPS$SRCSIDADM.SAPUSER;

SQL>Drop user OPS$<SRC>SIDADM cascade;

SQL> Select global_name from global_name;

SQL> Alter database rename global_name to SRC SID

After all these try to start SAP. Hope this helps.

Regards,

Varadhu

Former Member
0 Kudos

thanks for your cooperation

we have run all the scripts , it runs successfullly and also SAPSR3 account unlock becoz that was lock

Now able to connect to the sap on 000 client through sap*, not able to login on other client ,says that license is expired.

plz guide

KHAN

Former Member
0 Kudos

Hi Imran,

Thats fine.

As the data has been cpoied to a new hardware, we need to apply a alicense in SMP. This is required as the hardware key of the SRC and the TRG systems are different.

You can even install the license which you have applied for the TRG system already. If you don't have that license, you can find the same in SMP.

Regards,

Varadhu

Former Member
0 Kudos

slicense problem has been solved thanks, but when i go to rz10 -


> utilities----import profile-----of all active servers it shows the dump like

=============================

\Complete check of instance profiles and a default profile

Log for default profile , Single check

Profile name : DEFAULT

Physical profile name : /usr/sap/PRD/SYS/profile/DEFAULT.PFL

Check on server : sapprd_PRD_00

=================================

j2ee/dbname changes not permitted

Changes to DIR_PUT can result in problems

=================================

Log for instance profile , Single check

Profile name : PRD_DVEBMGS00_SAPPRD

Physical profile name : /usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_sapprd

========================================

also in the profile it also shows all old profiles of the backup system, i want to delete that old profile from the system

regards

imran

markus_doehr2
Active Contributor
0 Kudos

> also in the profile it also shows all old profiles of the backup system, i want to delete that old profile from the system

- Select the profile

- use the menu to "Profile - delete - all versions"

Markus

markus_doehr2
Active Contributor
0 Kudos

> while we can start db through sql successfully

Did you adapt your OPS$-User?

Markus

Former Member
0 Kudos

SQL> select username, password from dba_users where username like 'OP%';

USERNAME PASSWORD

-


-


OPS$ORADEV EXTERNAL

OPS$SAPSERVICEDEV EXTERNAL

OPS$DEVADM EXTERNAL

but my test server SID is "PRD"

plz guide me in detail,

we delete that users and create new according to my SID ?

and which permission that user will use ?

regrads

Imran

markus_doehr2
Active Contributor
0 Kudos

> plz guide me in detail,

Please read

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Markus

Former Member
0 Kudos

Hi Imran,

Try to execute R3trans -d as the <sid>adm user. A log file called trans.log will be generated in the same directory from where you have executed R3trans -d.

Mostly the error might be because of the logon issue. in that case you need to change the password for the OPS$USER and then try to connect SAP with the databse using the new password. This is the major step in backup recovery.

Please check the trans log file and you will get to know what the issue is.

Regards,

Varadhu

stefan_koehler
Active Contributor
0 Kudos

Hello Varadhu,

>In that case you need to change the password for the OPS$USER and then try to connect SAP with the databse using the new password

Unfortunately the OPS$USER has no password, because it is using the OS authentication method.

You can crosscheck this with the parameter recommendations from sapnote #830576 and the oracle documentation:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams180.htm#CHDGEDFJ

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams147.htm#i1131599


SQL> select username, password from dba_users where username like 'OP%';
USERNAME                       PASSWORD
------------------------------ ------------------------------
OPS$ORA<SID>                     EXTERNAL
OPS$SAPSERVICE<SID>              EXTERNAL
OPS$<SID>ADM                     EXTERNAL

Absolutely "amazing" what you can read from time to time here in the SAP on Oracle forum.

Regards

Stefan

Former Member
0 Kudos

Hello,

after you started the DB via sqlplus, logon as <sid>adm and try R3trans -x. This creates a detailed logfile in the current directory. For more information on system copies check http://www.sdn.sap.com/irj/sdn/systemcopy.

Greetings

Christian

Former Member
0 Kudos

this is trans.log result , it sys that ORA-01017: invalid username/password; logon denied , while i can conn as sysdba through SQLPLUS

++++++++++++++

4 ETW000 R3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 03.08.2009 - 18:11:26

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] Mon Aug 3 18:11:26 2009 103 0.000103

4 ETW000 [dev trc ,00000] db_con_init called 13 0.000116

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ... 32 0.000198

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.so), hdl 0 12274 0.012472

4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded 26 0.012498

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

4 ETW000 82 0.012580

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

4 ETW000 243 0.012823

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

4 ETW000 18 0.012841

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

4 ETW000 +++++++++++++++++++++++++++++++++++++++ 45 0.012886

4 ETW000 [dev trc ,00000] New connection 0 created 15 0.012901

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 +++++++++++++++++++++++++++++++++++ 26 0.012927

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

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

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 ++++++++++++++++++++++++++++++++++ 20 0.012978

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 411 0.013389

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 24 0.013413

4 ETW000 [dev trc ,00000] application info callback registered 25 0.013438

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

4 ETW000 2648 0.016086

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 159 0.016245

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000 21 0.016266

4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 22 0.016288

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 13 0.016301

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 270309)

4 ETW000 41 0.016342

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 22 0.016364

4 ETW000 [dev trc ,00000] 0 UTF8 0x1be5b80 0x1bed5d0 0x1bfdf18

4 ETW000 +++++++++ 19 0.016383

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

4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.016427

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x1bfde48,srvhp=0x1c013c8)

4 ETW000 +++++++++++++++++++++++ 78 0.016505

4 ETW000 [dev trc ,00000] Assigning server context 0x1c013c8 to service context 0x1bfde48 30079 0.046584

4 ETW000 [dev trc ,00000] Allocating user session handle 52 0.046636

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x1bfde48, srvhp=0x1c013c8, usrhp=0x1bedde8)

4 ETW000 31 0.046667

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

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 102 0.056542

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 28 0.056570

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 18 0.056588

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 13 0.056601

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 15 0.056616

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 92 0.056708

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied +++++++++++++++++++++++++++++++++++++++++++

4 ETW000 19 0.056727

4 ETW000 [dev trc ,00000] Try to connect with default password 12 0.056739

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 270309)

4 ETW000 21 0.056760

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 28 0.056788

4 ETW000 [dev trc ,00000] 0 UTF8 0x1be5b80 0x1bed5d0 0x1bfdf18

4 ETW000 19 0.056807

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x1bedde8 13 0.056820

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x1bedde8 25 0.056845

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x1bfde48, srvhp=0x1c013c8, usrhp=0x1bedde8)

4 ETW000 ++++++++++++++++++++++++++++ 37 0.056882

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

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 28000: 60 0.074308

4 ETW000 [dev trc ,00000] ORA-28000: the account is locked

4 ETW000 +++++++++++++++++++++++++++++++++ 19 0.074327

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x1c013c8) 12 0.074339

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1bfde48,srvhp=0x1c013c8)

4 ETW000 18 0.074357

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1c013c8 from con_hdl=0 242 0.074599

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28000' 38 0.074637

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 28000 12 0.074649

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=28000) 12 0.074661

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 28000 59 0.074720

4 ETW000 [dev trc ,00000] ORA-28000: the account is locked

4 ETW000 +++++++++++++++++++++++++++++++++++++++ 19 0.074739

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 28000 performing CON [dblink#7 @ 431] 62 0.074801

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#7 @ 431] 13 0.074814

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

markus_doehr2
Active Contributor
0 Kudos

your problem is, that the OPS$ user is not properly set up and now the account is locked.

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Note 951167 ORA-28000: the account is locked

Markus

Former Member
0 Kudos

First Check listener is running.

Y are able to start DB on sql prompt then

check show parameter db_name;

and what is startsap log..

Check default,start profile SAPSYSTEMNAME is it same with SID

SurendraJain

Former Member
0 Kudos

Hi

May be some problem with your Kernel executables,copy that executable from other system and paste in it run and try to start it

Regards

Uday