Run $FND_TOP/bin/startmgr.sh you will need the password for the apps account. To check it is running, ps -ef | grep FNDLIBR via http://easyoracleapps.wordpress.com/2010/03/12/concurrent-managers/#more-99
If when you are trying to login to Oracle 10G on linux you get : ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux Error: 13: Permission denied This is caused by Oracle installer not setting setuid on $ORACLE_HOME/bin/oracle. To fix do: $ cd $ORACLE_HOME/bin $ chmod 6751 oracle via… Read More »
If you are trying to get Grid Control to access a Windows server and having trouble here’s a few things to check. Check that the host name credentials you are providing are the same as the user who install the database software on the Windows server. Check that the user is a member of the… Read More »
Every now and again something will go screwy with my automatic RMAN backups and I’ll to find any that are expired or obsolete and delete them manually.
The database ID or DBID is a unique identification number computed when the database is created. To find out this number, you can either: 1) Login to RMAN, it will display the DBID upon connection to the target database. e.g. shell> rman target / or 2) You can obtain the DBID by querying V$DATABASE eg. … Read More »
In Oracle 10g you can run the following command to crosscheck and expire any expired archive logs: RMAN> crosscheck archivelog all; RMAN> delete expired archivelog all; However in Oracle 8 and 9 you need to do the following Example for Oracle 8 use: RMAN> Change Archivelog All Validate; Example for Oracle 8i use: RMAN> change… Read More »
Run the “catexp.sql” as SYS. The file is located in $ORACLE_HOME/rdbms/admin. SQL> @?/rdbms/admin/catexp.sql
Moving a database to a new oracle home, owned by a different user and running a newer version. NOTE : This is how is worked in my environment. It might not work the same in your environment. This is meant as a guide only.
Check what character set you are using at the moment. SQL> select value from v$nls_parameters where parameter=’NLS_CHARACTERSET’; Shutdown the database. SQL> shutdown immediate; Startup in mount mode. SQL> startup mount; Restrict the database. SQL> alter system enable restricted session; Check the current job_queue_processes setting. SQL> show parameter job_queue_processes; Set it to 0 for now. SQL>… Read More »
Some files that you get from Oracle download come in cpio format. Here’s what to do with them. First unzip the files: gunzip lnx_920_disk1.cpio.gz gunzip lnx_920_disk2.cpio.gz gunzip lnx_920_disk3.cpio.gz Next unpack the contents of the files: cpio -idmv < lnx_920_disk1.cpio cpio -idmv < lnx_920_disk2.cpio cpio -idmv < lnx_920_disk3.cpio