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:42:04 -0800
Message-ID: <1170268924.229073.11510@s48g2000cws.googlegroups.com>


On Jan 31, 11:00 am, "Ana C. Dent" <anaced..._at_hotmail.com> 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

Here you go:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\user>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 31 13:41:10 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: sys
Enter password:
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / Enter user-name: Received on Wed Jan 31 2007 - 12:42:04 CST

Original text of this message

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