What Is Oracle Sid
John Thomas replied Aug 23, 2010 ..add something like the following to tnsnames.ora PAYAL (DESCRIPTION (ADDRESS_LIST (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA (SERVICE_NAME = orcl) ) Compare elements iteratively How safe is 48V DC? Top Best Answer 1 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... I still can't connect from the Oracle Developer tools, here: Nor can I connect to the d.b.
Please enter a title. GET STARTED Join & Write a Comment Already a member? Your Oracle database is offline which is why you are seeing this error, Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | Mohammed Rizwan Khan : The Db Client (Sql Plus) and Oracle Server is on the same machine(i.e. https://community.oracle.com/thread/2578852
What Is Oracle Sid
John Thomas replied Aug 23, 2010 hi can u try to connect it like: c:> sqlplus username/[email protected]:portnumber/sid eg: c:> sqlplus scott/[email protected]:1521/orcl Top Best Answer 0 Mark this reply as the best my car won't go.tell me how to make my car go.Please provide fewer details to make guess at your problem & solution to be more of a challenge.Problem Exists Between Keyboard [email protected] 2. Instance "orcl", status READY, has 1 handler(s) for this service...
dbsarva replied Sep 26, 2010 Hi Payal, It seems that you have installed both Oracle Server Edition and Client edition on the same machine. zzz = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = dbhost) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = zzz) ) ) Maybe there's an env variable that JohnWatson Sep 8, 2013 3:13 PM (in response to sb92075) Actually, SB, the problem appears to be WITH the keyboard: it is inserting multiple '.....' characters. Ora-12154: Tns:could Not Resolve The Connect Identifier Specified For any advice.
Hot Network Questions I changed one method signature and broke 25,000 other classes. Ora-12541: Tns:no Listener Join the community of 500,000 technology professionals and ask your questions. Here's the Oracle developer tools' tnsnames in E:\app\DevSuiteHome_1\NETWORK\ADMIN EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Stephen-PC.home)(PORT = 1521)) ) (CONNECT_DATA = Bad idea.) share|improve this answer answered Nov 11 '12 at 8:15 Sathya 13.3k1667107 my tnsnames are setup correctly.
Ora-01034: Oracle Not Available
Experience comes from bad judgement. http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/not-able-to-login-to-oracle-database-from-sql-plus-3669229 Do you have proper ORACLE_SID? What Is Oracle Sid You can actually enter the whole connect string "xxx/[email protected]" at the username prompt, if you don't mind the password being visible.) share|improve this answer answered Apr 17 '09 at 18:12 Dave Ora-12162 I resolved this problem on my machine in a day..
First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Thanks! If you havent created the database execute dbca (start>run>dbca) this will start the GUI database creation assistant follow the steps you database and the instance will be created. Browse other questions tagged oracle sqlplus or ask your own question. Connected To An Idle Instance
Payal Gupta replied Aug 23, 2010 Hi, Thanks for the reply. Moving a member function from base class to derived class breaks the program for no obvious reason Why is this C++ code faster than my hand-written assembly for testing the Collatz Is adding the ‘tbl’ prefix to table names really a problem? We Wish all d best....
How to react? Ora-01031: Insufficient Privileges Get 1:1 Help Now Advertise Here Enjoyed your answer? Note that logged addresses may // not be reliable as they can be forged (e.g.
prasad_sawant15 replied Mar 8, 2011 I was try those steps.
mohanteja muppalla replied Aug 25, 2010 Miss/Mr Just try this one time: step 1: conn sys/**** as sysdba step 2: shutdown immediate/transactional step 3: go to control panel and click performance All rights reserved. There are about 3-4 DB's I can't connect to. Tnsping Click on "Local Net Service Name configuration" and Press Next. 6.
Amit Sharma replied Sep 25, 2010 can u paste the command..ur using to connect...to ur database.. You should be able to set up a direct connection but I never use that tool so I cannot say how. Thanks and regards, Payal Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Click on " Yes, perform test".
When you go to make a connection you it looks for the listener wherever you tell it to look. what is the command failing? Please help. Show 20 replies 1.