How to connect to Oracle database from unix prompt

[saurabhjain]

Is there any other command to connect to oracle database from unix prompt apart from 'sqlplus usename/passwd'

[rajputvikas]

You may use following
UNIX> sqlplus /nolog
SQL> connect internal
.. do your admin stuff..

Please note that this is just equivalent to saying
UNIX> sqlplus '/ as sysdba'

Moreover, "connect internal" is getting desupported going forward. Also, if you are trying to connect as different user from within an SQLPLUS session use following:
SQL> connect user_next/passwd@dbname;

If you are looking for connecting to db outside SQLPLUS, then please understand that SQLPLUS is an utility which allows access to your database and passes on your queries/DML's/DDL's to database and hence you need to pass through that route only.

Hope it helps.... let me know any followup queries....

[lifeisonlyluck]

Thank You Vikas, this was helpful to me.

Kumar