|
[VIEWED 3857
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
CIGG
Please log in to subscribe to CIGG's postings.
Posted on 01-14-08 4:16
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
I think you have multiple Tnsnames.ora files in your computer or server.
It should be updated with correct info. Check again. There is no other reason to this error.
|
| |
|
|
|
|
khurmane
Please log in to subscribe to khurmane's postings.
Posted on 01-14-08 6:03
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
If you have old tns file (before applying the patchset) use that file and try to connect again. Also check if your tns file is in correct directory.
|
| |
|
|
sun4u
Please log in to subscribe to sun4u's postings.
Posted on 01-14-08 6:24
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Hey, bud why don't you remove that patch first and see what it does to the database system. I just see the problem is with the patch. Read the patch manual
|
| |
|
|
sun4u
Please log in to subscribe to sun4u's postings.
Posted on 01-14-08 6:26
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Hey, bud why don't you remove that patch first and see what it does to the database system. I just see the problem is with the patch. Read the patch manual
|
| |
|
|
null
Please log in to subscribe to null's postings.
Posted on 01-14-08 6:40
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
what does "lsnrctl status" say? Check if you are using the right service name as shown in that output in tnsnames.ora. Try to set TNS_ADMIN environment variable, if there are multiple ORACLE_HOME
|
| |
|
|
kancha01
Please log in to subscribe to kancha01's postings.
Posted on 01-14-08 6:45
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Thanks Khurmane, restored the backed up tnsnames.ora and sqlnet.ora. There is nothing on metalink too. Anythingelse on your mind?
|
| |
|
|
null
Please log in to subscribe to null's postings.
Posted on 01-14-08 8:01
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
What platform are you in? If you are in linux/unix variants use netca to configure listener. If you are in windows it should have "net configuration assitant". Then stop/start listener with lsnrctl stop/start. listener is configured in the server side whereas tnsnames.ora is used on the client side...
|
| |
|
|
null
Please log in to subscribe to null's postings.
Posted on 01-14-08 8:22
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Try setting listener.ora file as in http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/listener.htm#NETRF008
|
| |
|
|
khurmane
Please log in to subscribe to khurmane's postings.
Posted on 01-15-08 6:21
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Kanchha01,
Is your problem solved? Did you check your listener log file. Does listener start without error? Also try re-starting database and connecting again. Make sure you wait at least 1 minute before making any connection attempt after restarting database.
|
| |
|
|
sun4u
Please log in to subscribe to sun4u's postings.
Posted on 01-16-08 5:56
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
It will bring you more of this pain if you don't know how to remove a patch. Not a good practice, reinstalling the whole thing looking from Sys Admin point of view.
|
| |
|
|
sun4u
Please log in to subscribe to sun4u's postings.
Posted on 01-16-08 6:18
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Alright , I back up.... Do what you do good at... All the best my friend
|
| |
.png)
