Print Thread
access database
#30981 10/29/08 09:16 PM
Joined: Oct 2008
Posts: 8
x
M
Member
OP Offline
Member
M
Joined: Oct 2008
Posts: 8
x
Hi Frineds,

There are no SQL*plus. After install PL/SQL, I could not open PL/SQL (version 6.05) Developer and got message as
SQL*net not initil and OracleHoMeKey.
Where Do I need to fond file to fix this issue?
Or just copy some TNS file?

Thanks for help!!
JIm

Re: access database
#30982 10/30/08 04:06 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
SQL*Plus is not required, but you will need to install Oracle Net. This is a prerequisite for PL/SQL Developer.


Marco Kalter
Allround Automations
Re: access database
#30983 10/30/08 06:27 PM
Joined: Oct 2008
Posts: 8
x
M
Member
OP Offline
Member
M
Joined: Oct 2008
Posts: 8
x
Hi Marco,

Youmeans that SQL/Developer CD does not install SQL Net. We need to install this part. Is it true ?

Thanks for your help!
JIm

Re: access database
#30984 10/30/08 06:35 PM
Joined: Oct 2008
Posts: 8
x
M
Member
OP Offline
Member
M
Joined: Oct 2008
Posts: 8
x
Hi Marco,
I got an error message as ORA-12514 TNS: listener does not currently know of service request in corrent desceptor?

How to fix it?
I install it in DB server PC. It is working without any addition job. But PL/SQL does not working in client PC

JIm

Re: access database
#30985 10/31/08 12:02 AM
Joined: Jul 2003
Posts: 1,140
Virginia, USA
Member
Offline
Member
Joined: Jul 2003
Posts: 1,140
Virginia, USA
Can you run the SQL*Plus that came with your Oracle product installation and connect?

Did you configure the tnsnames.ora file created by the Oracle product installation? It points to your DB. It is confusing getting it all setup.


Scott Mattes
Re: access database
#30986 11/02/08 10:04 AM
Joined: Apr 2004
Posts: 203
NYC, USA
Member
Offline
Member
Joined: Apr 2004
Posts: 203
NYC, USA
I think OP has nothing - Oracle Client, tnsnames - set up.


PlSQLDev Version 8.0.4
Oracle 11gR2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.040s Queries: 14 (0.013s) Memory: 2.5156 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-04-28 09:31:53 UTC
Valid HTML 5 and Valid CSS