Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error Message (new to oracle)

Re: Error Message (new to oracle)

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 31 Jan 2007 19:57:35 GMT
Message-ID: <Pw6wh.15246$Y6.4022@edtnps89>


"tolcis" <nytollydba_at_gmail.com> wrote in message news:1170269019.383387.227330_at_q2g2000cwa.googlegroups.com...

> On Jan 31, 12:13 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> Ana C. Dent wrote:
>> > "tolcis" <nytolly..._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
>>
>> Or perhaps ... sqlplusw. ;-)
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
> When I type sqlplusw I get a screen to login as a user, type in
> password and input connection string.  That doesn't work for me
> either.
>
>

Create a shortcut to sqlplus/sqlplusw and add the /nolog parameter. Now when you login you just get a prompt, at which point you can enter: connect sys_at_dbname/pwd as sysdba
-- 
Terry Dykstra 
Received on Wed Jan 31 2007 - 13:57:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US