Problem brtools invalid user name/password (from lost some OPS$ user)


 ** Myself

brconnect -u / -c -f stats -t oradict_stats
BR0801I BRCONNECT 7.00 (34)
BR0805I Start of BRCONNECT processing: ceklcwpo.sta 2013-01-30 20.53.48
BR0484I BRCONNECT log file: /oracle/QAS/sapcheck/ceklcwpo.sta
BR0280I BRCONNECT time stamp: 2013-01-30 20.53.48
BR0301E SQL error -1017 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance QAS failed

#go to sql command 
select username from dba_users;

USERNAME
------------------------------
OPS$QASADM
SAPSR3
SYS
SYSTEM
OUTLN
APPQOSSYS
DIP
DBSNMP
ORACLE_OCM

12 rows selected.

###  Missing OPS$SAPSERVICEQAS and OPS$ORAQAS  user

Create user "OPS$SAPSERVICEQAS" identified externally temporary tablespace psaptemp;
Create user "OPS$ORAQAS" identified externally temporary tablespace psaptemp;
grant sapdba, unlimited tablespace to "OPS$SAPSERVICEQAS";
grant sapdba, unlimited tablespace to "OPS$ORAQAS";


# Test
brconnect -u / -c -f stats -t system_stats

BR0801I BRCONNECT 7.00 (52)
BR0805I Start of BRCONNECT processing: ceklfoqq.sta 2013-01-31 10.02.56
BR0484I BRCONNECT log file: /oracle/QAS/sapcheck/ceklfoqq.sta

BR0280I BRCONNECT time stamp: 2013-01-31 10.02.58
BR0807I Name of database instance: QAS
BR0808I BRCONNECT action ID: ceklfoqq
BR0809I BRCONNECT function ID: sta

brconnect -u / -c -f stats -t oradict_stats
BR0801I BRCONNECT 7.00 (52)
BR0805I Start of BRCONNECT processing: ceklfper.sta 2013-01-31 10.09.01
BR0484I BRCONNECT log file: /oracle/QAS/sapcheck/ceklfper.sta

BR0280I BRCONNECT time stamp: 2013-01-31 10.09.02
BR0807I Name of database instance: QAS
BR0808I BRCONNECT action ID: ceklfper
BR0809I BRCONNECT function ID: sta
BR0810I BRCONNECT function: stats
BR0812I Database objects for processing: ORADICT_STATS
BR1314I Oracle dictionary statistics will be collected with default options
BR0126I Unattended mode active - no operator confirmation required



0 comments:

Loading