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
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:
Post a Comment