Home » Developer & Programmer » Forms » sys as sysdba
sys as sysdba [message #200722] Wed, 01 November 2006 01:39 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
i am quite new to form builder
can we connect as sysdba in Forms?
how can we do that?
can anybody help me in this regard?
can u please look at the attached file and hence i can express what i want consult with
thanx in advance
Re: sys as sysdba [message #200795 is a reply to message #200722] Wed, 01 November 2006 06:33 Go to previous messageGo to next message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Hi,

By default
~~~~~~~
There exists an init.ora parameter O7_DICTIONARY_ACCESSIBILITY = FALSE which
forces the user SYS to connect as SYSDBA or SYSOPER.

To fix the problem follow this step
~~~~~~~~~~~~~~~~~~~~~~
Shutdown the database, set O7_DICTIONARY_ACCESSIBILITY = TRUE in the init.ora
and then startup the database.



Bhujendra

Re: sys as sysdba [message #200996 is a reply to message #200795] Thu, 02 November 2006 03:27 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
kbhujendra@rediffmail.com wrote on Wed, 01 November 2006 06:33
Hi,

By default
~~~~~~~
There exists an init.ora parameter O7_DICTIONARY_ACCESSIBILITY = FALSE which
forces the user SYS to connect as SYSDBA or SYSOPER.

To fix the problem follow this step
~~~~~~~~~~~~~~~~~~~~~~
Shutdown the database, set O7_DICTIONARY_ACCESSIBILITY = TRUE in the init.ora
and then startup the database.



Bhujendra





O7_DICTIONARY_ACCESSIBILITY = TRUE is set already
Perhaps i had not expressed my query clearly
My query was i want to connect sys as sysdba from forms builder
Is it possible then what should be done to perform this task
connection sys as sysdba from forms builder
I hope it would be understandable
if it is then plzzzzz help me in this regard
thanx in advance

Re: sys as sysdba [message #201159 is a reply to message #200996] Thu, 02 November 2006 17:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What version of the database are you using?

David
Re: sys as sysdba [message #201166 is a reply to message #201159] Thu, 02 November 2006 17:59 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
From the online documentation for 'Connect':
Connect displays the Connect dialog, where you can specify username, password, and the database to which you want to connect. You can type in each field separately or you can type the following all on one line:

username/password@database

You can also type everything except the password in the Username field as follows:

username@database

Then you can type the password in the Password field, so that it is not displayed.

Use 'sys "/as sysdba"@database' (drop the quotes) in the 'User Name' field and 'password' in the 'Password' field.

Upd: This may not work. I have problems with my test Oracle box and will update this post again as soon as it is online again.

David

[Updated on: Thu, 02 November 2006 18:14]

Report message to a moderator

Previous Topic: tool_env.getvar and default.env
Next Topic: please help me for a oracle forms beginner
Goto Forum:
  


Current Time: Thu Dec 08 14:38:52 CST 2016

Total time taken to generate the page: 0.21558 seconds