User and Schema

Who has SYSDBA privilege?

Posted on
SYSDBA is a system privilege. By default, only SYS has the privilege, but it can be changed by granting to other user. Although it’s a system privilege, and very special, you will hardly find any other user has SYSDBA privilege by looking up dictionary view, so we also call it administrative privilege. Similarly, SYSOPER is […]
PFILE and SPFILE

How to Resolve SPFILE Does Not Work

Posted on
You might notice that the newly created SPFILE for a RAC database was not taking effective after restarts. I think you might create the SPFILE in the wrong places.Oracle 11g RAC stores all the shared files in ASM, including control files, spfile, data files. Thus, it starts all the instances with the shared SPFILE. If […]
Listener

How to Remotely Connect a NOMOUNT Database

Posted on
Users who belong to OSDBA or OSOPER can access a database in any states on local host if OS authentication is ON in the listener. It’s probably not a problem on local, but remote or external access would be an issue to connect to the database. Normally, you cannot connect to a nomount state database […]
RMAN

How to Pass Date Format into RMAN

Posted on
After you set RMAN log location (2 Ways to Set RMAN Log Location), the next problem you will meet is the format of timestamp in the log, which could be too coarse to judge the actual time like this:08-OCT-12If you are using sqlplus, you can alter the session and set NLS_DATE_FORMAT to modify the format, […]
RMAN

2 Ways to Set RMAN Log Location

Posted on
RMAN is a client side utility like sqlplus used to interoperate with DB, we usually compose a script file or a batch file to run via cron job or schedule. If any problems result from RMAN, you can check the log file to debug.There is no RMAN default log location in PFILE to set, so you […]
RMAN

When RMAN met Resource Manager

Posted on
Users notified DBA that they found AP responded longer than normal starting from 22:00 everyday, especially when a period of running RMAN on the host, we checked STATPACK report to search the root cause, RMAN was running fine, but there was a wait event utilizing too much resources, see the report summarized below:…Top 5 Timed […]
Archivelog Mode

How to Enable ARCHIVELOG Mode in Oracle 9i

Posted on
In this post, I will show you how to enable archivelog mode in 9i. For those who are using Oracle 10g onwards, you may take a look at my post for more: How to Enable Archivelog Mode in Oracle Create archive log destination directory and enter sqlplus [oracle@test ~]$ mkdir -p /u01/app/oracle/product/9.2.0/archivelog/oracle9i/ [oracle@test ~]$ sqlplus […]
Archivelog Mode

How to Enable ARCHIVELOG Mode in Oracle

Posted on
The process of copying inactive redo log files into archived files is called archiving. Archiving is only possible if the database is running in ARCHIVELOG mode. It makes databases keep transaction history much longer than finite redo logs. Which means that you can have larger recovery point objective (RPO) than usual whenever data lost, database […]