Oracle access failure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 63
- Joined: Fri Jun 22, 2007 7:27 am
- Location: Kolkata
Oracle access failure
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
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
-
- Participant
- Posts: 63
- Joined: Fri Jun 22, 2007 7:27 am
- Location: Kolkata
-
- Participant
- Posts: 63
- Joined: Fri Jun 22, 2007 7:27 am
- Location: Kolkata
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 63
- Joined: Fri Jun 22, 2007 7:27 am
- Location: Kolkata
-
- Participant
- Posts: 63
- Joined: Fri Jun 22, 2007 7:27 am
- Location: Kolkata
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:
And then examples we use to connect to each one individually:
If you still have issues with this, your DBA should be able to supply you with the proper TNS entries.
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)
)
)
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)
)
)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers