How to Grant All Tables Owned by Others
Grant All Tables at Object Level Sometimes, you may want a user who can select all the tables from the other user's. But the question… Read More »How to Grant All Tables Owned by Others
How to Resolve ORA-3136 Inbound Connection Timed Out
ORA-3136 At times, some users complained about connection timeout, and you saw error messages ORA-3136 in sqlnet.log as such: Fatal NI connect error 12170. … Read More »How to Resolve ORA-3136 Inbound Connection Timed Out
Why SPFILE Does Not Work in RAC
Shared SPFILE You might have noticed that the newly created SPFILE for a RAC database was not taking effective after restarts. And I think you… Read More »Why SPFILE Does Not Work in RAC
How to Connect Idle, Nomount or Restricted Database Remotely
Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »How to Connect Idle, Nomount or Restricted Database Remotely
How to Set NLS_DATE_FORMAT in RMAN
After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log, which was too… Read More »How to Set NLS_DATE_FORMAT in RMAN
3 Ways to Set RMAN Log Location
RMAN Log Location RMAN is a client side utility like sqlplus used to interoperate with DB, we usually compose a script file or a batch… Read More »3 Ways to Set RMAN Log Location
When RMAN met Resource Manager
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,… Read More »When RMAN met Resource Manager
How to Enable ARCHIVELOG Mode in Oracle 9i
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… Read More »How to Enable ARCHIVELOG Mode in Oracle 9i
How to Set Password for Listener
Earlier databases like 9i should set password for listeners, otherwise, they could be accidentally stopped by someone unknown. Here in this post, I will introduce… Read More »How to Set Password for Listener
How to Enable ARCHIVELOG Mode in Oracle
For 9i database or below, please refer to: How to Enable ARCHIVELOG Mode in Oracle 9i What is Archiving? The process of copying inactive redo… Read More »How to Enable ARCHIVELOG Mode in Oracle