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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 31 Jan 2007 09:13:49 -0800
Message-ID: <1170263624.637001@bubbleator.drizzle.com>


Ana C. Dent wrote:

> "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

Or perhaps ... sqlplusw. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jan 31 2007 - 11:13:49 CST

Original text of this message

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