Hi Friends,

I am new to oracle n I have installed oracle 10g on my windows xp and when it prmpts for username n p/w i tried these.............
scott/tiger
sys/admin
system/admin
system/manger but none worked................
it says a error message like:
ORA:12560 : TNS-PROTOCOL ADAPTER ERROR:confused
I dono how 2 resolve this
can any one help me out..plzzzzzzzzzzzzz u r help is highly apreciated
Thanks in Advance

Hi,

Is your oracle service related to the instance running?

Thanks

@risi21,

1. Try to Check the listener whether is running or not(lsnrctl status).
If not, start the listener.
lsnrctl start

2. If the DB is local to the machine then try to setting ORACLE_SID
Go to command prompt
set oracle_sid=
sqlplus /nolog
connect sys as sysdba
connect scott/tiger
Try it Out.

hi
try this,

first of all check the oracle instance running successfully or not
if it is running successfully

open sqlplus and type following

usernam/password@sid : system/change_to_install@globalname
then you will get SQL prompt

then you unlock the scott user

SQL>alter user scott account unlock;
it will ask new password for scott user, enter new password and confirm pasword then you connect to scott user with SID
other wise i will throws an exception

use the below format form username and password

if you installed your oracle in d colon,then go to command prompt

D:>sqlplus /nolog

SQL> conn sys/sys as sysdba
connected to idle instance
SQL> startup
it will start the oracle instance