Skip to Content
avatar image
Former Member

error in brconnect

Hi Michael,

When I am checking database through db13 its giving the below error :

******************error log*****************************************

Detail log: cdwbvqzc.chk

BR0801I BRCONNECT 7.00 (18)

BR0477I Oracle pfile /oracle/DEV/102_64/dbs/initDEV.ora created from spfile /oracle/DEV/102_64/dbs/spfileDEV.ora

BR0805I Start of BRCONNECT processing: cdwbvqzc.chk 2007-09-05 12.22.20

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home /oracle/DEV/102_64

oracle_profile /oracle/DEV/102_64/dbs/initDEV.ora

sapdata_home /oracle/DEV

sap_profile /oracle/DEV/102_64/dbs/initDEV.sap

system_info devadm/oradev bssldev1 SunOS 5.10 Generic_118833-36 sun4v

oracle_info DEV 10.2.0.2.0 8192 1947 1760469146 bssldev1

sap_info 700 SAPPRD PRD M0693587621 R3_ORA 0020178904

make_info sun_64 OCI_102 Oct 21 2006

command_line brconnect -u / -jid CHECK20070905122218 -c -f check

alert_log /oracle/DEV/saptrace/background/alert_DEV.log

BR0971W The default temporary tablespace of database DEV is set to SYSTEM

BR0280I BRCONNECT time stamp: 2007-09-05 12.22.21

BR0813I Schema owners found in database DEV:

DBSNMP, DEVADM, DIP, OPS$DEVADM, OPS$ORADEV, OPS$ORAPRD, OPS$PRDADM, OUTLN, SAPPRD*, SAPPRDSHD+,

SYS, SYSTEM, TSMSYS

BR0118I Tablespaces and data files

Tablespace Status File Status Id. Size MaxSize IncrSize BlkSize

PSAPPRD ONLINE+ /oracle/DEV/sapdata3/prd_1/prd.data1 ONLINE+ 2 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata3/prd_2/prd.data2 ONLINE+ 3 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata3/prd_3/prd.data3 ONLINE+ 4 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata3/prd_4/prd.data4 ONLINE+ 5 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_5/prd.data5 ONLINE+ 6 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_6/prd.data6 ONLINE+ 7 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_7/prd.data7 ONLINE+ 8 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_8/prd.data8 ONLINE+ 9 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_9/prd.data9 ONLINE+ 10 10485768192 10485760000 20971520 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_10/prd.data10 ONLINE 25 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_11/prd.data11 ONLINE 26 9607487488 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_12/prd.data12 ONLINE 27 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_13/prd.data13 ONLINE 28 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_14/prd.data14 ONLINE 29 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_15/prd.data15 ONLINE 30 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_16/prd.data16 ONLINE 31 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_17/prd.data17 ONLINE 32 4195483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_18/prd.data18 ONLINE 33 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_19/prd.data19 ONLINE 34 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_20/prd.data20 ONLINE 35 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_21/prd.data21 ONLINE 36 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_22/prd.data22 ONLINE 37 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_23/prd.data23 ONLINE 38 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_24/prd.data24 ONLINE 39 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_25/prd.data25 ONLINE 40 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_26/prd.data26 ONLINE 41 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_27/prd.data27 ONLINE 42 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_28/prd.data28 ONLINE 43 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_29/prd.data29 ONLINE 44 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_30/prd.data30 ONLINE 45 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_31/prd.data31 ONLINE 46 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_32/prd.data32 ONLINE 47 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_33/prd.data33 ONLINE 48 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_34/prd.data34 ONLINE 49 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_35/prd.data35 ONLINE 50 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_36/prd.data36 ONLINE 51 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_37/prd.data37 ONLINE 52 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_38/prd.data38 ONLINE 53 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_39/prd.data39 ONLINE 54 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_40/prd.data40 ONLINE 55 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_41/prd.data41 ONLINE 56 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_42/prd.data42 ONLINE 57 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_43/prd.data43 ONLINE 58 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_44/prd.data44 ONLINE 59 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_45/prd.data45 ONLINE 62 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_46/prd.data46 ONLINE 63 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_47/prd.data47 ONLINE 64 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_48/prd.data48 ONLINE 66 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_49/prd.data49 ONLINE 67 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_50/prd.data50 ONLINE 68 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_51/prd.data51 ONLINE 69 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_52/prd.data52 ONLINE 70 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_53/prd.data53 ONLINE 71 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_54/prd.data54 ONLINE 72 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_55/prd.data55 ONLINE 73 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_56/prd.data56 ONLINE 74 2147483648 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_57/prd.data57 ONLINE 78 17532198912 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_58/prd.data58 ONLINE 80 5242888192 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_59/prd.data59 ONLINE 81 2097160192 0 0 8192

PSAPPRD ONLINE+ /oracle/DEV/sapdata4/prd_60/prd.data60 ONLINE 82 15728648192 0 0 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata1/prd620_1/prd620.data1 ONLINE+ 11 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata1/prd620_2/prd620.data2 ONLINE+ 12 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata1/prd620_3/prd620.data3 ONLINE+ 13 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata1/prd620_4/prd620.data4 ONLINE+ 14 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata2/prd620_5/prd620.data5 ONLINE+ 15 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata2/prd620_6/prd620.data6 ONLINE+ 16 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata2/prd620_7/prd620.data7 ONLINE+ 17 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata2/prd620_8/prd620.data8 ONLINE+ 18 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata2/prd620_9/prd620.data9 ONLINE+ 19 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata3/prd620_10/prd620.data10 ONLINE+ 20 2097160192 10485760000 20971520 8192

PSAPPRD620 ONLINE+ /oracle/DEV/sapdata4/prd620_11/prd620.data11 ONLINE+ 21 2097160192 10485760000 20971520 8192

PSAPPRD700 ONLINE+ /oracle/DEV/sapdata4/prd700_1/prd700.data1 ONLINE+ 79 28346163200 34359721984 8192 8192

PSAPPRDUSR ONLINE+ /oracle/DEV/sapdata1/prdusr_1/prdusr.data1 ONLINE+ 22 20979712 10485760000 20971520 8192

PSAPROLL ONLINE /oracle/DEV/sapdata2/roll_1/roll.data1 ONLINE 23 734011392 0 0 8192

PSAPROLL ONLINE /oracle/DEV/sapdata2/roll_2/roll.data2 ONLINE 60 220200960 0 0 8192

PSAPROLL ONLINE /oracle/DEV/sapdata2/roll_3/roll.data3 ONLINE 61 286261248 0 0 8192

PSAPROLL ONLINE /oracle/DEV/sapdata2/roll_4/roll.data4 ONLINE 65 372137984 0 0 8192

PSAPROLL ONLINE /oracle/DEV/sapdata2/roll_5/roll.data5 ONLINE 75 483778560 0 0 8192

PSAPTEMP ONLINE# /oracle/DEV/sapdata3/temp_1/temp.data1 ONLINE -1 367009792 0 0 8192

PSAPTEMP ONLINE# /oracle/DEV/sapdata3/temp_2/temp.data2 ONLINE -2 110100480 0 0 8192

PSAPTEMP ONLINE# /oracle/DEV/sapdata3/temp_3/temp.data3 ONLINE -3 524296192 0 0 8192

PSAPUNDO ONLINE- /oracle/DEV/sapdata2/undo_1/undo.data1 ONLINE 76 16106135552 0 0 8192

SYSAUX ONLINE+ /oracle/DEV/sapdata1/sysaux_1/sysaux.data1 ONLINE+ 77 1048584192 2097152000 104857600 8192

SYSTEM ONLINE /oracle/DEV/sapdata1/system_1/system.data1 SYSTEM 1 524296192 0 0 8192

SYSTEM ONLINE /oracle/DEV/sapdata1/system_2/system.data2 SYSTEM 24 2147483648 0 0 8192

BR0119I Redo log files

File Status Group Size Device Type Link

/oracle/DEV/origlogA/log_g11m1.dbf INUSE 1 52429312 5570620 FILE NOLINK

/oracle/DEV/mirrlogA/log_g11m2.dbf INUSE 1 52429312 5570621 FILE NOLINK

/oracle/DEV/origlogB/log_g12m1.dbf INUSE 2 52429312 5570617 FILE NOLINK

/oracle/DEV/mirrlogB/log_g12m2.dbf INUSE 2 52429312 5570618 FILE NOLINK

/oracle/DEV/origlogA/log_g13m1.dbf INUSE 3 52429312 5570620 FILE NOLINK

/oracle/DEV/mirrlogA/log_g13m2.dbf INUSE 3 52429312 5570621 FILE NOLINK

/oracle/DEV/origlogB/log_g14m1.dbf INUSE 4 52429312 5570617 FILE NOLINK

/oracle/DEV/mirrlogB/log_g14m2.dbf INUSE 4 52429312 5570618 FILE NOLINK

BR0120I Control files

File Size Device Type Link

/oracle/DEV/origlogA/cntrl/cntrlDEV.dbf 12378112 5570620 FILE NOLINK

/oracle/DEV/saparch/cntrl/cntrlDEV.dbf 12378112 5570624 FILE NOLINK

/oracle/DEV/sapdata1/cntrl/cntrlDEV.dbf 12378112 5570614 FILE NOLINK

BR0982I Database disk volumes

Directory / Raw disk Device Total[KB] Free[KB] Used[%] MaxNeed[KB] MaxMiss[KB]

/oracle/DEV/102_64 5570624 8261365 5682795 31.21 0 0

/oracle/DEV 5570624 8261365 5682795 31.21 0 0

/oracle/DEV/mirrlogA 5570621 288367 156002 45.90 102401 0

/oracle/DEV/mirrlogB 5570618 288367 156002 45.90 102401 0

/oracle/DEV/origlogA 5570620 288367 134833 53.24 114489 0

/oracle/DEV/origlogB 5570617 288367 156002 45.90 102401 0

/oracle/DEV/saparch 5570624 8261365 5682795 31.21 12088 0

/oracle/DEV/sapdata1 5570614 56798189 44301150 22.00 55869296 0

/oracle/DEV/sapdata2 5570613 56798189 28144132 50.45 68975944 12815868

/oracle/DEV/sapdata3 5570612 72288744 27513192 61.94 52177976 0

/oracle/DEV/sapdata4 5570611 247848864 16917190 93.17 242495088 0

/oracle/DEV/saparch 5570624 8261365 5682787 31.21 0 0

/oracle/DEV/sapbackup 5570624 8261365 5682787 31.21 0 0

/oracle/DEV/sapcheck 5570624 8261365 5682787 31.21 0 0

/oracle/DEV/sapreorg 5570616 4129822 4084363 1.10 0 0

/oracle/DEV/saptrace 5570624 8261365 5682787 31.21 0 0

BR0280I BRCONNECT time stamp: 2007-09-05 12.22.21

BR0301E SQL error -1031 at location BrRsnspaceRead-1, SQL statement:

'PREPARE stmt_11 STATEMENT FROM'

'SELECT NAMESPACE, NSPACEGEN FROM "SAPPRD".RSNSPACE ORDER BY NAMESPACE'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cdwbvqzc.chk 2007-09-05 12.22.21

BR0280I BRCONNECT time stamp: 2007-09-05 12.22.21

BR0804I BRCONNECT terminated with errors

***********************************************************************************************II have applied the sapdba role (as per note 134592).

Please help.

Regards,

Jitendra Tiwari

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 05, 2007 at 11:13 AM

    Hi Jitendra,

    lease check to run sapdba_role.sql... use the latest version:

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

    Please copy cdwbvqzc.chk log file.

    Regards,

    Payal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Please check following notes.

      You need to run 2 scripts for OPS$ schema users.

      Note 95719 - SAPDBA/BRBACKUP: ORA-1031 after migration to Oracle8

      Note 528339 - DBCHK_PRE: Permission denied with ORAGETNLS.SQL

      Please update for the same.

      Regards,

      Payal