Skip to Content
avatar image
Former Member

Database instance Startup

when i start instance with BRTOOLS with "normal" mode it shows error , i have to start instance always with "force" option. & after unlocking SAPSR3 account then only ABAP dispatcher connects. i require to do this after every restart. please help me on this problem. I have Dual Stack NW 7.0 system.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 13, 2009 at 02:46 AM

    Step 1: Incase SAPUSER table isnt available , create it as below

    create table "OPS$SIDADM".SAPUSER ( USERID VARCHAR2(256), PASSWD VARCHAR2 (256));

    Step 2: # update "OPS$<SID>ADM.SAPUSER with the followig command

    insert into "OPS$SIDADM".SAPUSER values ('SAPSR3', 'sap'); #sap = <password>

    Step 3: Get into sqlplus and connect \ as sysdba

    once connected

    alter user SAPSR3 identified by sap;

    commit;

    Please let know if this helps.

    Thanks,

    Gerard

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 15, 2009 at 06:40 AM

    Hi Sachin,

    If you are on windows, i'd suggest to look into SAP Note 50088 as well.

    Regards

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 11, 2009 at 08:28 AM

    Hi

    Try resetting 'SAPR3' password using BRtools and test. Hope this will fix the issue. If not, please check the trace files, under '$ORACLE_HOME/saptrace/usertrace' and check for the lines, when system was brought down. May be you will get some clue.

    Hope this info, helps!!

    with Regards,

    Rajesh M

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2009 at 09:28 AM

    That could be a problem with the OPS$ user, do an R3trans -d and post the contents of trans.log

    Check SAP Note 400241

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 12, 2009 at 07:25 AM

    Hi,

    Juan Sir,

    this is the trans.log

    4 ETW000 r3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

    4 ETW000 unicode enabled version

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

    4 ETW000

    4 ETW000 date&time : 16.12.2009 - 12:56:59

    4 ETW000 control file: <no ctrlfile>

    4 ETW000 R3trans was called as follows: r3trans -d

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

    4 ETW000 [dev trc ,00000] Wed Dec 16 12:57:02 2009 0 0.000000

    4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

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

    4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000

    4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 9292 0.009292

    4 ETW000 [dev trc ,00000] using "E:\usr\sap\PI0\SYS\exe\uc\NTAMD64\dboraslib.dll"

    4 ETW000 55 0.009347

    4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 16 0.009363

    4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

    4 ETW000 28 0.009391

    4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.144)

    4 ETW000 188 0.009579

    4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

    4 ETW000 25 0.009604

    4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

    4 ETW000 36 0.009640

    4 ETW000 [dev trc ,00000] New connection 0 created 25 0.009665

    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 43 0.009708

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

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

    4 ETW000 24 0.009754

    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 31 0.009785

    4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

    4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

    4 ETW000 assuming using instant client with unspecified location.

    4 ETW000 322 0.010107

    4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 10477 0.020584

    4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 41 0.020625

    4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 4299 0.024924

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

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

    4 ETW000 35 0.025004

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

    4 ETW000 33 0.025037

    4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000007534090 00000000002FDFC0 0000000000303788

    4 ETW000 114 0.025151

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

    4 ETW000 [dev trc ,00000] Allocating server context handle 19 0.025199

    4 ETW000 [dev trc ,00000] Attaching to DB Server PI0 (con_hdl=0,svchp=0000000000303648,srvhp=00000000075530E8)

    4 ETW000 58 0.025257

    4 ETW000 [dev trc ,00000] Assigning server context 00000000075530E8 to service context 0000000000303648

    4 ETW000 23911 0.049168

    4 ETW000 [dev trc ,00000] Allocating user session handle 50 0.049218

    4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000000303648,srvhp=00000000075530E8,usrhp=00000000002FE7D8)

    4 ETW000 42 0.049260

    4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

    4 ETW000 179681 0.228941

    4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=00000000075530E8)

    4 ETW000 305 0.229246

    4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000000303648,srvhp=00000000075530E8)

    4 ETW000 29 0.229275

    4 ETW000 [dev trc ,00000] Deallocating server context handle 00000000075530E8

    4 ETW000 1330 0.230605

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

    4 ETW000 51 0.230656

    4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 22 0.230678

    4 ETW000 [dev trc ,00000] Try to connect with default password 81 0.230759

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

    4 ETW000 28 0.230787

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

    4 ETW000 29 0.230816

    4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000007534090 00000000002FDFC0 0000000000303788

    4 ETW000 33 0.230849

    4 ETW000 [dev trc ,00000] Allocating server context handle 16 0.230865

    4 ETW000 [dev trc ,00000] Attaching to DB Server PI0 (con_hdl=0,svchp=0000000000303648,srvhp=00000000075530E8)

    4 ETW000 38 0.230903

    4 ETW000 [dev trc ,00000] Assigning server context 00000000075530E8 to service context 0000000000303648

    4 ETW000 27068 0.257971

    4 ETW000 [dev trc ,00000] Assigning username to user session 00000000002FE7D8

    4 ETW000 32 0.258003

    4 ETW000 [dev trc ,00000] Assigning password to user session 00000000002FE7D8

    4 ETW000 41 0.258044

    4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000000303648,srvhp=00000000075530E8,usrhp=00000000002FE7D8)

    4 ETW000 33 0.258077

    4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

    4 ETW000 93091 0.351168

    4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=00000000075530E8)

    4 ETW000 1298 0.352466

    4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000000303648,srvhp=00000000075530E8)

    4 ETW000 27 0.352493

    4 ETW000 [dev trc ,00000] Deallocating server context handle 00000000075530E8

    4 ETW000 17568 0.370061

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

    4 ETW000 39 0.370100

    4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 16 0.370116

    4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1034 performing CON [dblink#5 @ 431]

    4 ETW000 133 0.370249

    4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01034: ORACLE not available 21 0.370270

    4 ETW000 ORA-27101: shared memory realm does not exist [dblink#5 @ 431]

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 12, 2009 at 09:04 AM

    when i try to start in "normal Mode" with BRTOOLS , err :

    C:\Documents and Settings\pi0adm>brtools

    BR0651I BRTOOLS 7.00 (32)

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.02

    BR0656I Choice menu 1 - please make a selection

    -


    BR*Tools main menu

    1 = Instance management

    2 - Space management

    3 - Segment management

    4 - Backup and database copy

    5 - Restore and recovery

    6 - Check and verification

    7 - Database statistics

    8 - Additional functions

    9 - Exit program

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help

    -


    BR0662I Enter your choice:

    1

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.03

    BR0663I Your choice: '1'

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.03

    BR0656I Choice menu 3 - please make a selection

    -


    Database instance management

    1 = Start up database

    2 - Shut down database

    3 - Alter database instance

    4 - Alter database parameters

    5 - Recreate database

    6 - Show instance status

    7 - Show database parameters

    8 - Show database owners

    9 - Reset program status

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help

    -


    BR0662I Enter your choice:

    1

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.05

    BR0663I Your choice: '1'

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.05

    BR0657I Input menu 71 - please check/enter input values

    -


    BRSPACE options for database instance startup

    1 - BRSPACE profile (profile) ...... [initPI0.sap]

    2 - Database user/password (user) .. [/]

    3 ~ Database instance (instance) ... []

    4 - Confirmation mode (confirm) .... [yes]

    5 - Message language (language) .... [E]

    6 - BRSPACE command line (command) . [-p initPI0.sap -l E -f dbstart]

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help

    -


    BR0662I Enter your choice:

    c

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.06

    BR0663I Your choice: 'c'

    BR0259I Program execution will be continued...

    BR0291I BRSPACE will be started with options '-p initPI0.sap -l E -f dbstart'

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.06

    BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

    c

    BR0280I BRTOOLS time stamp: 2009-12-16 14.29.08

    BR0257I Your reply: 'c'

    BR0259I Program execution will be continued...

    ###############################################################################

    BR1001I BRSPACE 7.00 (32)

    BR1002I Start of BRSPACE processing: secdiymu.dbr 2009-12-16 14.29.08

    BR0484I BRSPACE log file: K:\oracle\PI0\sapreorg\secdiymu.dbr

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.10

    BR1009I Name of database instance: PI0

    BR1010I BRSPACE action ID: secdiymu

    BR1011I BRSPACE function ID: dbr

    BR1012I BRSPACE function: dbstart

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.10

    BR0656I Choice menu 201 - please make a selection

    -


    Database instance startup main menu

    1 = Start up database

    2 - Show instance status

    3 * Exit program

    4 - Reset program status

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help

    -


    BR0662I Enter your choice:

    c

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.13

    BR0663I Your choice: 'c'

    BR0259I Program execution will be continued...

    BR0613I Database instance PI0 is shut down

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.14

    BR0657I Input menu 203 - please check/enter input values

    -


    Options for starting up database instance PI0

    1 - Database startup to-state (state) . [open]

    2 - Database open mode (mode) ......... [normal]

    3 - Force instance restart (force) .... [no]

    4 - SQLPLUS command (command) ......... [startup open]

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help

    -


    BR0662I Enter your choice:

    c

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.15

    BR0663I Your choice: 'c'

    BR0259I Program execution will be continued...

    BR0613I Database instance PI0 is shut down

    BR0786I Database instance PI0 will be opened now in mode 'normal'

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.16

    BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

    c

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.19

    BR0257I Your reply: 'c'

    BR0259I Program execution will be continued...

    BR0280I BRSPACE time stamp: 2009-12-16 14.29.19

    BR0304I Starting and opening database instance PI0 ...

    BR0278E Command output of 'e:\oracle\product\10.2.0\db_1\BIN\sqlplus /nolog < K:

    \oracle\PI0\sapreorg\.secdiymu.spi':

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 16 14:29:19 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> Connected to an idle instance.

    SQL>

    SQL> ORACLE instance started.

    Total System Global Area 356515840 bytes

    Fixed Size 2004264 bytes

    Variable Size 188746456 bytes

    Database Buffers 163577856 bytes

    Redo Buffers 2187264 bytes

    Database mounted.

    ORA-16038: log 2 sequence# 270 cannot be archived

    ORA-00354: corrupt redo log block header

    ORA-00312: online log 2 thread 1: 'I:\ORACLE\PI0\ORIGLOGB\LOG_G12M1.DBF'

    ORA-00312: online log 2 thread 1: 'K:\ORACLE\PI0\MIRRLOGB\LOG_G12M2.DBF'

    SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

    - 64bit Production

    With the Partitioning, OLAP and Data Mining options

    BR0280I BRSPACE time stamp: 2009-12-16 14.30.27

    BR0279E Return code from 'e:\oracle\product\10.2.0\db_1\BIN\sqlplus /nolog < K:\

    oracle\PI0\sapreorg\.secdiymu.spi': 0

    BR0302E SQLPLUS call for database instance PI0 failed

    BR0306E Start and open of database instance PI0 failed

    BR0669I Cannot continue due to previous warnings or errors - you can go back to

    repeat the last action

    BR0280I BRSPACE time stamp: 2009-12-16 14.30.27

    BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sachin,

      Check if the archive disk location is full. If yes, then clear the archive directory.

      If not then check note 694155 Error due to corrupt redo logs

      Cheers.....,

      Raghu

  • avatar image
    Former Member
    Dec 15, 2009 at 10:02 AM

    Thank you very much 😊 problem solved.

    Add comment
    10|10000 characters needed characters exceeded