Restarting the Oracle eBusiness Suite Concurrent Manager
Run $FND_TOP/bin/startmgr.sh you will need the password for the apps account. To check it is running,...
ORA-27121: unable to determine size of shared memory segment
If when you are trying to login to Oracle 10G on linux you get : ORA-01034: ORACLE not...
Grid Control access to a Windows server
If you are trying to get Grid Control to access a Windows server and having trouble here’s a...
Managing Oracle RMAN backups
Every now and again something will go screwy with my automatic RMAN backups and I’ll to find any...
Show Oracle Database DBID
The database ID or DBID is a unique identification number computed when the database is created. To find out this...
Cross checking oracle ArchiveLogs using RMAN in Oracle 8 and 9
In Oracle 10g you can run the following command to crosscheck and expire any expired archive logs: RMAN>...
RMAN-06172: no autobackup found
While performing disaster recovery I get the error RMAN-06172 as below. RMAN> restore spfile to pfile ‘/oracle/app/oracle/product/10.2.0/db_1/dbs/initARJU.ora’ from...
How do you create Export/Import views
Run the “catexp.sql” as SYS. The file is located in $ORACLE_HOME/rdbms/admin. SQL> @?/rdbms/admin/catexp.sql
Moving an Oracle database to a newer Oracle home
Moving a database to a new oracle home, owned by a different user and running a newer version....
Changeing an Oracle database character set
Check what character set you are using at the moment. SQL> select value from v$nls_parameters where parameter='NLS_CHARACTERSET'; Shutdown...