Easiest way to get sys to work as Sysdba in OEM

Jeff C

unread,

Jul 5, 2003, 3:05:59 PM7/5/03

to

Is there a password list that I need to use? I can log into Sqlplus sys as
sysdba and do things at the command line but not in the OEM. ANY help is
greatly appreciated.

Sybrand Bakker

unread,

Jul 5, 2003, 4:04:13 PM7/5/03

to

On Sat, 05 Jul 2003 19:05:59 GMT, "Jeff C" <jco...@midsouth.rr.com>
wrote:

>Is there a password list that I need to use? I can log into Sqlplus sys as
>sysdba and do things at the command line but not in the OEM. ANY help is
>greatly appreciated.
>

No versions of course.

IIRC correctly to connect as SYSDBA you only need to click and
checkbox.
And then of course the init.ora remote_login_passwordfile parameter
must have been set to shared or exclusive.
Other than that: try to avoid 'Help it doesn't work' posts.
Crystall balls have sold out here and we don't keep track of everyones
configuration

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

B Fisher

unread,

Jul 5, 2003, 5:27:47 PM7/5/03

to

Not sure if this is your problem, but when you go into OEM and to the
instance, you will get the login - as you know.

Put in SYS, then the password, *then* be sure to pull down the third box (it
is gray/green but will pull down), and click on sysdba. Works fine for me.

scott fisher

"Jeff C" <jco...@midsouth.rr.com> wrote in message
news:rkFNa.80422$X43....@clmboh1-nws5.columbus.rr.com...

Jeff C

unread,

Jul 5, 2003, 8:37:54 PM7/5/03

to

This is an Oracle 9i install on HP/UX. I set the remote_login_passwordfile
to exclusive but it gave me an error about not having a password file. I
inherited this from our former DBA who really made a mess of things. Can you
tell me exactly what I need to make this work?

"B Fisher" <no...@antispamming.com> wrote in message
news:npHNa.76430$fe.16...@twister.rdc-kc.rr.com...

Sybrand Bakker

unread,

Jul 6, 2003, 4:42:53 AM7/6/03

to

On Sun, 06 Jul 2003 00:37:54 GMT, "Jeff C" <jco...@midsouth.rr.com>
wrote:

>This is an Oracle 9i install on HP/UX. I set the remote_login_passwordfile

>to exclusive but it gave me an error about not having a password file. I
>inherited this from our former DBA who really made a mess of things. Can you
>tell me exactly what I need to make this work?

If you get an error about not having a passwordfile: this requirement
exists for the 'exclusive' setting only.
If you need to create a password file (definitely a documented
procedure)
cd to $ORACLE_HOME/dbs
orapwd file=orapw${ORACLE_SID} password=<your password>
entries=<number of users you want to allow to have SYSDBA or SYSOPER
bounce the database
check out v$pwfile_users as to see which users have privilege,
internal and sys should show up.

Please reply in the newsgroup only unless asked to email. I might have
emailed only not checking the newsgroup.

Jeff C

unread,

Jul 6, 2003, 5:47:19 PM7/6/03

to

Thanks to all. There was a permissions problem set at the UNIX level that I
wasnt away of..
"Sybrand Bakker" <gooid...@nospam.demon.nl> wrote in message
news:11ofgvohjp4krtab3...@4ax.com...