"tolcis" <nytollydba_at_gmail.com> wrote in news:1170257275.341375.311690
@v45g2000cwv.googlegroups.com:
> On Jan 31, 9:42 am, "gazzag" <gar..._at_jamms.org> wrote:
>> On 31 Jan, 14:33, "tolcis" <nytolly..._at_gmail.com> wrote:
>>
>>
>>
>> > Hi!
>>
>> > I am new to oracle so this question might sounds easy. When I
>> > installed oracle I set up passwords for SYS and SYSTEM accounts.
When
>> > I start sqlplus from command line and try to log in using SYS it
gives
>> > me the error messages:
>> > SP2-0306: Invalid option.
>> > Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
>> > where <logon> ::= <username>[/<password>][@<connect_identifier>] |
/
>> > Enter user-name:
>>
>> > I can however use sys account to log in to database management
page.
>> > Also, when I click on iSQLPlus connection from the database
management
>> > page I am not able to log in using SYS or SYSTEM account.
>>
>> > Any ideas?
>>
>> > Thank you,
>> > Ton.
>>
>> Could you please post a Copy & Paste of the session from where you
>> first start SQL*Plus?
>>
>> -g
>
> Not sure what you mean. It is a windows machine. I click on Start,
> Run, type sqlplus and it gets me to a command prompt.
>
instead of typing "sqplus" type "cmd"
which opens a command window.
from there type "sqlplus"
Now you'll be able to cut & paste the whole interaction
Received on Wed Jan 31 2007 - 10:00:10 CST
