cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ABAP Database is not available via R3trans ? R3trans check finished with return code: 12

Go to solution
Former Member

on ‎11-18-2013 2:51 AM

0 Kudos

Hi Experts,

We did a restore&recovery process from a production server backup on a newly built HP-ux server same as the production server.

But when we try to startsap it after recovery from sidadm it shows

startsap_DVEBMGS30.log

Checking <SID> Database

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

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

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

saposcol already running

Running /usr/sap/<SID>/SYS/exe/run/startdb

DB startup failed

log information from startdb.log

----------------------------- Tue Nov 12 14:20:45 SST 2013

LOGFILE FOR STARTING ORACLE

Trying to start <SID> database ...

------------------------------ Tue Nov 12 14:20:45 SST 2013

checking required environment variables

ORACLE_HOME  is >/oracle/<SID>/112_64<

ORACLE_SID   is ><SID>

------------------------------ Tue Nov 12 14:20:45 SST 2013

check initora

------------------------------ Tue Nov 12 14:20:45 SST 2013

check initora

------------------------------ Tue Nov 12 14:20:45 SST 2013

checking V2 connect

TNS Ping Utility for HPUX: Version 11.2.0.2.0 - Production on 12-NOV-2013 14:20:45

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:

/sapmnt/<SID>/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = xxxxxxx) (PORT = 1528))) (CON

NECT_DATA = (SID = <SID>) (GLOBAL_NAME = <SID>.WORLD)))

OK (10 msec)

tnsping: V2 connect to <SID>

------------------------------ Tue Nov 12 14:20:45 SST 2013

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12 Database not available

------------------------------ Tue Nov 12 14:20:45 SST 2013

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

------------------------------ Tue Nov 12 14:20:54 SST 2013

starting database

SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 12 14:20:55 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 4576575488 bytes

Fixed Size                  2188712 bytes

Variable Size            2298481240 bytes

Database Buffers         2264924160 bytes

Redo Buffers               10981376 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

------------------------------ Tue Nov 12 14:21:10 SST 2013

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

*** ERROR: Startup of database failed

    Notify Database Administrator.

/usr/sap/<SID>/SYS/exe/run/startdb: Terminating with error code 12

When i tried to connect to database SQL i am able to connect.so database is up and running

Later i tried to run R3trans -d command

trans.log...........

4 ETW000 date&time   : 12.11.2013 - 14:06:17

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000  [dev trc     ,00000]  Tue Nov 12 14:06:17 2013                             261  0.000261

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

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

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

4 ETW000                                                                              49  0.000404

4 ETW000  [dev trc     ,00000]  DlLoadLib() success: dlopen("/usr/sap/<SID>/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000                                                                           28573  0.028977

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

4 ETW000                                                                              41  0.029018

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

4 ETW000                                                                              68  0.029086

4 ETW000  [dev trc     ,00000]  Version of '/usr/sap/<SID>/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.369)

4 ETW000                                                                             239  0.029325

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

4 ETW000                                                                              46  0.029371

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

4 ETW000                                                                              64  0.029435

4 ETW000  [dev trc     ,00000]  New connection 0 created                              36  0.029471

4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                             144  0.029615

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

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

4 ETW000                                                                              39  0.029730

4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              61  0.029791

4 ETW000  [dev trc     ,00000]  Got ORACLE_HOME=/oracle/<SID>/112_64 from environment

4 ETW000                                                                             294  0.030085

4 ETW000  [dev trc     ,00000]    Default connection: tnsname ='<SID>'                  92  0.030177

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalChar                 C      EnvHp      ErrHp      ErrBt

4 ETW000                                                                              57  0.030234

4 ETW000  [dev trc     ,00000]  -->oci_initialize (con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2)

4 ETW000                                                                              42  0.030276

4 ETW000  [dev trc     ,00000]  got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

4 ETW000                                                                              41  0.030317

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call '(-) OCIEnvCreate(mode=16384)' failed: rc = -1

4 ETW000                                                                            1880  0.032197

4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code -1           28  0.032225

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

4 ETW000                                                                              76  0.032301

4 ETW000  [dblink      ,00430]  ***LOG BY2=>sql error -1     performing CON [dblink#6 @ 430]

4 ETW000                                                                             161  0.032462

4 ETW000  [dblink      ,00430]  ***LOG BY0=>Cannot get Oracle error text. [dblink#6 @ 430]

4 ETW000                                                                              41  0.032503

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = '<SID>'"

I found the above error in trans.log file

So, why is sap not able to communicate with database(Oracle 11g)

Can you please help us to find cause and solution for this error.

Thank you,

Mahesh.M

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

ashish_vikas
Active Contributor
‎11-18-2013 3:24 AM
0 Kudos

Have you created OPS$ user as per sap note 50088 & 400241 ?

If not, please create this.

http://scn.sap.com/message/13834899

You just  modify according to your current system setup.

1.Login to orasid and  execute  sqlplus "/as sysdba"

2.CREATE USER "OPS$<Hostname>\<SID>ADM" DEFAULT TABLESPACE PSAPSR3 TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

3.SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$<Hostname>\<SID>ADM';

4.GRANT CONNECT, RESOURCE TO "OPS$<Hostname>\<SID>ADM";

5.CREATE USER "OPS$<Hostname>\SAPSERVICE<SID>" DEFAULT TABLESPACE PSAPUSER1D TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

6.SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$<Hostname>\SAPSERVICE<SID>';

7.GRANT CONNECT, RESOURCE TO "OPS$<Hostname>\SAPSERVICE<SID>";

8.SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

9.CREATE TABLE "OPS$<Hostname>\<SID>ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

10.INSERT INTO "OPS$<Hostname>\<SID>ADM".SAPUSER VALUES ('SAPSR3', 'Password');

11.SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'SAPUSER';

12.CREATE SYNONYM "OPS$<Hostname>\SAPSERVICE<SID>".SAPUSER FOR "OPS$<Hostname>\<SID>ADM".SAPUSER;

13.

GRANT SELECT, UPDATE ON "OPS$<Hostname>\<SID>ADM".SAPUSER TO "OPS$<Hostname>\SAPSERVICE<SID>";

best regards

ashish

Show replies
Show replies

Answers (2)

Answers (2)

Former Member
‎11-19-2013 3:33 AM
0 Kudos

Hi Guys,

Thank you all for your support!!

startsap command is working and R3trans is able to communicate with abap database.

But when i check the startup_DV.....log

Starting Programs

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

19.11.2013 11:25:00

ShmDetach

FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen()

(12174) Starting: local ms.sap<SID>_DVEBMGS30 pf=/usr/sap/<SID>/SYS/profile/<SID>_DVEBMGS30_hostname

(12175) Starting: local dw.sap<SID>_DVEBMGS30 pf=/usr/sap/<SID>/SYS/profile/<SID>_DVEBMGS30_hostname

(12176) Starting: local co.sap<SID>_DVEBMGS30 -F pf=/usr/sap/<SID>/SYS/profile/<SID>_DVEBMGS30_hostname

(12177) Starting: local se.sap<SID>_DVEBMGS30 -F pf=/usr/sap/<SID>/SYS/profile/<SID>_DVEBMGS30_hostname

(12153) Waiting for Child Processes to terminate.

(12153) **** 2013/11/19 11:25:01 Child 12174 terminated with Status 0 . ****

(12174) **** 2013/11/19 11:25:01 No RestartProgram command for program 1  ****

(12153) **** 2013/11/19 11:25:19 Child 12175 terminated with Status 0 . ****

(12175) **** 2013/11/19 11:25:19 No RestartProgram command for program 2  ****

Instance on host "name" started

Checking Installation

...............

Starting IGS

Show replies
Show replies
former_member188883
Active Contributor
‎11-19-2013 4:54 AM
0 Kudos

Hi Mahesh,

Are you able to login to SAP system ?

IF yes, run SICK tcode and ensure its green.

If above case is true , just ignore the information in the log.

Regards,

Deepak Kori

Former Member
‎11-19-2013 8:43 AM
0 Kudos

Hi Deepak,

Thank for your reply

SAP is up and running i tried to connect through gui but it License is not installed login refused(valid license not installed)

Thank you,

Regards,

Mahesh

Reagan
Advisor
Advisor
‎11-19-2013 9:28 AM
0 Kudos

Request for a new license with the correct hardware key and install it.

Regards

RB

Former Member
‎11-20-2013 5:18 AM
0 Kudos

Hi RB,

If i need to copy the same license key from PROD server and install it in the newly built server(just to test not live) what to do.I dont have access through gui,from os level how can i do.

i have set the login/no_automatic_user_sapstar profile parameter to the value 0 but still i am unable to log in using SAP* and PASS

Thank you

Regards,

Mahesh

Reagan
Advisor
Advisor
‎11-20-2013 7:31 AM
0 Kudos 
If i need to copy the same license key from PROD server and install it in the newly built server(just to test not live) what to do.I dont have access through gui,from os level how can i do.

The PRD license will be already present in the system if you have restored the PRD database (unless you have deleted it).

The license is stored in the database.

What matters is the Hardware key. if the production server and test server are having different hardware keys then the license will be invalid.

Regards

RB

former_member188883
Active Contributor
‎11-18-2013 5:32 AM
0 Kudos

Hi Mahesh,

As you are on HPUX, please download the ORADBUSR.SQL file attached with SAP note  50088.

Then follow the steps described in SAP note

361641 - Creating OPS$ users on UNIX

The script will help you to create the required OPS$ users.

Hope this helps.

Regards,

Deepak Kori

Show replies
Show replies
Former Member
‎11-18-2013 10:14 AM
0 Kudos

Hi Ashish/Deepak,

Thank you very much for responding...i have followed the steps u gave, as per the document when i try to change the password for SAP<sid> schema using brconnect

brconnect -u system/xxxxxx -f chpass -o SAP<sid> -p xxxxxxxxx

this is what is got

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

Killed

I tried brtools  and tried to change the password for SAP<sid> user but the same result.

so what went wrong in this process.

Thank you,

Regards

Mahesh

Reagan
Advisor
Advisor
‎11-18-2013 10:25 AM
0 Kudos

Hello

Have you installed the Oracle Instant Client software ?

Check this SAP note

819829  - Oracle Instant Client Installation and Configuration on Unix

Regards

RB

Ask a Question