Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

This could actually be either here

Status
Not open for further replies.
Cretin

Cretin

Technical User
Jan 2, 2003
194
US
This could actually be either here or windows.

Our company has been recently bought out. One of our tasks was to clone some servers we were using in our old domain and add them to a new domain. For the sake of an example we will say the old domain was olddomain.net and we are moving to the domain newdomain.com. when we try to sign on to the Oracle database using SQLPLUS SQLPLUS comes up but after we enter a user name, password and host we get the message: ORA-12454: connect failed because target host or object does not exist.
The Oracle databases are in the old domain and the servers are in the new domain.We are able to use putty to access the servers the database resides on (they are Linux) and we are able to TNSPING the databases so it is unlikely to be a listener issue. When we pick another server at random in the new domain to access the Oracle it worked however that server was Linux we are on windows. The servers we are trying to access from are Windows 2008. They are in VM and the databases we are trying to access are in a cluster. Any help would be appreciated.

Cretin
 
Sort by date Sort by votes
Have you added the entry for the database servers in the old domain into the TNSNAMES.ora file on the application server

Bill
Lead Application Developer
New York State, USA
 
Upvote 0 Downvote
Yes we have we just cloned all the database servers are in the TNSNAMES.ora file. We did check that.

Cretin
 
Upvote 0 Downvote
and you have done a successful tnsping from the application server to the database server using the SID?

Bill
Lead Application Developer
New York State, USA
 
Upvote 0 Downvote
Yes we have and we have successfully telnet into the listener port. It is as if something on either Oracle or Linux is blocking us such as listener.ora.

Cretin
 
Upvote 0 Downvote
Check to see if the servers "know" about each other. You'll need your unix/linux SA. The usual unix file is /usr/bin/host. I don't know about Windows as I haven't done Windows Admin work since NT. (I haven't done unix admin either, but they haven't rewritten the Unix OS like Microsoft did with Windows).

==================================
adaptive uber info galaxies (bigger, better, faster, and more adept than cognitive agile big data clouds)


 
Upvote 0 Downvote
The windows host is good I am trying to get someone to check the LINUX file

Cretin
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Can deleted files/ directories (rm -r) be retrieved again?
Replies
6
Views
230
Livia8
Livia8
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
125
carp
carp
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
100
Beilstwh
Beilstwh
kernal
  • Locked
  • Question
Extract after and between spaces in a string 1
Replies
1
Views
76
johnherman
johnherman
rk68
  • Locked
  • Question
Hi, I'm executing the below proced
Replies
1
Views
66
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top