ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089

Temporary Tablespace and Datafile Management in Oracle database 1.  For Finding temp file and temp tablespace with size SELECT file#,         status,         bytes / 1024 / 1024 “Size_MB”,         name  FROM   v$tempfile;  SELECT file_name,         tablespace_name,         bytes / 1024 / 1024 / 1024,         status  FROM   dba_temp_files;  2. Add …

A Brief Introduction to ADPatch AutoPatch (adpatch) “AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database.”   Modes Of adpatch There …

How to Check Version of Apache in Oracle Apps? Step 1. Goto Oracle Application Home  $ cd $IAS_ORACLE_HOME/Apache/Apache/bin/ $ pwd /apps/ebs/apps/tech_st/10.1.3/Apache/Apache/bin Step 2. Write httpd -v to fetch the Version …

How To Find Oracle Database 32 bit or 64 bit Finding Oracle Database Version on your system through Operating System $ cd $ORACLE_HOME $ cd bin $ file oracle oracle:         …

Change Date and Time Formats In Oracle Database? Option 1. If We want to change this format to DD/MONTH/YYYY format. SQL> alter session set nls_date_format=’DD/MONTH/YYYY’; Session altered. SQL> select sysdate …

Application Names in Oracle E-Business Suite R12   Application ID Application Name Application Short Name Basepath 1 0 Application Object Library FND FND_TOP 2 1 System Administration SYSADMIN FND_TOP 3 …

How to find the Oracle E-Business Suite R12 application URL? $ sqlplus apps/appsdrdg SQL*Plus: Release 10.2.0.4.0 – Production on Fri Oct 20 16:55:32 2017 Copyright (c) 1982, 2007, Oracle. All …

Difference between P-File and SP-File? P-FILE SP-FILE It is called as parameter file. It is called as server parameter file. P-File is ASCII file and it can be edited Manually spfile is binary file and it …

How to rename a Datafile with Extension .dbf? For example we have  added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …