Showing posts with label startup. Show all posts
Showing posts with label startup. Show all posts

Monday, December 3, 2012

RMAN>STARTUP DBA - restrict database

How to startup a database in rman for restricted sessions. You would say conform SQLPLUS

SQLPLUS
SQL> startup restrict 
RMAN
RMAN> startup restrict 
It's not working, the word restrict generate an error inside RMAN.

Tuesday, January 18, 2011

Central TNSNAMES.ORA inside RAC using TNS_ADMIN [PRKP-1001 and CRS-0215 errors]

Is it possible to use a central tnsnames.ora on a shared file systems insite a Real Application Server. The answer to the question is YES. If the centralized tnsnames.ora is not correctly setup, it will produce the following errors [PRKP-1001 and CRS-0215 errors] at startup of the database or instance with SRVCTL. When using SQLPLUS to startup the database instance everything works as designed. Why SRVCTL is not working correctly is that, the TNS_ADMIN is not register into the Oracle Cluster Registry for the current database and instances.

The following steps in this blog will explain to you how you can solved the [PRKP-1001 and CRS-0215 errors] at startup of a database or instances by using SRVCTL statement with a centralized tnsnames.ora.