Thanks in anticipation, Payal Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... To start viewing messages, select the forum that you want to visit from the selection below. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> What should i do next? I wanted to comment on the original question about timeouts. 99% of the time these are due to a firewall issue.
Filed under Uncategorized ← ok, lets try itout. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... zzz = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = dbhost) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = zzz) ) ) Maybe there's an env variable that That's not in my environment. official site
fons bouma replied Sep 26, 2010 Try ORCL as the value for your host-string in sqlplus. Since you specified a service name (database) in teh sql developer window, it is trying a network connection. Then Leave the default selection i.e TCP, click next. 8. At this time it will give error.
Reply With Quote 05-08-09,02:27 #3 dadorador View Profile View Forum Posts Registered User Join Date May 2009 Location Manila, Philippines Posts 16 I already tried connecting using the command line however How to reject an interview if there is some possible future collaboration? Please reply. Ora-12154: Tns:could Not Resolve The Connect Identifier Specified Antonym for Nourish Is the solidity compiler deterministic?
Why does low frequency RFID have a short read range? Leave a Reply Cancel reply Enter your comment here... Uninstall the client version. 2. http://stackoverflow.com/questions/13327516/not-able-to-connect-to-sqlplus-sql-developer-is-fine Aman....
Bad idea.) share|improve this answer answered Nov 11 '12 at 8:15 Sathya 13.3k1667107 my tnsnames are setup correctly. Ora-12541: Tns:no Listener About the Background process you can see in task manager a process with the name "oracle" will be running if your database is up and running., you cant see the backgrond So you are actually entering the wrong password when you execute the conn system/password, Oracle doest not lie. Can I hide disabled users in the User Manager?
Like Show 0 Likes(0) Actions 1 2 Previous Next Go to original post Actions Incoming Links Re: how to logon sqlplus? http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/not-able-to-login-to-oracle-database-from-sql-plus-3669229 Payal Gupta replied Aug 1, 2010 Hi All, Thanks for quick response from all of you. What Is Oracle Sid Payal Gupta replied Aug 18, 2010 Hi, Thanks for your response. Ora-12162 ORACLE instance shut down.
Join & Ask a Question Need Help in Real-Time? Instance "orcl", status READY, has 1 handler(s) for this service... How are the functions used in cryptographic hash functions chosen? I am still struggling with that. Connected To An Idle Instance
Seems like you're missing some pieces there. –Jon Ericson♦ Apr 17 '09 at 23:43 add a comment| up vote 0 down vote FOLLOW THIS LINK FOR STEP BY STEP INSTALLATION AND Not the answer you're looking for? Please let us know the correct website link from where you downloaded the Oracle Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes All rights reserved.
So....Final advice....take one person's advice only....choose the person who will advise and follow only his instruction. Ora-01031: Insufficient Privileges Payal, let us know more about your environment and then we shall tell you the exact commands Top White Papers and Webcasts Popular Big Data and the CMO: An Introduction to Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
asked 7 years ago viewed 67078 times active 8 months ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Linked 113 How SID is different from Service name in Oracle jackad : I have already posted everything, anyway, i am again posting my issue for those who don’t know the issue. SQL Plus and giving the credentials as Username : System Password : payaldb HostString : Payalur-PC I am getting the following error: Error : > ORA-12514 : TNS: Listener does not Tnsping Because what I told you is not the whole story.
this is what I get after trying to connect using both System and Scott: oracle sqlplus share|improve this question edited Mar 18 '15 at 17:34 asked Mar 18 '15 at 14:16 Did you try any of them to resolve the error?Aman.... i think u have to start first listner than try to connect. >lsnrctl start Regards Ranjeet Chandigarh . I still can't connect from the Oracle Developer tools, here: Nor can I connect to the d.b.