RE: Forms - as sysdba

[Suhen Pather]

Title: Message

Robo

 

You can connect as

 

ifrun60.EXE "C:\...\..\logon2.fmx"

 

Regards

Suhen

-----Original Message-----
From: Robo [mailto:[EMAIL PROTECTED]
Sent: Friday, 22 August 2003 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Forms - as sysdba

I MUST connect as sys, because it's a part of an upgrade of our system.

I will try to find some kind of patch for this situation as Jared suggested.

 

Anyway, it should be possible to connect from command line, shouldn't it? Something like:

c:\orant\bin\ifrun60.exe C:\dev\form.fmx "sys/[EMAIL PROTECTED] "\/'as sysdba'"

 

=RP=

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hemant K Chitale
Sent: Thursday, August 21, 2003 5:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Forms - as sysdba

Rather, why do you want to connect as SYS ?
If you've created some custom tables in the SYS schema in an earlier version,
create another user, connect as SYS in sqlplus, GRANT privileges to that user
and connect as that new user in Forms. -- and think about migrating the tables
out of the SYS schema.

If you are querying standard tables, OEM provides good views for most of what
you need and the group here can provide better SQL scripts anyway.

Hemant
At 07:29 AM 21-08-03 -0800, you wrote:

Try if it works if you put sys/sys as sysdba to forms username prompt? (without quotes)
But why do you want to connect as sysdba anyway?
 
Tanel.
 

----- Original Message -----

From: Robo

To: Multiple recipients of list ORACLE-L

Sent: Thursday, August 21, 2003 11:54 AM

Subject: Forms - as sysdba

Hi all,

I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database.

I tried a lot of combinations, eg:

Username: sys as sysdba

Password: sys

Database: db

sys/[EMAIL PROTECTED] as sysdba

sys/[EMAIL PROTECTED] /as sysdba

sys/[EMAIL PROTECTED] 'as sysdba'

sys/[EMAIL PROTECTED] '/as sysdba'

But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string).

I have also tried it from command line but didn't succeed.

Does anyone know if/how is it possible?

Thanks a lot

Robert Pipich

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

----------
* www.inMail.sk - Vasa emailova adresa na cely zivot ZDARMA
* Mail neobsahuje virusy. Zkontrolovane antivirusom NOD32 (www.eset.sk)
* www.SlovakNET.sk - profesionalny webhosting, domena .SK ZADARMO
* Zoner Media Explorer 5 - stiahnite si pomocnika pre digitalnu fotografiu (zme.zoner.sk)