Sql Plus Connection Issues

Chandhan S J

I am having some issues when connecting using Command Line in Unix.

rm -rf /home/oracle/Desktop/Unix_Sample_Files/Test1.txt

sqlplus -s hr/[email protected] <<EOF

set linesize 32767

set pagesize 50000

spool /home/oracle/Desktop/Unix_Sample_Files/Test1.txt

select * from employees;

spool off

exit

EOF

This is working fine and giving the output.

But the below is not working and giving the error. Tried all the methods but was unable to resolve them.

rm -rf /home/oracle/Desktop/Unix_Sample_Files/Test2.txt

sqlplus -s sys as sysdba/[email protected] <<EOF

spool /home/oracle/Desktop/Unix_Sample_Files/Test2.txt

set linesize 32767

set pagesize 50000

select * from v$database;

spool off

exit

EOF

The error is

SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

   <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

User_H3J7U

Compare your sys as sysdba/[email protected] with usage:

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
   <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

Solomon Yakobson

Can you explain what are you trying to do using:

sqlplus -s sys as sysdba/[email protected]

Are you trying to connect as sysdba via user sys? If so use

sqlplus -s sys/[email protected] as sysdba

SY.

Chandhan S J

https://community.oracle.com/tech/developers/discussion/comment/16815941#Comment_16815941

This helped me out.