How to recreate the SYS.ALERT_QUE
The ALERT_QUE is used by the Grid Control and DB Control Management Agents to monitor server-generated alerts
The ALERT_QUE is used by the Grid Control and DB Control Management Agents to monitor server-generated alerts
Query dba_ts_quotas to see users' quota per tablespace
After an instance failure or SHUTDOWN ABORT, you can`t start your database. At startup you`ll get this messages:
Here is a procedure to move PSAPTEMP temporary tablespace. It's for windows, but you can translate for Unix.
Oracle 10g: How to create a log file if lost?
Security: how to lock or unlock Oracle database user accounts
Need to become a different Oracle database user? There is a way to login into a another user's account without knowing their password:
Run this from sqlplus to force Oracle user choose a new password when he/she logs in next time:
This is a quick reference for SAP brspace utility.
Archive log in Oracle give me the ORA-16032 error?
Dropping database from sqlplus
You can run 2 Oracle instances with the same database name. To do that set the following parameter(s):