on 05-21-2011 7:48 AM
Dear Experts ,
we are facing an error while updating statistics by using db13
please check on log below
18.05.2011 18:52:41 Job started
18.05.2011 18:52:41 Step 001 started (program RSDBAJOB, variant &0000000000047, user ID BASIS)
18.05.2011 18:52:42 No application server found on database host - rsh/gateway will be used
18.05.2011 18:52:42 Execute logical command BRCONNECT On host PRDHOSR
18.05.2011 18:52:42 Parameters: -u / -jid STATS20110518185240 -c -f stats -t ALL
18.05.2011 18:53:34 BR0801I BRCONNECT 7.00 (40)
18.05.2011 18:53:34 BR1304W Checking SAP license failed at location BrLicCheck-108
18.05.2011 18:53:34 BR0602W No valid SAP license found - please contact SAP
18.05.2011 18:53:34 BR0805I Start of BRCONNECT processing: cefxifuy.sta 2011-05-18 18.52.44
18.05.2011 18:53:34 BR0484I BRCONNECT log file: /oracle/PRD/sapcheck/cefxifuy.sta
18.05.2011 18:53:34
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.52.53
18.05.2011 18:53:34 BR0813I Schema owners found in database PRD: SAPSR3*, SAPSR3DB%
18.05.2011 18:53:34
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.05
18.05.2011 18:53:34 BR0814I Number of tables/partitions in schema of owner SAPSR3: 32818/10
18.05.2011 18:53:34 BR0836I Number of info cube tables found for owner SAPSR3: 143
18.05.2011 18:53:34 BR0814I Number of tables in schema of owner SAPSR3DB: 722
18.05.2011 18:53:34
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.24
18.05.2011 18:53:34 BR0815I Number of indexes/partitions in schema ofowner SAPSR3: 43208/13
18.05.2011 18:53:34 BR0815I Number of indexes in schema of owner SAPSR3DB: 1051
18.05.2011 18:53:34
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.29
18.05.2011 18:53:34 BR0818I Number of tables found in DBSTATC for owner SAPSR3: 814
18.05.2011 18:53:34
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.29
18.05.2011 18:53:34 BR0807I Name of database instance: PRD
18.05.2011 18:53:34 BR0808I BRCONNECT action ID: cefxifuy
18.05.2011 18:53:34 BR0809I BRCONNECT function ID: sta
18.05.2011 18:53:34 BR0810I BRCONNECT function: stats
18.05.2011 18:53:34 BR0812I Database objects for processing: ALL
18.05.2011 18:53:34 BR0851I Number of tables with missing statistics:0
18.05.2011 18:53:34 BR0852I Number of tables to delete statistics: 0
18.05.2011 18:53:34 BR0854I Number of tables to collect statistics without checking: 0
18.05.2011 18:53:34 BR0855I Number of indexes with missing statistics: 0
18.05.2011 18:53:34 BR0856I Number of indexes to delete statistics: 0
18.05.2011 18:53:34 BR0857I Number of indexes to collect statistics: 0
18.05.2011 18:53:34 BR0853I Number of tables to check (and collect ifneeded) statistics: 33537
18.05.2011 18:53:34 BR0126I Unattended mode active - no operator confirmation required
18.05.2011 18:53:34
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.31
18.05.2011 18:53:34 BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 32818/1055
18.05.2011 18:53:34 BR0817I Number of monitored/modified tables in schema of owner SAPSR3DB: 722/8
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.33
18.05.2011 18:53:34 BR0301E SQL error -2132 at location thr_db_connect-3, SQL statement:
18.05.2011 18:53:34 'ENABLE THREADS'
18.05.2011 18:53:34 SQL-02132: Message 2132 not found; No message file for product=precomp, facility
18.05.2011 18:53:34 BR0310E Connect to database instance PRD failed
18.05.2011 18:53:34
18.05.2011 18:53:34 BR0806I End of BRCONNECT processing: cefxifuy.sta2011-05-18 18.53.33
18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.34
18.05.2011 18:53:34 BR0804I BRCONNECT terminated with errors
18.05.2011 18:53:34 External program terminated with exit code 5
18.05.2011 18:53:34 BRCONNECT returned error status E
18.05.2011 18:53:34 Job finished
please help to solve this error in production
Regards
Dear Experts ,
now i got an error
because of oracle client update statistics are failed now i required to upgrade oracle client
please share your valiable knoledge how can i upgrade my oracle client 10.2.0.2 to 10.2.0.4, i checked note 819829 now i need your suggesitions on this activity
and also pre - requsits to upgrade (steps)
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.