Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Andre.

Asked: June 26, 2001 - 4:07 pm UTC

Last updated: March 02, 2021 - 1:49 am UTC

Version: 816

Viewed 10K+ times! This question is

You Asked

Hi.
When i do

sqlplus system

and dont type a password, this happen:

SQL*Plus: Release 8.0.6.0.0 - Production on Thu Jun 21 14:13:37 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-01005: null password given; logon denied


Enter user-name:

Connected to:
Oracle8 Enterprise Edition Release 8.0.6.2.0 - Production
PL/SQL Release 8.0.6.2.0 - Production

SQL> show user
USER is "OPS$ORACLE"
SQL>



What is it USER "OPS$ORACLE" ? What that user can do in his session ?
Oracle Parallel Server user? But why oracle dont prompt to put a password ?

[],
André.


and Tom said...

OPS$ stands for OPerating System identified user.

You are logged into the OS as oracle.

Do this:

$ sqlplus /

you'll be right in. Someone created a user ops$oracle identified externally and granted them connect (or create session, whatever).

Its just a normal user, it doesn't have to supply a password as Oracle trusts the OS to supply the username.

I use it for scripts run by cron all of the time - don't have to put passwords into files.



followup to comment 3 below
See
</code> http://docs.oracle.com/cd/A81042_01/DOC/nt.816/a73008/ch7.htm#1036322 <code>
for how to set this up on windows.


Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Need Help

Govind, June 27, 2001 - 6:41 am UTC

I need your help. I am able to find any provision made to ask questions on the page </code> http://asktom.oracle.com/pls/ask/ <code>
Please help me to post question to your desk. I am having lot of questions to ask. My email id is wegov@yahoo.com. Please give guidance and link to post question(exactly).

thanking you
Govind

Need Help

Govind, June 27, 2001 - 6:42 am UTC

I need your help. I am not able to find any provision made to ask questions on the page </code> http://asktom.oracle.com/pls/ask/ <code>
Please help me to post question to your desk. I am having lot of questions to ask. My email id is wegov@yahoo.com. Please give guidance and link to post question(exactly).

thanking you
Govind

Gururaj Kulkarni, June 28, 2001 - 10:21 am UTC

Hi Tom ,

I tried creating OS user. Could you tell me why it didn't
work and how can make that work.

1)create user guru identified externally;

2)grant connect,resource to guru


3)c:\>sqlplus /

ERROR ORA-01004 default username feature not supported :
logon denied

Enter user-name : guru
Enter password :
ERROR ORA-01017: invalid username/password ; logon denied

The following is banner from v$version


BANNER
----------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production



Is this out of date?

Charlie B., March 01, 2021 - 5:22 pm UTC

Part of Oracle's response to a recent TAR was the comment that we should stop using OPS$ORACLE for exports, since it "is not supported and do use SYSTEM or the DP User."

I'm working through the 12.2 documentation and don't see anything about OPS$ORACLE being deprecated. I first learned about it from AskTom, so I'm Asking Tom: what's up? I'm having trouble finding anything in the 12.2 docs about deprecating OPS$ accounts

We don't have a *nix based password manager, so we can't hide a password for our cron-scheduled, shell-scripted exports on the server. OPS$ORACLE has always been a great way to run exports.

If we have to stop using OPS$ORACLE, can you suggest a link to setting up a separate "DP user" which can do expdp but can't do anything else?
Connor McDonald
March 02, 2021 - 1:49 am UTC

It is more that with the pluggable database concept, ops$ accounts will probably have some issues when you start wanting to connect directly to a pluggable via a service.

For me, the way I choose to hide passwords is via a wallet, eg here

https://connor-mcdonald.com/2015/09/21/connection-shortcuts-with-a-wallet/
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.