- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- using ops$ as oracle database account.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-16-2004 01:47 PM
тАО08-16-2004 01:47 PM
using ops$ as oracle database account.
Im using hp-ux11i and oracle 9i Rel2 database
I have a user "ops$ods_admin" when i try to issue a command
$ sqlplus ops$ods_admin/password
it is saying that parameter not set....
how can i proceed further... this i am using for my OS authentication in scripts....
Please help me its very urgent...
--ram
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-16-2004 04:26 PM
тАО08-16-2004 04:26 PM
Re: using ops$ as oracle database account.
OPS$ accounts are a way to use operating-system userids as the basis for ORACLE usernames. Instead of users being authenticated by Oracle, users are authenticated by the operating system.
Once the OPS$ accounts have been created, you will have to define the OS_AUTHENT_PREFIX parameter in the init.ora to define the prefix used in the Oracle usernames:
OS_AUTHENT_PREFIX=OPS$
The default value of this parameter is "OPS$" for backward compatibility with previous versions of Oracle where the prefix had to be "OPS$".
Set the REMOTE_OS_AUTHENT parameter to TRUE in the init.ora:
REMOTE_OS_AUTHENT=TRUE
Invoke any ORACLE tool and use a '/' to indicate OPS$ accounts will be used. For example, if you type:
sqlplus /
I Hope this helps.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-16-2004 05:36 PM
тАО08-16-2004 05:36 PM
Re: using ops$ as oracle database account.
Thnx for ur response but it seems it is not working... those two parameters are already in init.ora file... but still the same....
is there any thing do i need to set in unix side....
thnx in advance.
--ram
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-16-2004 05:56 PM
тАО08-16-2004 05:56 PM
Re: using ops$ as oracle database account.
$ods_admin is an environment variable for the shell. If you use bourne shell and have -u acivated, then it complains about $ods_admin not set.
try sqlplus ops\$ods_admin/password
hth,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-16-2004 07:21 PM
тАО08-16-2004 07:21 PM
Re: using ops$ as oracle database account.
Thnx for ur valuable information.
Where as i have old unix box there i use to login as "csh" and issue command says
$ORACLE_HOME/bin/sqlplus /@ods
In my new unix box I have created a user which uses csh and try to issue the same command which says invalid userid and password.
do i need to set anything else in csh....?
thnx in advance
--ram
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-16-2004 11:32 PM
тАО08-16-2004 11:32 PM
Re: using ops$ as oracle database account.
you want to login as ods_admin, right?
Try sqlplus "ods_admin@ods"
hth,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2004 12:23 AM
тАО08-17-2004 12:23 AM
Re: using ops$ as oracle database account.
can you please post the output of:
echo $LOGNAME
The output must be: ODS_ADMIN for it to work as you wish.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2004 01:17 PM
тАО08-17-2004 01:17 PM
Re: using ops$ as oracle database account.
I would like to connect to oracle by issuing statement as
sqlplus /@ods9i
Hi Yogeeraj,
When I issue $LOGNAME the result is "oracle", how can I change this to ods_admin.. please let me know.
thnx
--ram
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2004 02:58 PM
тАО08-17-2004 02:58 PM
Re: using ops$ as oracle database account.
To use external authentication, you just want to issue it as:
sqlplus /
However, setting REMOTE_OS_AUTHENT will open up a large security hole in your database. Anyone with a username of 'ods_admin' (or any OS authenticated user) would be able to access your user from any machine that they configured a TNS entry to connect to your database.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2004 03:32 PM
тАО08-17-2004 03:32 PM
Re: using ops$ as oracle database account.
you should create an user ("ods_admin") at the OS level and modify the profile so that it matches that of the "oracle" user.
then it will work.
best regards
Yogeeraj