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: tolcis <nytollydba_at_gmail.com>
Date: 31 Jan 2007 10:43:39 -0800
Message-ID: <1170269019.383387.227330@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. Received on Wed Jan 31 2007 - 12:43:39 CST

Original text of this message

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