As per oracle technology ...
SYS
When you create an Oracle Database, the user SYS is automatically created and granted the DBA role.
All of the base tables and views for the database data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. They should never be modified by any user or database administrator, and no one should create any tables in the schema of user SYS. (However, you can change the storage parameters of the data dictionary settings if necessary.)
Ensure that most database users are never able to connect to Oracle Database using the SYS account.
I want to confirm this whether before oracle DB created does SYS user exist?
I have installed oracle software without starter DB, then created the password file and the init parameter file. At this stage no DB, data dictionary, no control file exists but still I can connect sqlplus sys/pwd as sysdba and start the instance in nomount mode. so my question is from where I am gettig sys user name before DB is created? where this info is stored other than dictionary?
Rgds
Edited by: Suman... on May 16, 2011 6:26 AM