SAP - No connection to ORACLE

[Former Member]

Hi all! I am copied my SAP instance (ECC 5.0 )with DB (ORACLE 9.2 ) in zone to create test system.

I edit DEFAULT.PFL, START and instance profile, listener.ora, tnsnames.ora for new db hostname and instance hostname.

I ran ORACLE DB through sqlplus and he started, but when run startsap i get error "no start profiles found"

I checked env variables and they coincide with the variables of the original system

When run R3trans -d

bash-3.00$ R3trans -d
This is R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'TRP'"
R3trans finished (0012).

*

When lsnrctl start

Listener Parameter File   /oracle/TRP/920_64/network/admin/listener.ora
Listener Log File         /oracle/TRP/920_64/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TRP.WORLD)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TRP)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.161)(PORT=1527)))
Services Summary...
Service "TRP" has 1 instance(s).
  Instance "TRP", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Maybe I forgot something?

Edited by: Andrey Burakov on Jun 22, 2011 12:21 PM

Edited by: Andrey Burakov on Jun 22, 2011 12:23 PM

[Former Member · Accepted solution]

Hi Andrey,

What about the trans.log after you executed R3Trans -x ?

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun!

bash-3.00$ more trans.log

4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 22.06.2011 - 14:39:40

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] Wed Jun 22 14:39:40 2011 162 0.000162

4 ETW000 [dev trc ,00000] db_con_init called 34 0.000196

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

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

4 ETW000 106 0.000382

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

4 ETW000 38252 0.038634

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

4 ETW000 49 0.038683

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

4 ETW000 54 0.038737

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

4 ETW000 514 0.039251

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

4 ETW000 52 0.039303

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

4 ETW000 98 0.039401

4 ETW000 [dev trc ,00000] New connection 0 created 58 0.039459

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 64 0.039523

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

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

4 ETW000 45 0.039603

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 56 0.039659

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/TRP/920_64 from environment

4 ETW000 403 0.040062

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

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

4 ETW000 51 0.040245

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 5740 0.045985

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPTRP's password 57 0.046042

4 ETW000 [dev trc ,00000] Connecting as /@TRP on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 69 0.046111

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

4 ETW000 60 0.046171

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1019f9290 0x101a0bcb0 0x101a0b648

4 ETW000 53 0.046224

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

4 ETW000 [dev trc ,00000] Allocating server context handle 35 0.046307

4 ETW000 [dev trc ,00000] Attaching to DB Server TRP (con_hdl=0,svchp=0x101a0b578,srvhp=0x101a0da18)

4 ETW000 88 0.046395

4 ETW000 [dev trc ,00000] Wed Jun 22 14:39:41 2011 1007522 1.053917

4 ETW000 [dev trc ,00000] Assigning server context 0x101a0da18 to service context 0x101a0b578

4 ETW000 78 1.053995

4 ETW000 [dev trc ,00000] Allocating user session handle 63 1.054058

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101a0b578,srvhp=0x101a0da18,usrhp=0x101a163f0)

4 ETW000 65 1.054123

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

4 ETW000 5389 1.059512

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x101a0da18)

4 ETW000 52 1.059564

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x101a0b578,srvhp=0x101a0da18)

4 ETW000 52 1.059616

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x101a0da18 543 1.060159

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

4 ETW000 89 1.060248

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 66 1.060314

4 ETW000 [dev trc ,00000] Try to connect with default password 215 1.060529

4 ETW000 [dev trc ,00000] Connecting as SAPTRP/<pwd>@TRP on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 72 1.060601

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

4 ETW000 56 1.060657

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1019f9290 0x101a0bcb0 0x101a0b648

4 ETW000 54 1.060711

4 ETW000 [dev trc ,00000] Allocating server context handle 33 1.060744

4 ETW000 [dev trc ,00000] Attaching to DB Server TRP (con_hdl=0,svchp=0x101a0b578,srvhp=0x101a0da18)

4 ETW000 66 1.060810

4 ETW000 [dev trc ,00000] Assigning server context 0x101a0da18 to service context 0x101a0b578

4 ETW000 86379 1.147189

4 ETW000 [dev trc ,00000] Assigning username to user session 0x101a163f0 36 1.147225

4 ETW000 [dev trc ,00000] Assigning password to user session 0x101a163f0 40 1.147265

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101a0b578,srvhp=0x101a0da18,usrhp=0x101a163f0)

4 ETW000 54 1.147319

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

4 ETW000 2256 1.149575

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x101a0da18)

4 ETW000 91 1.149666

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x101a0b578,srvhp=0x101a0da18)

4 ETW000 48 1.149714

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x101a0da18 188 1.149902

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

4 ETW000 56 1.149958

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 31 1.149989

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1034 performing CON [dblink#3 @ 428]

4 ETW000 344 1.150333

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01034: ORACLE not available 40 1.150373

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 SVR4 Error: 2: No such file or directory [dblink#3 @ 428]

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

[Former Member · Accepted solution]

Hi Andrey,

Please check the note 491174 - Composite SAP note for ORA-01034.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

As an additional point that your database is up? Isn't it

[Former Member · Accepted solution]

i started db from sqplus and shutdown. When i try run startsap db is not running

[Former Member · Accepted solution]

>>BY0=>ORA-01034: ORACLE not available 40 1.150373 4 ETW000 ORA-27101: shared memory realm does not exist 4 ETW000 SVR4 Error: 2: No such file or directory

Make sure you start the DB before you test connection via R3trans. Also check ETW000 SVR4 Error: 2: No such file or directory. Looks like some config still missing. Have you performed the OPS$ setting.

[Former Member · Accepted solution]

Hi Andrey,

As I noted that check 491174 - Composite SAP note for ORA-01034 first, Then, check environment variables, also.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Andrey,

I Guess your OS is Unix

Check the file permission of $ORACLE_HOME/bin/oracle

The permission should look like this

-rwsr-s--x 1 orad10 dba 141925514 Jul 27 2008 oracle

If it is different then change and restart the server....

Hope this will resolve your issue.

Regards,

Vivek S

[Former Member · Accepted solution]

>>>If it is different then change and restart the server....

If you change a permission then I don't think so its required to restart server.

[Former Member · Accepted solution]

ok thanks all !!! for your ansewrs ! i try all. and write

[Former Member · Accepted solution]

Hi Andrey,

Is your problem solved ?

[Former Member · Accepted solution]

Hi Vivek!

I think that I understood what my problem.

problem is very simple i forgot rename startup profiles for new hostname )

but there are new problems associated with inherit packages in zone....

when I decide this problem, I think the instance will start.

thanks all for help!!!!