Oracle-L: RE: Forms

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 21 Aug 2003 23:04:30 -0800
Message-ID: <F001.005CC160.20030821230430@fatcity.com>

I don't have 9i to test, but I believe you might be able to set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect as sys without specifying sysdba.

This might be suitable for the upgrade - certainly test it out on a test system first.

Regarding the upgrade - why exactly does it need to be connected as sys - eg what doesn't work if you connect as system.

HTH,
Bruce Reardon

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

Sent: Friday, 22 August 2003 4:49 PM

Robo

You can connect as

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

Regards
Suhen
-----Original Message-----

Sent: Friday, 22 August 2003 4:39 PM

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/sys_at_db "\/'as sysdba'"

=RP=

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

Sent: Thursday, August 21, 2003 5:54 PM

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 ----- To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM

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/sys_at_db as sysdba 
sys/sys_at_db /as sysdba

sys/sys_at_db 'as sysdba'
sys/sys_at_db '/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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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: ListGuru_at_fatcity.com (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).

Received on Fri Aug 22 2003 - 02:04:30 CDT

RE: Forms - as sysdba