?
Solved

Help with Oracle Enterprise Manager backup...getting "Could not fork or create job process." error.

Posted on 2004-04-08
22
Medium Priority
?
2,070 Views
Last Modified: 2013-12-03
I am attempting to create a backup job and it keeps failing.

I have tried rebooting the machine, etc. and nothing helps.

The only error I get in the "View Output" window is "Could not fork or create job process."

I am running Personal Oracle9i Release 9.2.0.1.0 - Production.

Thanks.
0
Comment
Question by:ThomasBell
  • 7
  • 5
  • 3
  • +5
20 Comments
 
LVL 8

Expert Comment

by:Danielzt
ID: 10786532
if you are on unix, refer to this:

fix:
Reset/configure the kernel to increase the maximum number of processes
available to each user. This can be done on AIX base systems by doing the
following:

1. Run smit
2. Select Change/Show characteristics of Operating System.
3  Select maximum number of processes allowed per user.
0
 

Author Comment

by:ThomasBell
ID: 10786554
I should have explained that I am using Windows XP Pro...sorry for omitting that.
0
 
LVL 3

Expert Comment

by:dbms_chu
ID: 10787455
Are there any additional messages in dbsnmp*.log?

Do you have other jobs that run successfully?

Can you connect using dbsnmp?  sqlplus dbsnmp/dbsnmp@sid
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:ThomasBell
ID: 10789221
This is the only job type that I have attempted to run so the answer to your question about other jobs being successful is no.

I have attempted to run a backup at least 10 times, all failing with this error.

Yes, I can connect using "sqlplus dbsnmp/dbsnmp@develop" with no errors.

You asked, "Are there any additional messages in dbsnmp*.log?"

Here is the output today from the DBSNMP.LOG file:

-- xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

DBSNMP for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-APR-2004 11:57:18

Copyright (c) 2002 Oracle Corporation.  All rights reserved.

System parameter file is C:\Oracle\Ora81\network\admin\snmp_ro.ora
Log messages written to C:\Oracle\Ora81\network\log\dbsnmp.log
Trace information written to C:\Oracle\Ora81\network\trace\dbsnmp_1452.trc
Trace level is currently 0

NMS-00001: Warning: dbsnmp unable to connect to SNMP master agent
08-APR-2004 14:10:39: NMS-00908: Shutting down normally

DBSNMP for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-APR-2004 14:16:45

Copyright (c) 2002 Oracle Corporation.  All rights reserved.

System parameter file is C:\Oracle\Ora81\network\admin\snmp_ro.ora
Log messages written to C:\Oracle\Ora81\network\log\dbsnmp.log
Trace information written to C:\Oracle\Ora81\network\trace\dbsnmp_4992.trc
Trace level is currently 0

NMS-00001: Warning: dbsnmp unable to connect to SNMP master agent

DBSNMP for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-APR-2004 14:30:55

Copyright (c) 2002 Oracle Corporation.  All rights reserved.

System parameter file is C:\Oracle\Ora81\network\admin\snmp_ro.ora
Log messages written to C:\Oracle\Ora81\network\log\dbsnmp.log
Trace information written to C:\Oracle\Ora81\network\trace\dbsnmp_1768.trc
Trace level is currently 0

NMS-00001: Warning: dbsnmp unable to connect to SNMP master agent

-- xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

0
 
LVL 48

Expert Comment

by:schwertner
ID: 10789634
What kind of Backups are you trying to do?
If you do not use Archivelog mod the only kind of backup is FULL COLD Backup which also means that you have to shutdown the Oracle Instance.
Be aware that Personel Oracle (even Standart Edition of Oracle) comes with restricted functionality. So if you would like to do complex DBA tasks you have to use Enterprise Edition of Oracle.
0
 
LVL 2

Expert Comment

by:GDE
ID: 10789676
DESTROY
Default: N

Specifies whether or not the existing data files making up the database should be reused. That is, specifying DESTROY=Y causes Import to include the REUSE option in the datafile clause of the CREATE TABLESPACE command, which causes Import to reuse the original database's data files after deleting their contents.

Note that the export file contains the data file names used in each tablespace. If you specify DESTROY=Y and attempt to create a second database on the same machine (for testing or other purposes), the Import utility will overwrite the first database's data files when it creates the tablespace. In this situation you should use the default, DESTROY=N, so that an error occurs if the data files already exist when the tablespace is created. Also, when you need to import into the original database, you will need to specify IGNORE=Y to add to the existing data files without replacing them.

Caution: If data files are stored on a raw device, DESTROY=N does not prevent files from being overwritten.

Interesting.... I`m testing this for you. ;)
0
 
LVL 2

Expert Comment

by:GDE
ID: 10789763
opps.. sorry.
0
 

Author Comment

by:ThomasBell
ID: 10790480
GDE, is your post intended for this question?  If so, I don't understand what you are telling me...
0
 

Author Comment

by:ThomasBell
ID: 10790488
schwertner,

The database is in NOARCHIVELOG mode but according to the Backup Wizard, if the database is open at the time the job runs, it will be shutdown for the backup and "brought back up" once the backup is complete...
0
 

Author Comment

by:ThomasBell
ID: 10790532
schwertner,

I changed the mode to Archive mode and the backup still fails with the exact same error.  Hope this info helps.
0
 
LVL 2

Expert Comment

by:GDE
ID: 10790557
my post not for this question,  i`m miss.
sorry.

Best regards.
Dmitry.
0
 
LVL 2

Expert Comment

by:GDE
ID: 10790704
may be increase job_queue_processes in init file?

Best regards.
Dmitry
0
 

Author Comment

by:ThomasBell
ID: 10792524
GDE, I increased the "job_queue_processes" from 10 to 50 and it still doesn't work.

While I have been waiting for a solution I have also tried doing an import (IMP) using the Enterprise Manager console and it gives the same error.
0
 
LVL 3

Expert Comment

by:rajnadimpalli
ID: 10795421
@ThomasBell :

1. "Could not fork or create job process." : Seems like more of OS error ...check your Event Viewer to get more information.

2. Do you have enough resources on machine where your OEM managment server is running ?. Check you memory usage ..others resource usgae during job creation..

3. If possible post "Event Viewer " content assoicated with OEM applicaitons if any... for furthur comments....

-Raj
0
 
LVL 2

Accepted Solution

by:
GDE earned 1000 total points
ID: 10803526
1. Attempt for import use system sheduler (command "at" etc).
Write cmd or bat file, for example imp_test.cmd
for example imp test/12345@test FULL=Y file=c:\dump\fri.dmp log=.........
2. Attempt use DBMS_JOB package for creating jobs.

or you want in principle use OEM for creating jobs?



Best regards
Dmitry
0
 

Author Comment

by:ThomasBell
ID: 10809216
GDE, I can already do an IMP and EXP from a command prompt -- it works just fine, and could probably work around the problem of scheduling by using the AT command as you suggest.

I really want to use OEM for this though, as it should work.

Thanks.
0
 
LVL 1

Expert Comment

by:DonFreeman
ID: 11118523
We are having the same problem.  It doesn't have anything to do with backup it has to do with connectivity between OEM and the target server.  I can run jobs on several boxes but we have a brand new HP RAC system built by HP that is throwing this error.   We were able to discover the node and the db.  The preferred credentials are set and the node user has log on as batch and log on as service.  Has any progress been made on this?  There doesn't seem to be any info on metalink that is helpful.  Our logfile looks like the one above.  The error shown is common and not the problem.
0
 
LVL 1

Expert Comment

by:DonFreeman
ID: 11118534
And, we are on Windows 2003 Advanced Server and Oracle 9.0.2.4.
0
 
LVL 1

Assisted Solution

by:DonFreeman
DonFreeman earned 1000 total points
ID: 11120986
The answer to this problem is in the permissions set up for the Oracle Agent.   Under your Windows services look for OracleOrahome92Agent.  The fifth column over is "Log on As."  This has to be set to local system.  If it's not, then, open up properties for this service and, under the log on tab, check local system account.  
0
 

Expert Comment

by:asimsardar
ID: 14362867
I am having the same problem and I have tried all the solutions provided above but still the stuck.

Please guide.
Regards
Asim
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question