Solved: Run SQL command:-@ORADBUSR.SQL 'sapsc2' 'sc9';

Dear All,

When Run SQL command:-@ORADBUSR.SQL 'sapsc2' 'sc9';

i got error -

SQL> @ORADBUSR.SQL 'sapsc2' 'sc9';

SP2-0310: unable to open file "ORADBUSR.SQL"

Please help me urgent. Need to start SAP

Regards,

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hello

SP2-0310: unable to open file "ORADBUSR.SQL"

Is the file really present at the OS level ?

Check the file permissions and ownership.

If the file is present in the directory from where you called the sqlplus then most probably the issue could be with the wrong ownership for the file.

Cheers

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks RB but could you please tell me the correct path of that SQL directory.

Regards,

Hello

Assuming you are trying to re-create the OPS$ users on an Oracle database.

Download the script from this SAP Note:

Note 50088 - Creating OPS$ users on Windows NT/Oracle

Upload it on the server.

Change the ownership of the user and group to orasid:dba

Suggest you to put it in the ORACLE_HOME location.

Execute the script like this:

sqlplus /nolog @/oracle/SID/ORADBUSR.SQL SAPR3 UNIX SID x

Good Luck

Hello RB,

I have done as per your post and then i was tried to start sap instance i got the following error:-

Checking SC9 Database

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

Database is not available via R3trans

Running /usr/sap/SC9/SYS/exe/run/startdb

Trying to start SC9 database ...

Log file: /home/sc9adm/startdb.log

/usr/sap/SC9/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

I have doing the system refresh activity. After restoration i have completed all activity.

Could you please tell me that need to set environmental variables in system for schema ID?

Regards,

Be sure the listener is up

Hello

Please provide the output :

su - sc9adm

R3trans -d

Provide the contents of trans.log

Make sure the listener is started.

To start the listener

su - orasc9

lsnrctl start

Check the status of the database

sqlplus "/as sysdba"

select name, open_mode from v$database;

Cheers

Yes Sir, listener is up...

Thanks RB

Output of R3trans -d:-

"COSTING:sc9adm 21> R3trans -d

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SC9'"

R3trans finished (0012).

COSTING:sc9adm 22>

Listener started successfully.

SQL> conn / as sysdba

Connected.

SQL> select username from dba_users ;

USERNAME

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

SAPSC2

OPS$SAPSERVICESC9

SAPSC9

OPS$SC9ADM

DBSNMP

OPS$ORASC2

OUTLN

OPS$ORASC9

OPS$SC2ADM

SYS

SYSTEM

USERNAME

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

TSMSYS

DIP

ORACLE_OCM

14 rows selected.

Regards,

Ajay Asawa

Hello,

I have check trans.log in /usr/sap/trans/log but there is no any log file for current date.

How can i get the contents of trans.log?

Regards,

Ajay

Hello

For every R3trans -d execution there will be a trans.log file generated at the OS level.

You will find a trans.log file at the place from where you execute it.

it is trans.log and NOT trans/log. We are not talking about the transport directory here.

su - sc9adm

R3trans -d

pwd

ls -la trans.log

cat trans.log

I believe he above commands are understandable for you.

Good Luck

Thanks RB.

Below is the content of trans.log file :-

4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 10.05.2013 - 13:50:02

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri May 10 13:50:02 2013 360 0.000360

4 ETW000 [dev trc ,00000] db_con_init called 24 0.000384

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 33 0.000417

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SC9/SYS/exe/run/dboraslib.so' ...

4 ETW000 48 0.000465

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/SC9/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 35592 0.036057

4 ETW000 [dev trc ,00000] Library '/usr/sap/SC9/SYS/exe/run/dboraslib.so' loaded

4 ETW000 46 0.036103

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/SC9/SYS/exe/run/dboraslib.so

4 ETW000 91 0.036194

4 ETW000 [dev trc ,00000] Version of '/usr/sap/SC9/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.25)

4 ETW000 331 0.036525

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/SC9/SYS/exe/run/dboraslib.so

4 ETW000 45 0.036570

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/SC9/SYS/exe/run/dboraslib.so

4 ETW000 66 0.036636

4 ETW000 [dev trc ,00000] New connection 0 created 69 0.036705

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 46 0.036751

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 97 0.036848

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 36 0.036884

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 43 0.036927

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.5.0' 625 0.037552

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 29 0.037581

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 6481 0.044062

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'

4 ETW000 60 0.044122

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSC2's password 54 0.044176

4 ETW000 [dev trc ,00000] Connecting as /@SC9 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

4 ETW000 40 0.044216

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 54 0.044270

4 ETW000 [dev trc ,00000] 0 UTF8 0 0x6000000001052910 0x600000000105aaf8 0x6000000001094d78

4 ETW000 61 0.044331

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 57 0.044388

4 ETW000 [dev trc ,00000] Allocating server context handle 28 0.044416

4 ETW000 [dev trc ,00000] Attaching to DB Server SC9 (con_hdl=0,svchp=0x600000000105aa28,srvhp=0x60000000010980b8)

4 ETW000 45 0.044461

4 ETW000 [dev trc ,00000] Assigning server context 0x60000000010980b8 to service context 0x600000000105aa28

4 ETW000 60314 0.104775

4 ETW000 [dev trc ,00000] Allocating user session handle 92 0.104867

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x600000000105aa28, srvhp=0x60000000010980b8, usrhp=0x600000000111c860)

4 ETW000 76 0.104943

4 ETW000 [dev trc ,00000] Assigning user session 0x600000000111c860 to service context 0x600000000105aa28

4 ETW000 11222 0.116165

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=53, stmth_p=0x60000000010a1870)

4 ETW000 191 0.116356

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1); END;

4 ETW000 43 0.116399

4 ETW000 [dev trc ,00000] CbApplInfoGet() failed! Ignore, but uninstall callback to avoid more erroneous calls

4 ETW000 346 0.116745

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=54, stmth_p=0x60000000010a28c8)

4 ETW000 38 0.116783

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

4 ETW000 41 0.116824

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x600000000109f790)

4 ETW000 1191 0.118015

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 42 0.118057

4 ETW000 [dev trc ,00000] Connected to session 133. 755 0.118812

4 ETW000 [dev trc ,00000] Now '/@SC9' is connected: con_hdl=0, nls_hdl=0, session_id=133.

4 ETW000 44 0.118856

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x600000000109f790)

4 ETW000 42 0.118898

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 42 0.118940

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x600000000109f790)

4 ETW000 367 0.119307

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 42 0.119349

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER

4 ETW000 520 0.119869

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 26 0.119895

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 329 0.120224

4 ETW000 [dev trc ,00000] Rolling back transaction ... 37 0.120261

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x600000000105aa28,usrhp=0x600000000111c860)

4 ETW000 182 0.120443

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 679 0.121122

4 ETW000 [dev trc ,00000] Try to connect with default password 30 0.121152

4 ETW000 [dev trc ,00000] Connecting as SAPSC2/<pwd>@SC9 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

4 ETW000 41 0.121193

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 43 0.121236

4 ETW000 [dev trc ,00000] 0 UTF8 0 0x6000000001052910 0x600000000105aaf8 0x6000000001094d78

4 ETW000 42 0.121278

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x600000000111c860

4 ETW000 40 0.121318

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x600000000111c860

4 ETW000 47 0.121365

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSC2/<pwd>, svchp=0x600000000105aa28, srvhp=0x60000000010980b8, usrhp=0x600000000111c860)

4 ETW000 782 0.122147

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

4 ETW000 3173 0.125320

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 42 0.125362

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 25 0.125387

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]

4 ETW000 327 0.125714

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

4 ETW000 40 0.125754

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SC9'"

Please help

Do you have need the environmental variable content?

Regards,

Ajay Asawa

Hello

Here is the problem.

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
4 ETW000                                                                            3173  0.125320
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1017'
4 ETW000                                                                              42  0.125362
4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 1017         25  0.125387
4 ETW000  [dblink      ,00431]  ***LOG BY2=>sql error 1017   performing CON [dblink#3 @ 431]
4 ETW000                                                                             327  0.125714
4 ETW000  [dblink      ,00431]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Cheers

Thanks RB for your help.

My problem has been resolved by below command:--

DROP TABLE "SAPSC9".SAPUSER;

CREATE TABLE "OPS$SC9ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

GRANT UNLIMITED TABLESPACE TO OPS$SC9ADM

INSERT INTO "OPS$SC9ADM".SAPUSER VALUES ('SC9ADM','<password>');

SELECT * FROM DBA_USERS WHERE USERNAME = 'OPS$SC9ADM';

SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$SC9ADM';

GRANT CONNECT, RESOURCE TO "OPS$SC9ADM";

brconnect -u system/<password> -f chpass -o <schema id> -p <password>

Thanks to all of you.

Regards,

Ajay Asawa

Answers (2)

Dear Team,

dbms_type=ORA

dbs_ora_tnsname=SC9

dbs_ora_schema=SAPSC2

ORACLE_SID=SC9

DB_SID=SC9

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/SC9/SYS/profile/oracle

ORACLE_HOME=/oracle/SC9/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/SC9

Please correct if anything is wrong. We have using Oracle 10.2.0.4 and HP Unix

Thanks in advance

Regards,

Ajay

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Ajay,

Check the Note 50088 - Creating OPS$ users on Windows NT/Oracle

Best regards,

Orkun Gedik

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Orkun,

Thanks for your reply but we have using HP UX environment

Regards,

Hi,

This is valid for both ux and Window environments. Please check the Note 361641 - Creating OPS$ users on UNIX

Best regards,

Orkun Gedik

Sir, could you please give me the path of file "oradbusr..sql" in HP UX?

Regards,

Ajay

Hi Ajay,

You can find it in the installation master dvd "/<platform>/COMMON/INSTALL/ORA"

Just download and execute oradbsql in the note 50088, as I noted in my previous message. That's what you need to do.

Best regards,

Orkun Gedik

Ask a Question

Top Q&A Solution Author

User

Count

Run SQL command:-@ORADBUSR.SQL 'sapsc2' 'sc9';

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

ABAP RAP - Service Binding is not getting refreshe...

Re: Customize body mail for medium type 5 external...

Re: User Deprovisioning Signavio

Re: Customize body mail for medium type 5 external...

Sac Dimension Comment