I've been handed our production Oracle 11g R2 database server and told to manage it by management. Obviously having a seasoned / qualified DBA isn't in the budget this year and it gives me the oppertunity to learn SQL & Oracle 11g.
This being said, I've noticed when I attempt to connect to my target instance (SID = ide) as SYS, there's no request to enter the SYS password. I'm basically dumped straight into the database with SYS privleges.
[oracle@db1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 11 11:43:02 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
As you can see I was logged into Linux as the 'oracle' OS user and was never prompted for any passwords. I was wondering if this is normal in Oracle database world or frowned upon and recommended I change this some how. Can you guys please explain? I've not used Oracle at all before so I have no idea if this is good but seems bad to me from a security stand point. Scared I will break 11g if I adjust this also.
Thanks for any clarification!