Re: isqlplus 10g

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 12 Dec 2007 09:12:45 GMT
Message-ID: <1197450759.204941@proxy.dienste.wien.at>

disco master <harish.pond_at_gmail.com> wrote:

> On Dec 11, 9:17 pm, Laurenz Albe <inv..._at_spam.to.invalid> wrote:

>> disco master <harish.p..._at_gmail.com> wrote:
>> > i am unable to connect to isqlplus
>>
>> > when i entered
>> > usr sys as sysdba
>> > pwd ****
>> > conn identifer : db3 ( database name)
>>
>> > its throwing error as
>> > SP2-0306 - Invalid option. Usage: CONN[ECT] username/
>> > password[@connect_identifier] [AS {SYSOPER|SYSDBA}] or: CONN[ECT] /
>> > [@connect_identifier] AS {SYSOPER|SYSDBA
>>
>> You have to enable DBA access:
>>
>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.ht...
>>
>> and use the URL with "/dba" appended.
>>
>> Yours,
>> Laurenz Albe

> 
> CAn you tell me what are the actual commands to
> create users and grant webdba role to those users
> and access isqlplus

Sorry, no. I am willing to show you the way, but I am not willing to think and type for you.

Yours,
Laurenz Albe Received on Wed Dec 12 2007 - 03:12:45 CST