Sqlplus Login Box problem

[rommel]

Hi,

In Oracle 9i you can connect to sys as sysdba/sysoper only.
How will I connect to sys as sysdba using the sqlplus
login dialog box? where you have

User Name : ____________

Password : ____________

Host String : ____________

I tried putting "as sysdba" on either of the 3 fields but
I can not connect.

Please help.

[jmodic]

You must put it in host string field of your loging dialog box, after your actual Net service name.

Suppose your Net service name is "ORCL.acme.com", so you enter the following string into your host string field (without the double quotes);

"ORCL.acme.com as sysdba"

It works for me.

[soniaarora]

try : "sys as sysdba" as username(enclose in quotes).
What is the error u r getting?

[rommel]

Thanks Jmodic,

[rommel]

Hi,

Is there a way to override this sysdba requirement
for sys? Actually my problem is I have a 3rd-party
Apps and it uses a login dialog box similar to
sqlplus to connect to SYS during installation.
It has the ff. fields:

user: __________ maximo

passord : _________ maximo

database : _________ ora9 as sysdba


*error database is too large

[jmodic]

Originally posted by rommel
Is there a way to override this sysdba requirement
for sys?

No, not in 9i.