cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

error in brconnect

Former Member

on ‎09-05-2007 12:00 PM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎09-05-2007 12:13 PM
0 Kudos

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

Show replies
Show replies
Former Member
‎09-05-2007 12:25 PM
0 Kudos

hi Payal,

Thanks for your prompt reply, These changes already has been done as per note no 400241 and everything is working fine like I am able to take backup through db13 but I am not able to CHECK Database through db why ??? I am sending you the log for that please do the needul.

*************log************

*******************root@bssldev1 # cat 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 Device Type Link

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Former Member
‎09-05-2007 12:31 PM
0 Kudos

Hi Jitendra,

There some confusion here.

You are scheduling DEv database check.

and it is taking SAPPRD as a schema-ID.

Is this production system or development system?

That may be the cause of insufficient priviledge.

Check your environment variable DBA_ORA_SCHEMA.

Regards,

Payal

Former Member
‎09-05-2007 12:44 PM
0 Kudos

Hi Payal,

This is a Dev system but I have copied from PRD to DEV, here schema is SAPPRD and all permission is given to this schema, then why it is giving error,

here DBA_ORA_SCHEMA si SAPPRD.

Please suggest .

Regards,

Jitendra Tiwari

Former Member
‎09-05-2007 12:51 PM
0 Kudos

Hi Jitendra,

Didn't you perform SID change after system refresh from PRD to DEV.

You will have to perform those activities.

DEv and PRD SIDs are conflicting.

Your file system shows DEV and your environment variable shows PRD sid.

Please check and change all conflicts.

Regards,

Payal

Former Member
‎09-06-2007 12:25 PM
0 Kudos

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

Ask a Question