Solved

Oracle Database SQLPLUS /

Posted on 2011-03-23
9
503 Views
Last Modified: 2012-05-11
I see my client use SQLPLUS /
to login to DB,
then what account will they use after login to Oracle, is it SYS??
anyone can help?
0
Comment
Question by:mawingho
9 Comments
 
LVL 16

Expert Comment

by:Peter Kwan
ID: 35196404
0
 

Accepted Solution

by:
ehabib earned 125 total points
ID: 35196497
The '/' tells sqlplus to rely on hosting O/S authentication.
0
 

Author Comment

by:mawingho
ID: 35197778
does that user require an account in database too?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 35197853
>>does that user require an account in database too?

Yes. ehabib is correct.  This is OS authentication unless you specify 'as sysdba'.  If you use 'as sysdba' then you are SYS.

Depending on the version of Oracle you are using, you set a configuration parameter.

Check out:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/initparams172.htm#REFRN10152
0
 

Author Comment

by:mawingho
ID: 35212753
If I use an OS account to install Oracle
then I can use sqlplus / as sysdba
to login as SYS
however, how does Oracle know oracle is the one who install itself?
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 35214664
You are really asking two different things here.

connect /
and
connect / as sysdba

These are two completely different things and are handled completely differently.

The first one uses OS authentication and connects as just another database user.  The second ALWAYS connects as SYS.

>>how does Oracle know oracle is the one who install itself?

It really doesn't.

As soon as the database sees you try to use 'as sysdba', it doesn't even look at the username or password.

Check it out (assuming you don't have a database user names fred):  
connect fred/flintstone as sysdba


As soon as Oracle sees 'as sysdba' it checks the password file and database groups to see if your OS user is 'allowed' to connect as SYS.  If so, you are connected.  The username and password provided do not matter.
0
 

Author Comment

by:mawingho
ID: 35216264
database groups? where can I see which user belong to the this group?
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 35217845
The OS group.  In UNIX it comes from the /etc/group file.  In Windows you can get it from the User Management section in control Panel (and a few other places).

In UNIX it is the dba group.  Windows: ORA_DBA
0
 

Author Closing Comment

by:mawingho
ID: 35305474
thanks
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question