SQL1013N The database alias name or database name could not found

[Former Member]

Hi guys,

After a system copy, I am not able to connect the database to SAP.

The profiles files were changed but when I run the command R3trans -d, I gotta this error:

* ERROR in DB6Connect[dbdb6.c, 1575] CON = 0 (BEGIN)

4 ETW000                                                                          603706  0.624456

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1013N  The database alias name or database name "SID" could not

4 ETW000  [dev trc     ,00000]  &+      be found.  SQLSTATE=42705

The database is DB6.

Thank you much,

Má

[former_member189725]

Did you do a redirected restore while performing the system copy .

After the restore is over , you will have to perform certain post steps to set things right before R3trans can connect to the correct database schema .

You will have to perform the following steps.

1. create db2<oldsid> in the target system and also the sap<oldsid> in the target system and assign them to db<newsid>adm and db<newsid>mnt groups

2. set the environment  variable dbs_db6_schema to sap<oldsid>

3. login as db2<oldsid> with the environment of db2<newsid>

4. connect to database (db2 connect to <new_sid>)

    execute the following grants

     grant dbadm,secadm on database to user db2<new_dbsid>

     grant secadm on database to user <newsid>adm

5. Then update the dbsdb6.conf file as follows with <newsid>adm

    dscdb6up -create <password of sap(oldsid)> <password of (newsid)adm>

6. Test

#  R3trans -d

Refer this thread http://scn.sap.com/message/13321602

Regards

Ratnajit

[Former Member]

Hi Ratnajit,

thank you so much for your helpful information.

Teh previous error was solved after running the catalog command but right now my error is related to :

[IBM][CLI Driver] SQL30082N  Security processing failed with reason "19" ("USERID DI

4 ETW000  [dev trc     ,00000]  &+     SABLED or RESTRICTED")

I have already run the command that you mentioned:

dscdb6up -create <password of sap(oldsid)> <password of (newsid)adm>

But the error persists. I can log on withthe sapoldsid that it is SAPR3 and the newsid adm userids but the error still persists.

Any hints?

[Former Member]

One more question Ratnajit, Sorry but I didn't understand this step:

3. login as db2<oldsid> with the environment of db2<newsid>

Thank you so much

[former_member189725]

Can you check if the account  SAPR3 is locked or disabled .

also run dscdb6up -create <password of SAPR3> <password of <sid>adm>

Try connecting manually with the ID

login as <db2>sid

db2 connect to <SID> user SAPR3 using <password>

also check if dbs_db6_schema is set to SAPR3.

Regards

Ratnajit

[former_member189725]

The db2<oldsid> is temporarily created to grant DB authority to db2<newsid>.

Since this user has to connect to the database , hence ,it needs to have env of db2<newsid> user , so that all required environment is set .

su -  db2<newsid>

su db2<oldsid>

This will have db2<oldsid> environment of db2<newsid>.

Regards

Ratnajit

[Former Member]

Ratnajit

I don't know what it is happening but the error persists:

DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N  Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED")

I can log on AIX system with the ids: sidadm and sapr3

[Former Member]

Ratnajit

thank you so much for your help.

The problem was solved after unlocking the SAPR3 id on the database server

[former_member189725]

Kindly close the thread if the issue is resolved .

Regards

Ratnajit