cancel
Showing results for 
Search instead for 
Did you mean: 

Database instance Startup

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

I executed the SQl command but it gives fallowing error :

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 18 13:23:52 2009

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

Enter user-name: system

Enter password:

Connected to:

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

With the Partitioning, OLAP and Data Mining options

SQL> connect system

Enter password:

Connected.

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

256));

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

*

ERROR at line 1:

ORA-01918: user 'OPS$SIDADM' does not exist

SQL> create table "OPS$PI0ADM".SAPUSER ( USERID VARCHAR2(256), PASSWD VARCHAR2 (

256));

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

*

ERROR at line 1:

ORA-01918: user 'OPS$PI0ADM' does not exist

SQL> SELECT * FROM SAPUSER

2 ;

SELECT * FROM SAPUSER

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL>

Former Member
0 Kudos

You are on Windows I presume?

In this case you may have to modify Gerard 's suggestion, that is replace OPS$PI0ADM by something like OPS$<DOMAIN>\PI0ADM or OPS$<HOSTNAME>\PI0ADM.

To find out, try this in sqlplus:

select username from all_users;

hope this helps

JPReyes
Active Contributor
0 Kudos

You clearly have not read the note I posted earlier, Read SAP Note 400241, all the info you need is there.

Regards

Juan

Answers (6)

Answers (6)

Former Member
0 Kudos

Thank you very much problem solved.

Former Member
0 Kudos

Hi Sachin,

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

Regards

Nick Loy

Former Member
0 Kudos

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:

Former Member
0 Kudos

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

Former Member
0 Kudos

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'"

JPReyes
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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