Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



Primavera P6 Enterprise Project Portfolio Management

Primavera error The database has not been configured to run background

Hi,  when I try to reinitialize Primavera job processes (system_monitor and data_monitor). I am getting following error  C:\Documents and Settings\Administrator>sqlplus   SQL*Plus: Release - Production on Thu Jan 27 11:32:22 2011   Copyright (c) 1982, 2005, Oracle.  All rights reserved.   Enter user-name: sys as sysdba Enter password:   Connected to: Oracle Database 10g Enterprise Edition Release - Production With the Partitioning, OLAP and Data Mining options   SQL> exec admuser.initialize_background_procs; BEGIN admuser.initialize_background_procs; END;   * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "ADMUSER.SETTINGS_READ_STRING", line 8 ORA-06512: at "ADMUSER.INITIALIZE_BACKGROUND_PROCS", line 6 ORA-06512: at line 1 

Pretty sure this error does not do anything to the running of Primavera. I had this happen with a previous employer and it did nothing to the actual workings of the program. Hope this helps. Mick 

Try running the procedure as the admuser account and not SYS.  If that still does not work try the below:  DELETE FROM settings WHERE namespace like 'database.background.Symon'; DELETE FROM settings WHERE namespace like 'database.background.Damon'; COMMIT;  EXEC initialize_background_procs; COMMIT;  If you still receive the error you may need to drop and rebuild the procedure.

Related Links

...recommended system & hardware requirements for clients P6 8.2 Clien&Webs
Curious problem logging into my local database.
How to install P6 Analytics? I dont understand the p6 analytics guide
Sending request to Primavera Web Services using SOAP UI 4.0.0 - Error
Displaying S-Curves of Actual+Remaining Oracle Primavera P6 EPPM R8.2 Data
Gantt chart not refreshing on the Dashboard
Want to integrate Primavera P6 EPPM with Single Sign-on
.xls file import error (P6 v7.0)
Primavera P6 8.1 Optional Client using Citrix - User already logged in
Updating / Modifying WBS using Web Access, v7, SP 2
Broadening Team Member Selection Criteria
P6 private database setup for unattended setup file
Is there a way to view activities that have notebook topics ?
Integrating two Primavera systems to transfer project information
Primavera 6.2 page setup
Excel import into P6