user4052131 wrote:Then you should open an SR with Oracle. But given that you seem to be trying to set up either just a client machine or a machine not used for a customer-facing, revenu-producing production database (as evidenced by the fact you are doing this on XP) I doubt if even they would consider it "urgent".
Hello everyone my name is Dilshad, someone please help me this is urgent.
I have Windows XP, I tried the loop adapter method that didn't work, then I tried the IP address method for dns server and original that didn't work, I even reinstalled oracle10g on it but I keep getting this error message: "Error: ORA-12560: TNS: protocol adapter error" Why is this happening? I have done most things to correct but still invalid.I'm sorry, but I wasn't looking over your shoulder when you did this, so I have no idea what you did or where you got the reported error.
Copy the entire session, and paste it back to your next posting.
set sqlplus / as sysdba
Someone please email me: firstname.lastname@example.orgPost to the forum, read from the forum.
user4052131 wrote:I gave you two separate commands. You combined them into one .....
Hello Steve thanks for responding, I am using all of the materials in the system for my class. Meaning including server and client the main mission is to do all things with Sql writing commands reading etc but I get that error. I did what you said on command prompt and this is what I get:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\User>set sqlplus / as sysdba
Environment variable sqlplus / as not defined
C:\Documents and Settings\User>setYou have not set ORACLE_HOME.
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\User\Application Data
CommonProgramFiles=C:\Program Files\Common Files
HOMEPATH=\Documents and Settings\User
NDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technolo
gies\ATI Control Panel;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;
C:\Program Files\PC-Doctor for Windows\services
PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5, GenuineIntel
RRU=C:\Program Files\IBM\IBM Rapid Restore Ultra\
USERPROFILE=C:\Documents and Settings\User
C:\Documents and Settings\User>sqlplus / as sysdbaThat is the expected error when ORACLE_SID is not set.
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Dec 5 10:28:14 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ORA-12560: TNS:protocol adapter error
Enter user-name: ^VA couple of important points.
Now, when you issue a connect, say like this:
larry = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = curley) ) )
tns will look in your tnsnames.ora for an entry called 'larry'. Finding it, tns sends a request through the normal network stack to (PORT = 1521) on (HOST = myhost) using (PROTOCOL = TCP), asking for a connection to (SERVICE_NAME = curley).
$> sqlplus scott/tiger@larry
tns will attempt to establish an IPC connection to the db instance. How does it know the name of the instance? It uses the current value of the enviornment variable ORACLE_SID. So...
$> sqlplus scott/tiger
It will attempt to connect to the instance known as "fred". If there is no such instance, it will, of course, fail. Also, if there is no value set for ORACLE_SID, the connect will fail.
$> export ORACLE_SID=fred $> sqlplus scott/tiger
set ORACLE_SID appropriately, and connect
[oracle@vmlnx01 ~]$ ps -ef|grep pmon|grep -v grep oracle 4236 1 0 10:30 ? 00:00:00 ora_pmon_vlnxora1
Now set ORACLE_SID to a bogus value, and try to connect
[oracle@vmlnx01 ~]$ export ORACLE_SID='vlnxora1 [oracle@vmlnx01 ~]$ sqlplus scott/tiger SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 22 10:42:37 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Now set ORACLE_SID to null, and try to connect
SQL> exit [oracle@vmlnx01 ~]$ export ORACLE_SID=FUBAR [oracle@vmlnx01 ~]$ sqlplus scott/tiger SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 22 10:42:57 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Enter user-name:
Ok, that is how we get from the client connection request to the listener. What about the listener's part of all this?
[oracle@vmlnx01 ~]$ export ORACLE_SID= [oracle@vmlnx01 ~]$ sqlplus /scott/tiger SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 22 10:43:24 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-12162: TNS:net service name is incorrectly specified
user4052131 wrote:I can't see what you do or what you get.
Thanks Steve, but I think I have been cheated, I got a laptop from someone and just now when I tried to turn it on it does turn on but it gives me error on each application when I try connecting, so now I am using my other laptop Windows Vista and installed Oracle10g and now I get a invalid user name and password but I am 100% sure the username and password is right.