This content has been marked as final. Show 20 replies
Do you have a database called DB4DES on the system from where you are running SQL*Plus?
if you do, is the service for the db started?
an Instance called db4des not only exists and got its service started in the same system i'm also able to connect to it using sys/sys@db4des as sysdba.But using set oracle_sid=db4des.. i'm unable to connect!!
i have the same problem. did you actually solve the problem? I have been troubleshooting this for a day!
Do you have ORACLE_HOME variable defined?
If you do, is it pointing to the correct folder where the database software for the running database is stored?
What happens if you remove the variable ORACLE_HOME?
You can only connect this way if you are on the server that has the database (DB4DES). If you are on a client then you have to specify the sid
I agree, I did set up the oracle_home variable on cmd line. I really don't know if that really help the process. i am new to oracle.
by i had the simlar problem before, and
i have solved this problem after reading online for almost a day
the sql codes that work for me is:
sql> connect email@example.com as sysoper
and then the message shows connected
if you want to grant any access to user (that is why i connect as sys at the first place to grant access for creating repository), sign in again:
sql> connect firstname.lastname@example.org as sysdba
and the message is shown as connected.
This works for me, I installed oracle developer suite 10g in my windows xp workstation, so i accessed the sql plus via cmd
please solve the problem
error occurs 12560 when i start sql plus
Are you connecting to the database server through Remote Desktop Connection from another PC. Oracle has some problems when you try to connect to the database through the BEQ process if you are connected to the database server through Remote Desktop. If you are connecting remotely to the database server try either VNC or PC Anywhere which both seem to work properly.
how are you connecting?
where are you connecting - local database or network?
what version of oracle software is installed on the system?
do you have more than one oracle home?
can you connect to any database at all?
I'm getting the same error as these on this post when trying to login to sql*plus.
I just did a COMPLETE installation of Oracle9i DS Release 18.104.22.168.0.1 on Windows XP. So, it installed a lot of products that I will probably never use for now. All I wanted was to use SQL Plus, learning SQL. The only thing I did not install is the NET since I am not connecting to any server. I just want to create a database or tables and play with SQL.
I tried entering all those combination of username/password mentioned on this thread, but none worked. Sometimes I get TNS protocol adapter error and sometimes I get TNS something else. I even tried scott/tiger and still does not work.
I hope someone can tell me straight what username/password works without having to go through some configuration that I probably won't know how to do.
OK here is an interesting case.
Have Oracle 10.2.0 Server installed on a Win2K3,
sqlplus on this box works fine.
installed Oracle client 10.2.0 on a remote desktop Win XP SP2,
tnsnames and Net Configuration seem to work, tested fine.
sqlplus behaves as follows:
gives ORA-12560: TNS:protocol adapter error
although ORACLE_SID and ORACLE_HOME are configured correctly.
tnsping ORCL works fine.
Any idea why is that happening? please advise... thanks.
I try to connect in cmd prompt
I receive this error
ORA-12560: TNS:protocol adapter error
Pls i need urgent solution
Please consider this....
1. Before reporting this error, look at the error stack and check for lower level transport
2. Check addresses used for proper protocol specification. For further details, turn on tracing and re-execute the operation.
3. Turn off tracing when the operation is complete.
when i want to create a database this error apears: ORA-12560: TNS:protocol adapter error
how i can solve this problem?