| sys as sysdba [message #200722] |
Wed, 01 November 2006 01:39  |
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 #200996 is a reply to message #200795] |
Thu, 02 November 2006 03:27  |
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 #201166 is a reply to message #201159] |
Thu, 02 November 2006 17:59 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
