Chapter 1 – Overview of Administering an Oracle Database
Posted by Kamran Agayev A. on November 17th, 2009
– Check your current release number as follows
SQL> COL PRODUCT FORMAT A35
SQL> COL VERSION FORMAT A15
SQL> COL STATUS FORMAT A15
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT VERSION STATUS
———————————– ————— —————
NLSRTL 10.2.0.1.0 Production
Oracle Database 10g Enterprise Edit 10.2.0.1.0 Production
PL/SQL 10.2.0.1.0 Production
TNS for Linux: 10.2.0.1.0 Production
– Create at least one additional administrative user and grant to that user an appropriate administrative role to use when performing daily administrative tasks. Do not use SYS and SYSTEM for these purposes.
– When you create an Oracle Database, the users SYS and SYSTEM are automatically created and granted the DBA role
– No one should create any tables in the schemas of users SYS and SYSTEM
– A predefined DBA role is automatically created with every Oracle Database installation
– When you connect with SYSDBA or SYSOPER privileges, you connect with a default schema, not with the schema that is generally associated with your username. For SYSDBA this schema is SYS, for SYSOPER the schema is PUBLIC
– If you issue the ALTER USER statement to change the password for SYS after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated. You can’t change the password for SYS if REMOTE_LOGIN_PASSWORDFILE is set to SHARED. An error message is issued if you attempt to do so
– Use the V$PWFILE_USERS view to see the users who have been granted SYSDBA or SYSOPER system privileges for a database
November 17th, 2009 at 3:51 pm
Excellence Article 😉
Helpful to test, i never…
Example:
– REMOTE_LOGIN_PASSWORDFILE=SHARED
change sys password – ORA-28046: Password change for SYS disallowed
Thank You
April 26th, 2012 at 6:22 am
Hi Kamran,
This article is perfect and very useful.