Solved

Oracle Database SQLPLUS /

Posted on 2011-03-23
9
490 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
Comment Utility
0
 

Accepted Solution

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

Author Comment

by:mawingho
Comment Utility
does that user require an account in database too?
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
Comment Utility
>>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
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.

 

Author Comment

by:mawingho
Comment Utility
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 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
Comment Utility
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
Comment Utility
database groups? where can I see which user belong to the this group?
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
Comment Utility
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
Comment Utility
thanks
0

Featured Post

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.

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now