Reg: DB Restore Post Activities

[former_member216430]

Hi,,

            DB Restore Post activities, two months back I restored the data from PRD to DEV, last week tried with schedule the Online Backup this backup will not fired I check with log file. Here I mentioned that Log file.

I done with OPS$ Users created also after I tried with schedule Check Database  showing some errors, I dont know how to change the password and where we need to maintain parameters file. I mentioned Log file pls check and update to me.

If your points very usefull I will give usefull points.

OPS$ users created I am using this query:

SQL> CREATE USER "OPS$TED101\TPDADM" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

SQL> CREATE USER "OPS$TED101\SAPSERVICETPD" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

SQL> GRANT CONNECT, RESOURCE, SAPDBA TO "OPS$TED101\TPDADM";

SQL> GRANT CONNECT, RESOURCE, SAPDBA TO "OPS$TED101\SAPSERVICETPD";

SQL> CREATE TABLE "OPS$TED101\TPDADM".SUPERUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

SQL> INSERT INTO "OPS$TED101\TPDADM".SUPERUSER VALUES ('SAPTPD', 'Tpl@1234');

SQL> CREATE TABLE "OPS$TED101\SAPSERVICETPD".SUPERUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

SQL> INSERT INTO "OPS$TED101\SAPSERVICETPD".SUPERUSER VALUES ('SAPSERVICETPD', 'Tpl@1234');

SQL> CONNECT /as sysdba

SQL> GRANT CONNECT, RESOURCE TO "OPS$TED101\SAPSERVICETPD";

SQL> GRANT CONNECT, RESOURCE TO "OPS$TED101\TPDADM";

SQL> SELECT USERNAME,PASSWORD FROM DBA_USERS;

Database Log Informations:

-------------------------------------------

Job started

Step 001 started (program RSDBAJOB, variant &0000000001986, user ID SUPERUSER)

Execute logical command BRCONNECT On host ted101

Parameters: -u / -c -f check

BR0801I BRCONNECT 7.10 (33)

BR0805I Start of BRCONNECT processing: cemlqpzf.chk 2013-11-04 15.16.03

BR0484I BRCONNECT log file: /oracle/TPD/sapcheck/cemlqpzf.chk

BR0280I BRCONNECT time stamp: 2013-11-04 15.16.03

BR0301E SQL error -1017 at location db_connect-2,SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TPD failed

BR0280I BRCONNECT time stamp: 2013-11-04 15.16.03

BR0301E SQL error -1017 at location db_connect-2,SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TPD failed

BR0806I End of BRCONNECT processing: cemlqpzf.chk2013-11-04 15.16.03

BR0280I BRCONNECT time stamp: 2013-11-04 15.16.03

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Warm Regards,

SAP Basis Team

[former_member216430]

Dear all,

               Thanks for Response,  I removed Hostname and update correct Password and successfully finished even Backup also successfully fired.

Thanks and Regards,

Basis Team

[Former Member]

SQL> ALTER USER OPS$PRDADM IDENTIFIED BY <password>;

SQL> alter user SAPSR3 account unlock;

SQL> alter user OPS$PRDADM account unlock;

User altered.

SQL> commit;

Commit complete.

SQL> select username,account_status from dba_users;

unlock all the users and set correct password to all DBA users

[Reagan]

Hello

Change the password of the schema user

brconnect -u / -f chpass -o SAPR3 -p Passw0rd

If that doesn't help then use the script in this SAP note to create the OPS$ users

50088  - Creating OPS$ users on Windows NT/Oracle

Regards

RB