DB13 issue after system copy

[former_member249119]

Dear all,

After system copy i can`t perform any actions in DB13. All actions finished with following issue:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000034, user ID <my_id>)

Execute logical command BRCONNECT On host <my_host>

Parameters: -u / -jid CHECK20160817085245 -c -f check

BR0801I BRCONNECT 7.20 (36)

BR0805I Start of BRCONNECT processing: cetvxesc.chk 2016-08-17 08.52.46

BR0484I BRCONNECT log file: /oracle/<my_sid>/sapcheck/cetvxesc.chk

/usr/lib/hpux64/dld.so: Unable to find library 'libskgxp10.so'.

sh: 26868 Killed

BR0278E Command output of '/oracle/,my_sid>/102_64/bin/sqlplus /nolog < /dev/null':

/usr/lib/hpux64/dld.so: Unable to find library 'libsqlplus.so'.

BR0280I BRCONNECT time stamp: 2016-08-17 08.52.47

BR0279E Return code from '/oracle/<my_sid>/102_64/bin/sqlplus /nolog < /dev/null': 137

BR0302E SQLPLUS call for database instance <my_sid> failed

BR0303E Determination of Oracle version failed

/usr/lib/hpux64/dld.so: Unable to find library 'libskgxp10.so'.

BR0280I BRCONNECT time stamp: 2016-08-17 08.52.47

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

'CONNECT /'

ORA-12547: TNS:lost contact

BR0310E Connect to database instance <my_sid> failed

How to solve it?

[former_member249119]

Additionally when i try to run sqlplus from SIDADM user i get

sqlplus

/usr/lib/hpux64/dld.so: Unable to find library 'libsqlplus.so'.

Killed

[Former Member]

Hi,

Have you created OPS$ for SIDADM? Please check it with "select username from dba_users;" there should the two OPS$ users, one for ORASID and another one for SIDADM. If it is not created, please create OPS$ for SIDADM and try to connect again with sqlplus.

Regards,

Ganesan

[former_member249119]

I did it, from orasid it`s ok, all works fine, but from sid adm i cant perform check db, also i cant start sqlplus:

sidadm >sqlplus

/usr/lib/hpux64/dld.so: Unable to find library 'libsqlplus.so'.

[Former Member]

Could you please do the below command and post the output here?

orasid>sqlplus "/as sysdba"

SQL>select username from dba_users;

[Former Member]

Hi,

Can you try to create the OPS$SIDADM user in the same way, you created for orasid? It is the database user, so i think you can create this user by logging in from ORASID sqlplus and assign reqired roles.

Orasid>sqlplus "/as sysdba"

If the user is already created,

Then, verify SIDADM environment pointing to 11g BINARIES and 11g client

DIR_LIBRARY

LD_LIBRARY_PATH

TNS_ADMIN

ORACLE_HOME_PATH

and try again sidadm>sqlplus....

Regards,

Ganesan

[former_member249119]

I did it according "776505 - ORA-01017/ORA-01031 in BR*Tools on Linux and Solaris 11" without system stop.

Now check db from orasid user performs without issues. But  check db from sidadm user finished with same issue.

[JamesZ]

Hi Alert,

As mentioned the  db13 failure could be caused by wrong environment variables.

Are you using stand alone database?

Can you please let me know env result via sm69> change database RFC? Via this way, we can know the env which db13 is using.

Best regards,

James

[former_member249119]

So, please,describe step by step how to check it, honestly, i don`t know what i need to do.

[JamesZ]

hi Albert,

The problem can be oracle related environment variables are wrongly set for <sid>adm users.
Please review the environment variables as per SAP note 830578.

On the other hand , please check if "brconnect -u / -c -f check" works from os level for user <sid>adm.

Best regards,
James

[former_member249119]

Dear James,

When i perform check from os level i get this:

> brconnect -u / -c -f check

BR0801I BRCONNECT 7.20 (36)

BR0805I Start of BRCONNECT processing: cetvxgvi.chk 2016-08-17 09.16.42

BR0484I BRCONNECT log file: /oracle/<my_SID>/sapcheck/cetvxgvi.chk

BR0280I BRCONNECT time stamp: 2016-08-17 09.16.42

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance <my_SID> failed

BR0280I BRCONNECT time stamp: 2016-08-17 09.16.43

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance <my_SID> failed

BR0806I End of BRCONNECT processing: cetvxgvi.chk 2016-08-17 09.16.42

BR0280I BRCONNECT time stamp: 2016-08-17 09.16.43

BR0804I BRCONNECT terminated with errors

[JamesZ]

hi Albert,

ORA-01017 is because you didn't create ops$ for <sid>adm user.

Looks like the environment variable are correct. Are you using standalone gateway?

Can you please let me know env result via sm69> change database RFC? Via this way, we can know the env which db13 is using.

Best regards,

James

[Former Member]

Hi,

You can also refer this OSS note. Hope it may be useful to analyse the issue further.

Refer the section "ORA-01017: invalid username/password; logon denied".

400241 - Problems with ops$ or sapr3 connect to Oracle

Additionally, try to update BRTOOLS version.

Regards,

Ganesan

Message was edited by: K GANESAN

[former_member249119]

Dear all,

This issue(from my previous post) i get when i try to perform check db from ORASID user.

So, i checked table dba_users and found that no ops$orasid user exist, need i create him?Where is he used?

And when i perform brconnect -u / -c -f from SIDADM i got issue from my first post(...Unable to find library 'libskgxp10.so'...)

[JamesZ]

Hi Albert,

you mentioned:
------------------------

And when i perform brconnect -u / -c -f from SIDADM i got issue from my first post(...Unable to find library 'libskgxp10.so'...)

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

If so, then oracle related environment variables are not set correctly. Please review the note as I mentioned in the previous reply.

For the error of user orasid, please configure ops$ for orasid.

Best regards,
James

[Former Member]

Hi,

For creating OPS$ user, follow the procedures, you need to change the values according to your system environment.

Sql>CREATE USER “OPS$<DomainName>\SIDADM” TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

Sql>GRANT CONNECT, RESOURCE, DBA to “OPS$<DomainName>\SIDADM”;

Sql>GRANT SAPDBA TO “OPS$<DomainName>\SIDADM” WITH ADMIN OPTION;

Sql>CREATE USER “OPS$<DomainName>\SapserviceSID” IDENTIFIED EXTERNALLY;

Sql>CREATE TABLE “OPS$<DomainName>\SIDADM”.SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

Sql>INSERT INTO “OPS$<DomainName>\SIDADM”.SAPUSER values (’<schema_name>’, ’<initialpassword’);

Sql>ALTER USER <schema_name> IDENTIFIED BY <actual_password>;

Sql>SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = ’SAPUSER’;

Sql>CREATE SYNONYM "OPS$<DomainName>\SapserviceSID".SAPUSER FOR "OPS$<DomainName>\SIDADM".SAPUSER ;

Sql>CONNECT /

Sql>GRANT SELECT, UPDATE ON SAPUSER TO "OPS$<DomainName>\SapserviceSID";

Sql>COMMIT;

it should show "connected" after the command sql> CONNECT /

After creation, run sapdba scripts according to OSS note 834917. Also check authorization of SAP user according to the same OSS note.

Check the permission for BR* executables, they should be owned by ora and have the setuid bit set.

For the library issue, you need to check the oracle related environment variables as suggested by James.

Note: Before creating OPS$ user, could you tell us whether you have implemented SSFS for BRTOOLS? If it is implemented, BR* executable don't require OPS$ user to connect with database.

Regards,

Ganesan

Message was edited by: K GANESAN

[former_member249119]

Dear K GANESAN,

Thank for your answer.

I don`t use SSFS, i know about this authorization method, but now OPS$ only. Also, need i stop SAP/DB to create OPS$ORASID user?

[Former Member]

Hi,

Stop only SAP, database should be up and open. Logon to your database and execute all those SQL commands in the same order according to your scenario.

Regards,

Ganesan

[former_member249119]

Well, i can`t stop SAP now, i need to ask my manager about downtime.

After user creation i`ll report about result!

[Former Member]

Hi,

The steps I mentioned to create OPS$ user are for Windows environment. Please don't follow the same in Linux...:))

Regards,

Ganesan