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 100+ times

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 we 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/