Home > Pl Sql > Pl Sql Developer Not Logged On Error

Pl Sql Developer Not Logged On Error

Contents

You need to download and install the other one from Oracle, and point PL/SQL Developer at it. Boles 13500 8 M. You won't be able to post an actual screenshot but you can comment with a link. –Ben Dec 14 '12 at 13:25 1 If you have more than one Oracle This may be caused by the server being busy. click site

Here is image of this strange error: oracle plsqldeveloper share|improve this question edited Dec 15 '12 at 5:09 Jon Heller 17.3k32562 asked Dec 14 '12 at 13:23 user1904098 36113 4 What does the image on the back of the LotR discs represent? Hidayathullah ... 10900 9 A. The fact is that PL/SQL can read the service names from the tns.ora file but when I try to connect I get that error. http://stackoverflow.com/questions/13879527/unable-to-log-in-using-pl-sql-developer

Pl Sql Developer Blank Error Message

Database usernames (or as you referred to them as schema names) are located in dba_users. Is it? (Though, I'm quite sure that this doesn't cause your problems). My TNSNAMES.ORA file is in the directory referenced by *tns_admin*.

PCMag Digital Group AdChoices unused current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list. Experience comes from bad judgement. BIG difference. Oracle_home This thread is closed.

oracle oracle-10g plsql share|improve this question asked Feb 5 '13 at 14:43 Confused 111 Your question isn't completely clear. How To Connect To Oracle Database Using Pl Sql Developer What OS name & version? Moreover, post your client and target instance Oracle versions with 4 figures like 10.2.0.2. Like Show 0 Likes(0) Actions 17.

For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository this is like trying to get blood out of a stone.All this talk 64-bit vs 32-bit. http://www.mydigitallife.info/manual-and-clean-uninstall-oracle-for-windows/ I then installed Oracle 10G 32bit. Good luck in the future.

How To Connect To Oracle Database Using Pl Sql Developer

Go back to the original error that you posted. https://community.oracle.com/thread/3731464?start=15&tstart=0 Join this group Popular White Paper On This Topic A Beginner's Guide to VoIP 7Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes Pl Sql Developer Blank Error Message If your tnsnames is correct then presumably pl/sql developer isn't using it. Pl Sql Developer Tnsnames Ora Location Does sqlplus work?

Like Show 0 Likes(0) Actions 20. get redirected here Toolbox.com is not affiliated with or endorsed by any company listed at this site. You can not post a blank message. To start viewing messages, select the forum that you want to visit from the selection below. Pl Sql Developer Download

amarnath gorantla Sep 22, 2006, 07:04 Hi, "I am unable to connect" is not an Oracle e...... SQLNET.AUTHENTICATION_SERVICES = (NONE) By Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: Unable to connect Database Frustration will rarely get you anywhere, and will more likely get you ignored. navigate to this website share|improve this answer edited Apr 15 at 6:17 answered Apr 24 '13 at 5:58 Ujjwal 238919 I had wrong ORACLE_HOME.

Re: pl/sql developer not logged on EdStevens Jun 10, 2015 4:41 PM (in response to 2946270) 2946270 wrote: yes but i don't know why am getting an error. The problem now does not occur on a specific SQL query but just when I try to log on to the database using PL/SQL. Mark all read Contact Us · · Top Generated in 0.009 seconds in which 0.001 seconds were spent on a total of 3 queries.

Reply With Quote 06-19-09,00:04 #13 divined View Profile View Forum Posts Registered User Join Date Apr 2004 Posts 110 thx, again for the replies.

Then I press ok and another modal dialog box pops with the error : You are not using PL/SQL to log on, you are logging on via PL/SQL Developer. SQL*Plus is part of the Oracle client. Success! Look for unmatched parentheses or stray characters.

You've installed the Oracle 10G client, right? Hence, the terms user and schema are often used interchangably. Share a link to this question via email, Google+, Twitter, or Facebook. my review here Bill You do not need a parachute to skydive.

Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. up vote 3 down vote Make sure you are connected to Network/VPN. Please suggest Thanks & Regards Manoj Report message to a moderator Re: Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571111 is a reply to message Re: Re: pl/sql developer not logged on 2946270 Jun 10, 2015 3:52 PM (in response to BluShadow) yes but i don't know why am getting an error.

I know that Oracle 7 is no longer supported but until we buy a newer information system, that is what we`ve got to work with. I'm receiving "ORA-12154: TNS: could not resolve the connect identifier specified" error. Please suggest what could be the issue. Khan 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47789Total

It clearly says it needs a 32-bit Oracle client. Apparently only Only 11g clients are supported on Windows 7. –Jon Heller Dec 15 '12 at 5:16 | show 3 more comments 2 Answers 2 active oldest votes up vote 6 It resulted in error - Message 3511 not found The cause was incorrect setting of ORACLE_HOME value in my environment. Open PL/SQL Developer.

Like Show 0 Likes(0) Actions 18. Browse other questions tagged oracle plsqldeveloper or ask your own question. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Are illegal immigrants more likely to commit crimes?

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation users last 24h10Act.