INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

This could actually be either here

This could actually be either here

(OP)
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

RE: This could actually be either here

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

RE: This could actually be either here

(OP)
Yes we have we just cloned all the database servers are in the TNSNAMES.ora file. We did check that.

Cretin

RE: This could actually be either here

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

RE: This could actually be either here

(OP)
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

RE: This could actually be either here

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)


RE: This could actually be either here

(OP)
The windows host is good I am trying to get someone to check the LINUX file

Cretin

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close