Archives

You are currently viewing archive for 12 August 2008
Category: Oracle
Posted by: hajime osako
Oracle

SYS owns the data dictionary
SYS has the SYSDBA privilege which SYSTEM doesn't

Note, SYSDBA is not a role, it is a privilege. You'll find it in system_privilege_map, not in dba_roles.
Category: Oracle
Posted by: hajime osako
Installing Oracle 9i on Windows 2000

Pretty straight forward.

Note the last one OracleServerORCL is the actual database process itself. OracleOraHome90TNSListener is the listener process for remote connections to the database. OracleOraHome90Agent is the Oracle Agent used to communicate with management services. Finally, the OracleOraHome90HTTPServer is the Oracle/Apache web server.