Mr Jovery,

I think you have not read the previous section of my post. I have clearly stated that Iam able to login as user DCBL which means that the database is up.

Iam not able to connect as any user through telnet, able to connect as user DCBL through SQLPLUS directly.

Dear Orca777,

Iam pasting the output of the command: set | grep -i oracle
What I could infer from this is that the SID is OASIS and not DCBL. But I have given the command: export oracle_sid=dcbl. But this is of no use. I have little knowledge on UNIX. Pls advice me on the same :


$ set | grep -i oracle
IST_DBUSED=oracle
LD_LIBRARY_PATH=/oasis/ist73/lib:/oracle/oracle9/app/oracle/product/9.0.1/lib:/u
sr/openbin/lib:/oasis/ist73/lib:/usr/devlpr/ist/lib:
ORACLE_BASE=/oracle/oracle9
ORACLE_HOME=/oracle/oracle9/app/oracle/product/9.0.1
ORACLE_SID=oasis
PATH=/oasis/ist73/ositeroot/bin:/usr/local/bin:/opt/SUNWspro/bin:.:/oasis/ist73/
bin:.:/bin:/etc:/usr/bin:/usr/sbin:/opt/rsc/bin:/usr/ccs/bin:/usr/ucb:/oracle/or
acle9/app/oracle/product/9.0.1/bin:/oracle/oracle9/app/oracle/product/9.0.1/lib:
/usr/openwin/bin:/usr/dt/bin:/oasis/ist73/bin:/oasis/ist73/lib:/oasis/ist73/form
s:/oasis/ist73/sql:/usr/4lib:/oasis/ist73:/usr/local/bin:/oasis/ist73/ositeroot/
bin:/oasis/ist73/ositeroot/cfg:/usr/sbin:/opt/SUNWspro/bin:/usr/bin:
_=oracle_sid=oasis
oracle_sid=oasis
$



Regards,

K.Diwakar