Easiest way to get sys to work as Sysdba in OEM

[Jeff C]

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]

On Sat, 05 Jul 2003 19:05:59 GMT, "Jeff C" <jcondon@midsouth.rr.com>
wrote:
Is there a password list that I need to use? I can log into Sqlplus sys assysdba and do things at the command line but not in the OEM. ANY help isgreatly 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

[Jeff C]

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" <none@antispamming.com> wrote in message
news:npHNa.76430$fe.1686923@twister.rdc-kc.rr.com... 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" <jcondon@midsouth.rr.com> wrote in message news:rkFNa.80422$X43.30045@clmboh1-nws5.columbus.rr.com... 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.

[Jeff C]

Thanks to all. There was a permissions problem set at the UNIX level that I
wasnt away of..
"Sybrand Bakker" <gooiditweg@nospam.demon.nl> wrote in message
news:11ofgvohjp4krtab3821mq1n3be5tfgr23@4ax.com... On Sun, 06 Jul 2003 00:37:54 GMT, "Jeff C" <jcondon@midsouth.rr.com> wrote:This is an Oracle 9i install on HP/UX. I set the
remote_login_passwordfileto exclusive but it gave me an error about not having a password file. Iinherited this from our former DBA who really made a mess of things. Can
youtell 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. Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address