Oracle access failure

[arunpramanik]

Recently one of Oracle database is migrated to new server.
While executing a server job with ORAOCI8 stage, the jobs are failing giving the following error

ORA-12545: Connect failed because target host or object does not exist

We are using only tnsnames.ora, We can query the new database with SQL*plus from the DS Server and job is working fine with old database

please advice what is needed, am I missing any thing

Regards
Arun

[chulett]

Sorry, but what does "job is working fine with old database" mean?

[aoriano]

Hi,

You wrote the Jobs are running with the old Database. What's the difference between your databases ? Version ?

Have you tried using an oracle Oci Stage instead of an Oracle Oci 8 ?

[arunpramanik]

Sorry, but what does "job is working fine with old database" mean?

I meant while executing the job pointed to old database the job works, but we try to same to new database it fails giving the following error

[arunpramanik]

Hi,

You wrote the Jobs are running with the old Database. What's the difference between your databases ? Version ?

Have you tried using an oracle Oci Stage instead of an Oracle Oci 8 ?

The only diffrence is the new Oracle database is in RAC now

[Sainath.Srinivasan]

Was it working before ?

Is it new ?

Does it always happen?

Can you import any metadata ?

[arunpramanik]

I found what was the problem and resolution is a below

When you are accessing Oracle Database that is RAC
Then you need to identify the All RAC server node as host file in the DS Server.
Include the All the RAC SERVER NODE IPs and and SERVER NODE Names in
\drivers\etc\host file

[chulett]

In all honesty you shouldn't need to do that but it is the proper solution.

[arunpramanik]

In all honesty you shouldn't need to do that. ...

I will be grateful if any one please let me know is there any other alternatives.

[chulett]

I missed the mention you made of having to change the "hosts" file, never seen a need to do that before. You should be able to hit an individual RAC instance just like any other but you set up all nodes so it can do it's own balancing from the virtual node. Here's an example with the names changed to protect the guilty:

Code: Select all

XXX=
  (DESCRIPTION=
    (LOAD_BALANCE=yes)
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=xxxxxxx15_yyy)
        (PORT=1521)
      )
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=xxxxxxx16_yyy)
        (PORT=1521)
      )
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=xxxxxxx17_yyy)
        (PORT=1521)
      )
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=zzz1)
    )
  )

And then examples we use to connect to each one individually:

Code: Select all

XXX11=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=xxxxxxx15_yyy)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SID=xxx11)
    )
  )

XXX12=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=xxxxxxx16_yyy)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SID=xxx12)
    )
  )

XXX13=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=xxxxxxx17_yyy)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SID=xxx13)
    )
  )

If you still have issues with this, your DBA should be able to supply you with the proper TNS entries.