When I'm attempting to tnsping my database from the server it is stored on, I keep getting error code 3509, however I can ping my database from clients. I've checked naming in tnsnames.ora and all is as it should be. Any ideas???
awittyusername
0
Newbie Poster
Recommended Answers
Jump to PostThings to check:
More than one installation of oracle on the server or more than one oracle_home. If so you will have multiple tnsnames.ora files. If this is not the case then try setting TNS_ADMIN to point to the Oracle_home\network\admin directory.
Regards
Alistair
Jump to PostOkay, go to the oracle_home\network\admin directory and check that you have a listener.ora file and tnsnames.ora file. If not then use the Net Manager utility to configure the listener and start it from the command line using
c:\> lsnrctl start
This should create the service and start the …
All 7 Replies
alit2002
0
Junior Poster in Training
awittyusername
0
Newbie Poster
alit2002
0
Junior Poster in Training
awittyusername
0
Newbie Poster
awittyusername
0
Newbie Poster
alit2002
0
Junior Poster in Training
awittyusername
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.