Database Backup Not happening after System Copy

[Former Member]

Hi ALL

I have done system copy from Production to Quality sys after that i am able to schedule the backup through DB13 but backup is not happening and also i am not able to see the logs.

When i checked it in OS level of Quality sys through sqlplus/noplus it is showing the following OPS$ users:

OPS$Domainname\PRDADM

OPS$Domainname\SAPSERVICEPRD

OPS$QUAADM

OPS$SAPSERVICEQUA

My question is that whether i have to drop all these OPS$ users in Quality sys and create new one which belongs to QAI sys OPS$ user.

If this is the case then what is the procedure for dropping and creating the user and how shall i grant the permission for this user.

And is it necessary to shut down the database while creating OPS$ user.

I am using Oracle 8.1.7.4.1 version and SAP 4.6C.

Any help will be greatly appreciated.

Thanks

Sapna

[Former Member]

Hi Sapna

The db13 for which system is not working?

Prod one or the Quality one?

If both the system ie Production and Quality are in the same box or different?

Is the concerned SAP system starting up?

If yes are u able to carry out the other tcode (apart from the db codes)?

Pl clarify before making any changes to the ops$ users.

connect to oracle as

connect /@PRD

or connect /@QUA.

If it is getting connected then it means tht the ops$user is able to connect to the db and dont make any changes to them.

Running the brtools (db13 tcode) depends on the parameters of init<sid>.sap file.

Regards

[Former Member]

Hi Manas

The Db13 is not working for the Quality sys after sys copy.

When i am using sapdba tool it is accepting the password of Production sys for the user SYSTEM.

I am able to connect database with sqlplus / nolog ( conn / as sysdba).

But it is not showing the logs in db13. When i checked it in .log file it is showing :

1.invalid username/password.

2.BR310E:Connect to database instance QUA failed.

Plz let me know how to correct the error.

Thanks

Sapna

[former_member204746]

check note 400241 at http://service.sap.com/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=0000400241&nlang=E

follow these steps carefully one by one.

[Former Member]

Have you performed the post installaion actions via se06?

Check the environment vriables.

[Former Member]

Hi All

I have created the OPS$ user by running oradbusr.sql script.But it ddn't fired the command for GRANT . Is it necessary to fire the grant command for the OPS$ user.

When i am checking the owner in SAPUSER table through command

SQL> select owner from dba_tables where table_name='SAPUSER';

it is showing 3 user :

1.sys

2.sapr3

3.OPS$Domainname\sidadm.

When i am firing the CheckDb command through DB13 it is getting cancelled .

While checking the Job logs it is showing following messages.

Job started

Step 001 started (program RSDBAJOB, variant &0000000001296, user name BASIS)

Execute logical command SAPDBA On host cinsapt1

Parameters: -u / -check

External program terminated with exit code 2

SAPDBA returned error status E

Job finished

Please help .

Thanks

Sapna

[Former Member]

Hi Sapna,

Pl check Note 437648 - DB13: External program terminated with exit code 1/2.

It says

Different causes can result in the calling program terminating with return code 2, as described above:

1. The OPS$ user for the used user is not created correctly.

2. The authorizations of the OPS$ user are not sufficient.

It gives a step wise procedure for verification of the error.

Pl go thru it.

Regards

[markus_doehr2]

http://services.sap.com/notes

Search for

"ops$ windows"

You´ll get a note telling you how to do that (use the attached script).

--

Markus

[Former Member]

Hi Markus

Thanks for your reply. But i am not getting how to proceed for that bec i am not expert in Database admin.

Can you please tell me whether i need to shutdown the database for creating the OPS$ user .

Thanks

Sapna

[Former Member]

See Note 50088....It explains everything in detail..Let us know if u face any problem