ora-12518

[former_member254358]

Hi,

I have a connection to an external oracle 11g database in dbco. Now. I have had to change that connection because the ip has changed and once I have also changed the settings in dbco the connection seems to have problem.

Testing the connection with ADBC_TEST_CONNECTION report I get the error ora-12518.

From oracle the connection works fine. If I connect to sql plus and run the sentence conn myuser / test@mydb the result is ok. In fact the oracle db is working in productive.

Can anybody help me?

Thanks a lot.

Regards.

[former_member182657]

Hi David,

As your OS is Windows ,so first set below system environment variables :

1.Variable                Value

   ORACLE_SID       <SID>

2.ORACLE_HOME  <specify the path of your DB oracle home>

Also refer scn thread .& SAP Note 443867. After performing these steps try to use tnsping command again.

There is another transaction called dbacockpit for creating connections. What are the differences with the dbco transaction?

For the above query please refer SAP Note 1261329.( This note will help you to resolve your issue,so request to read it carefully & perform the steps specified in it.)

Hope this will help you.

Thanks,

Gaurav

[former_member254358]

Hi Gaurav,

I have create the connetion with dbacockpit and works fine. However, I will check the sap notes you have posted because it is clear that there is something wrong with my oracle connection.

I will say something more tomorrow about my issue.

Thanks a lot.

Regards.

[former_member188883]

Hi David,

Did you check the dev_wx logs to trace out for more details on the problem.

Also have you modified the tnsnames.ora files under /sapmnt/<SID>/profile/oracle folder as well.

Regards,

Deepak Kori

[Former Member]

Hi,

I don't think here the issue is with number of processes!

Because it was working fine before IP change and IP is the only change that has happened (As per you).

Then it should be with your tnsnames.ora.

1) Try to ping with hostname and check whether you are able to connect to target or not (from source)

2) TNSPING your target hostname

3) Try with IP instead of hostname

4) Check DNS settings whether your hostname is resolving with new IP or not

Paste the error messages here.

Regards,

Nick Loy

[former_member254358]

Hi Nick,

when I run tnsping I get this error:

C:\>tnsping orcx

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-ABR-2

014 12:49:17

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

Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-035

05: Message 3505 not found; No message file for product=NETWORK, facility=TNS

Could be this the problem?

[former_member182657]

Hi,

Please share parameters value for ORACLE_SID & ORACLE_HOME .It could be issue with env variables,try to set accordingly & test again with tnsping utility.

Thanks,

Gaurav 

[former_member254358]

If I run the command echo %ORACLE_SID% and the command echo %ORACLE_HOME%, they don't return anything.

I have runned both in the server machine and in the client.

In the services of the windows server I see the service OracleServiceORCX.

There is another transaction called dbacockpit for creating connections. What are the differences with the dbco transaction?

Thanks.

[former_member182657]

Hi David,

Share the parameter value for processes with SQL command show parameters processes.

Regards,

Gaurav

[former_member254358]

Sorry Gaurav. I don't understand where to look for the parameters.

Could you explain me in more detail which data to check?

Thanks a lot.

[former_member182657]

Hi David,

Execute SQL command on the database for which you maintained DBCO entry.On SQL prompt execute query for the database.

SQL> show parameters processes;

Thanks,

Gaurav

[former_member254358]

NAME                                      TYPE        VALUE

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

aq_tm_processes                      integer     1

db_writer_processes                  integer     1

gcs_server_processes                 integer     0

global_txn_processes                 integer     1

job_queue_processes                  integer     1000

log_archive_max_processes         integer     4

processes                                   integer     150

Thanks

[former_member182657]

Hi David,

Please increase value of processes by 300 with command as below:

SQL> alter system set processes=300 scope=spfile;

after setting please confirm again value of processes should reflect with 300 & try to test the connection with ADBC_TEST_CONNECTION again.

Please confirm the result.

Thanks,

Gaurav

[former_member254358]

Hi Gaurav,

once I run the command it says "system altered" but running the command "show parameters processes" the value is the same: 150...

[former_member188883]

Hi David,

As you have used the command

SQL> alter system set processes=300 scope=spfile;

This requires a DB restart to have the new value effective.

You may use below command

SQL> alter system set processes=300 scope=both; 

and check the results. It will not require DB restart to have new values effective.

Hope this helps.

Regards,

Deepak Kori

[former_member182657]

Hi David,

Could you bounce your DB once & will check again with SQL command show parameters processes .

Also confirm where you changed IP for the DB means reconfirm the tnsnames.ora & listener files for correct entries.

One more thing are you able to resolve the hostname of the server with IP ping for which you maintained entries under DBCO (As you've changed the IP for the DB).

Thanks,

Gaurav

[former_member254358]

Hi,

once the database restarted the value is 300 but the error is the same.

Perhaps the problem is that in dbco I reused an old connection. I have created a new one which exists in tnsnames.ora:

ORCX.WORLD =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP)(HOST = 173.18.0.57)(PORT = 1521))

    )

    (CONNECT_DATA =     

      (SERVICE_NAME = ORCX)

      (GLOBAL_NAME = ORCX.WORLD)

    )

  )

This connection works fine in oracle and in dbco I created a new connection in this way:

DB link   orcx

SGBD    ORA

USER    myuser

pwd

con. info   ORCX.WORLD

When I test this connection:

ADBC_TEST_CONNECTION

I get the error 12154

Any suggestion please?

[former_member254358]

Thanks Deepak for the help.

The problem is the same. I have decided to create a new connection in DBCO.

I have created a new one which exists in tnsnames.ora:

ORCX.WORLD =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP)(HOST = 173.18.0.57)(PORT = 1521))

    )

    (CONNECT_DATA =     

      (SERVICE_NAME = ORCX)

      (GLOBAL_NAME = ORCX.WORLD)

    )

  )

This connection works fine in oracle and in dbco I created a new connection in this way:

DB link   orcx

SGBD    ORA

USER    myuser

pwd

con. info   ORCX.WORLD

When I test this connection:

ADBC_TEST_CONNECTION

I get the error 12154

Help please.

[former_member188883]

Hi David,

Did you update tnsname.ora in /sapmnt/<SID>/profile/oracle folder as well.?

Regards,

Deepak Kori

[former_member182657]

Hi David,

Enable the trace for listener & share the results,for enabling listener trace please follow link Oracle Net Listener Parameters (listener.ora)

Thanks,

Gaurav

[former_member254358]

Thanks. This is the first thing I tried but the same error.

[Reagan]

Check the entries in the tnsnames.ora file are correct.

Regards

RB

[former_member254358]

The tnsnames.ora is correct.

Thanks.

[Reagan]

If only the target system IP address was changed and the hostname still remains the same then restart the SAP system and then check if the connection is successful. I believe the entries in the tnsnames.ora are maintained with the hostname and not with the IP address.

Also make sure that the tnsnames.ora present under TNS_ADMIN location is correct.

Regards

RB