Home » RDBMS Server » Networking and Gateways » 10g won't connect to 9i
10g won't connect to 9i [message #219471] Wed, 14 February 2007 10:23 Go to next message
mjb2593
Messages: 4
Registered: February 2007
Junior Member
Probably this is addressed already but I couldn't find it.
I have two servers - one runs 9i and the other runs 10g. The clients that have 10g installed connect to the 10g service fine, but not to the service running on the 9i server. (error 12535). The 9i clients are able to connect to both.
Any ideas?
Re: 10g won't connect to 9i [message #219473 is a reply to message #219471] Wed, 14 February 2007 10:33 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>Any ideas?
PEBKAC is most likely.
Re: 10g won't connect to 9i [message #219474 is a reply to message #219471] Wed, 14 February 2007 10:34 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Are you check your both computer connect to each other.I mean not network problem. check
cmd>ping SERVER_IP_ADDRESS

or
check firewall is disable ?

regards
Taj
Re: 10g won't connect to 9i [message #219475 is a reply to message #219473] Wed, 14 February 2007 10:37 Go to previous messageGo to next message
mjb2593
Messages: 4
Registered: February 2007
Junior Member
PEBKAC - I agree but doesn't provide anything useful.
Re: 10g won't connect to 9i [message #219477 is a reply to message #219474] Wed, 14 February 2007 10:39 Go to previous messageGo to next message
mjb2593
Messages: 4
Registered: February 2007
Junior Member
All computers ping each other. All are on a private LAN without a firewall.
The TNSPING times out.
Re: 10g won't connect to 9i [message #219489 is a reply to message #219471] Wed, 14 February 2007 11:14 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>PEBKAC - I agree but doesn't provide anything useful.
Neither did your posts.
No OS name or versions.
No clue if ever worked or what changed.

12535, 00000, "TNS:operation timed out"
// *Cause: The requested operation could not be completed within the time out
// period.
// *Action: Look at the documentation on the secondary errors for possible
// remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
// Turn on tracing to gather more information.


Your post about the same as me saying my new car does not go but my old car goes, please tell me how to make new car go.

[Updated on: Wed, 14 February 2007 11:18] by Moderator

Report message to a moderator

Re: 10g won't connect to 9i [message #219935 is a reply to message #219489] Fri, 16 February 2007 16:30 Go to previous message
mjb2593
Messages: 4
Registered: February 2007
Junior Member
Sorry but Oracle is not my job, having trouble finding truly basic information. Mostly just getting headaches.

Try to give more information.
All systems are Windows based.
Oracle 9i server was installed one year ago, could access database from server computer and one client.
Installed 10g on a new machine a couple of months ago.
Installed clients (run time with Windows components added), one 9i, and one 10g. (I need to test under different environments.)
Now, the only client that can access the 9i database is the one on the same computer as the database.
That client and all others can reach the 10g database. Both listener.ora files are the same.
The 9i server is running the database service and the listener service. The Ora92management service will not start, error that a dependency is missing. I cannot figure out how to start a trace or even which machine to use. I tried a Windows ODBC trace and after start and stop, no file is created.
(Sometimes I feel like I'm losing my mind.)
The sql.ora file shows some errors that I don't see defined, like 505 with secondary error 60.
12535 secondary 12560.
NT OS error code 0.
The Windows Event Viewer shows 2,000+ events but none of them are displayed.
I don't want to be a baby here but all the references I find are over my head. I have a 9i book but it doesn't even mention the listener or which services are required. If you can point me to some baby steps, I promise never to write in again.
Previous Topic: ora-03134 when connecting from 10gR2 to 8.1.7
Next Topic: change SYSDBA password change_on_install password
Goto Forum:
  


Current Time: Tue Dec 06 00:07:55 CST 2016

Total time taken to generate the page: 0.05640 seconds