Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question about SLOB and slob.conf

GravyKingMay 17 2018 — edited May 18 2018

I don't know if this is something I should ask on here or on kevinclossons site but I figure here I have access to lots of people who will have used SLOB versus trying to get Kevin to see my question and respond.  So pretty basic question on setting up slob here.

RedHat Linux server with a 12c database.  I am connecting as oracle and it works if I edit the slob.conf file to use my 'system password' but I don't really like having that password siting in a file or displaying it everytime I run setup.sh or runit.sh.

So for the life of me I can't figure out how to change it from using the system account so I can just connect as '/ as sysdba'.

I see mention of DBA_PRIV_USER=<master account> when testing Amazon RDS for Oracle which doesn't seem to really apply.

Can I do what I want or do most people just update slob.conf with the system password or do they create an account just for slob testing?

Edit:  [I did find this example online which is what I hope to achieve and tried the values shown but I still get sqlplus -L system/manager]

NOTIFY: Load Parameters (slob.conf):

LOAD_PARALLEL_DEGREE == 8
SCALE == 10000
ADMIN_SQLNET_SERVICE == ""
CONNECT_STRING == "/ as sysdba"
NON_ADMIN_CONNECT_STRING ==

NOTIFY: Testing connectivity to the instance to validate slob.conf settings.
NOTIFY: ./setup.sh: Successful test connection: "sqlplus -L / as sysdba"

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2018
Added on May 17 2018
3 comments
751 views