08/12: oracle sys system difference
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.
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.
08/12: Install Oracle 9i on Windows
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.
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.
Sidebar
