on 10-23-2013 3:25 PM
Hello colleagues,
In BW system when execute brconnect (brconnect -u / -c -f stats -t SAPBWP."/BIC/B0000121000./BIC/B00001210000000000054" -f allsel,collect -c 10 &)
Show this error,
[1] 14484
sv944:orabwp 2> BR0801I BRCONNECT 7.20 (30)
BR0805I Start of BRCONNECT processing: cemjknlb.sta 2013-10-23 16.07.15
BR0484I BRCONNECT log file: /oracle/BWP/sapcheck/cemjknlb.sta
BR0280I BRCONNECT time stamp: 2013-10-23 16.07.19
BR0813I Schema owner found in database BWP: SAPBWP*
BR0280I BRCONNECT time stamp: 2013-10-23 16.07.19
BR0301E SQL error -1458 at location BrTabListGet-1, SQL statement:
'OPEN curs_52a CURSOR FOR'
'SELECT OWNER, TABLE_NAME, NVL(IOT_NAME, ' '), NVL(TABLESPACE_NAME, ' '), PARTITIONED, NVL(IOT_TYPE, ' '), NVL(NUM_ROWS, -1), NVL(BLOCKS, -1), NVL(EMPTY_BLOCKS, -1), NVL(AVG_SPACE, -1), NVL(CHAIN_CNT, -1), NVL(AVG_ROW_LEN, -1), NVL(AVG_SPACE_FREELIST_BLOCKS, -1), NVL(NUM_FREELIST_BLOCKS, -1), NVL(SAMPLE_SIZE, -1), NVL(TO_NUMBER(TO_CHAR(LAST_ANALYZED, 'YYYYMMDDHH24MISS')), 0), NVL(NEXT_EXTENT, -1), NVL(MAX_EXTENTS, -1), NVL(STATUS, ' '), NVL(LOGGING, ' '), NVL(MONITORING, 'NO'), NVL(DEGREE, '-1'), NVL(ROW_MOVEMENT, ' '), NVL(NESTED, ' '), NVL(COMPRESSION, ' '), NVL(COMPRESS_FOR, ' '), NVL(PCT_FREE, -1), NVL(PCT_USED, -1), NVL(INI_TRANS, -1), NVL(MAX_TRANS, -1), NVL(GLOBAL_STATS, ' '), NVL(TEMPORARY, ' '), NVL(SEGMENT_CREATED, ' ') FROM DBA_TABLES WHERE OWNER = 'SAPBWP' AND TABLE_NAME = '/BIC/B0000121000./BIC/B00001210000000000054' AND TEMPORARY <> 'Y' ORDER BY OWNER, TABLE_NAME'
ORA-01458: invalid length inside variable character string
BR0806I End of BRCONNECT processing: cemjknlb.sta 2013-10-23 16.07.19
BR0280I BRCONNECT time stamp: 2013-10-23 16.07.19
BR0804I BRCONNECT terminated with errors
[1] Exit 3 brconnect -u / -c -f stats -t ...
Please help me!! Thanks
Hi Victor,
please paste the value of DB_BLOCK_SIZE from initSID.ora file.
regards
kartik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What he is asking is in /oracle/SID/112_64/dbs/
Please try to Increase the buffer size .Please use the below note to increase the Buffer Pool: DB_BLOCK_BUFFERS
Note 789011 - FAQ: Oracle memory areas
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.