Re: looking for a third party 'job system/job scheduler'
AppWorx, now UC4, is one possibility but there is little, if anything, they can do that can not be done through the proper use of the DBMS_SCHEDULER package.
I would suggest that, before you spend or waste money, you look at the docs on DBMS_SCHEDULER and determine that there is something you need that you have not already purchased. Using OEM to schedule jobs is far from giving you access to the full functionality.
Oracle Forum Search for UC4
List of messages matching UC4
4 janvier 2012 : Re: I want SQL statment to trace select statment query running against table
the data type as below: Name Null? Type OBJECT_ID NOT NULL RAW(16) OBJECT_CLASS_ID NOT NULL RAW(16) SECURITY_ID NOT NULL RAW(16) EPOCH_ID (...)
17 novembre 2011 : 3rd party software tools to automate Weblogic deployments/release process
Folks, I'm currently evaluating few 3rd party software tools to automate Weblogic deployments/release process - software release automation. if someone has used products from Xepialabs , UC4 or Urbandeploy etc - can you advise how effective these are please?.. We have around 25+ (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
28 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
27 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
27 avril 2011 : Re: get the pattern by a give xmldom.DOMNode
thanks for your answer!! i'll try with your advice, my version is: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production (...)
29 mars 2011 : nbean in use in Cluster
Version 9.2.3 Cluster | 2 Nodes Hi all i have a mysterious problem when i use a client(UC4) to transfer data between 2 DB's over a application. (every 2 min) If the App runs on just one ClusterNode everything is fine. But when i tell the client to use the 2 members of the cluster, the (...)
29 mars 2011 : nbean in use in Cluster
Version 9.2.3 Cluster | 2 Nodes Hi all i have a mysterious problem when i use a client(UC4) to transfer data between 2 DB's over a application. (every 2 min) If the App runs on just one ClusterNode everything is fine. But when i tell the client to use the 2 members of the cluster, the (...)
29 mars 2011 : nbean in use in Cluster
Version 9.2.3 Cluster | 2 Nodes Hi all i have a mysterious problem when i use a client(UC4) to transfer data between 2 DB's over a application. (every 2 min) If the App runs on just one ClusterNode everything is fine. But when i tell the client to use the 2 members of the cluster, the (...)
15 novembre 2010 : Re: Owner of files written with utl_file
Hello Michael, You may run dbms_scheduler I have thought about this, but our batch processing is sheduled by UC4 and I would have to implement another routine to check when the job is finished. One thing I will test is to execute CHMOD via JAVA. It should also be executed as user (...)
15 novembre 2010 : Re: Owner of files written with utl_file
Hello Michael, You may run dbms_scheduler I have thought about this, but our batch processing is sheduled by UC4 and I would have to implement another routine to check when the job is finished. One thing I will test is to execute CHMOD via JAVA. It should also be executed as user (...)
12 septembre 2010 : RMAN revovery sometimes fails
Hi, I'm having sometimes problems with the recovery of some tablespaces within an complete database recovery. Running step by step within UC4 as an job control tool, the following errors for two tables occurs. Just find below one example. Environment: - Oracle 10g RAC Cluster, 2 nodes (...)
23 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
EMConsole works for test db, not for prod db. The advice was To recreate the configuration files and repository for Database Console, run: $ emca -config dbcontrol db -repos recreate So I ran it. It ran into trouble early with Port in use poblems: Jul 22, 2010 3:38:43 PM (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
Here's an interesting sequence from my emagent.trc file, started after I updated my listener.ora and took a step forward. Before this there were many messages: SQL = "/* OracleOEM */ BEGIN IF (:1 = 'READ WRITE' AND (:2 = '2' OR :2 = '3')) THEN "... LOGIN = (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
I renamed listener.log to get a new, small-enough-to-read log, and quickly found a SID issue: 13-JUL-2010 13:26:49 * (CONNECT_DATA=(SID=UC4)(CID=(PROGRAM=C:\oracle\11g\perl\5.8.3\bin\MSWin32-x64-multi-thread\perl.exe)(HOST=CDC-APPWORX)(USER=SYSTEM))) * (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
13 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
You should consolidate your SID_LIST as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = UC4) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4) ) (SID_DESC = (GLOBAL_DBNAME = UC4TEST) (ORACLE_HOME = %Oracle_Home%) (SID_NAME = UC4TEST) ) ) This (...)
12 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
It t looks to me like I already have static info configured in my listener.ora, global_dbname, sid_name,oracle_home: # listener.ora Network Configuration File: c:\oracle\11g\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (...)
12 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
It t looks to me like I already have static info configured in my listener.ora, global_dbname, sid_name,oracle_home: # listener.ora Network Configuration File: c:\oracle\11g\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (...)
10 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
Ogan Ozdogan wrote: This will help you solve your problem; # set ORACLE_SID=uc4 # rman target sys/password RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP MOUNT; This won't help at all if the OP is connecting remotely, which a lot of people do if they are backing up from a central (...)
10 juillet 2010 : Re: RMAN startup fails after shutdown succeeds
Dear user13373645, This will help you solve your problem; # set ORACLE_SID=uc4 # rman target sys/password RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP MOUNT; Hope it Helps, Ogan
9 juillet 2010 : RMAN startup fails after shutdown succeeds
Oracle 11g, new at Oracle after inheriting this server (Windows 2008). I'm trying the basic RMAN to get a consistent backup of each of the two databases, with Backup / Recovery Manual notes: RMAN> SHUTDOWN IMMEDIATE RMAN> STARTUP FORCE DBA; RMAN> SHUTDOWN IMMEDIATE; RMAN> (...)
8 juillet 2010 : RMAN backup problems, which one first?
Oracle 11g on Windows 2008Std I've inherited. It has a nightly backup job set in Ent Mgr, the Oracle-suggested disk backup, script: allocate channel oem_disk_backup device type disk; recover copy of database with tag 'ORA\$OEM_LEVEL_0'; backup incremental level 1 cumulative copies=1 for (...)
14 juin 2010 : Re: How to schedule Batch programs in RMS
Hi, See http://www.uc4.com/products-solutions/uc4-intelligent-automation-solutions/oracle-retail.html. This is the single dedicated (prebuilt) offering re. scheduling for mostly the MOM suite, RDW (and more?). Before being acquired by UC4 it was called AppWorx. There are some OAUG-ORUG (...)
5 février 2010 : Re: CC&B Operational question
All comments on this thread are correct. There are some utilities who use basic cron and the delivered scheduling features. I believe most customers opt to use more advanced scheduling engines similar to what you describe. My company uses the UC4 to automate CC&B batch and many other Admin (...)
5 février 2010 : Re: CC&B Operational question
All comments on this thread are correct. There are some utilities who use basic cron and the delivered scheduling features. I believe most customers opt to use more advanced scheduling engines similar to what you describe. My company uses the UC4 to automate CC&B batch and many other Admin (...)
16 décembre 2009 : Join Confusion
I have a servers table like so: ID | host_name | host_console _________________________ 1 | ibm1 | 2 2 | ibm2 | 4 3 | ibm3 | 1 I have a consoles table with a console_backup column that references the same table: console_id | console_name | (...)
16 décembre 2009 : Join Confusion
I have a servers table like so: ID | host_name | host_console _________________________ 1 | ibm1 | 2 2 | ibm2 | 4 3 | ibm3 | 1 I have a consoles table with a console_backup column that references the same table: console_id | console_name | (...)
7 mai 2009 : Re: looking for a third party 'job system/job scheduler'
AppWorx, now UC4, is one possibility but there is little, if anything, they can do that can not be done through the proper use of the DBMS_SCHEDULER package. I would suggest that, before you spend or waste money, you look at the docs on DBMS_SCHEDULER and determine that there is something (...)
7 janvier 2009 : using stored procedures - I can't seem to get the parameters right
I am wanting to use stored procedures to create substitute variables to use in UC4(Appworx). (the databases I am using are 10g) To do this I first need to get the procedures to run at the command line in PL/SQL. I do not seem to be able to create the correct command. This is the part of the (...)
30 octobre 2008 : Re: RIB vs AppWorx (integration between Oracle POS and RMS)
Hello Aan, Please see my comments in the message below. Please do not count on my remarks only but get expert advice (from an expert who has sufficient time, e.g. a consultant from Oracle Corp., Wipro Retail, Online Resource, Accenture, FSI, IBM, etc.) re. this - the whole integration subject (...)
30 octobre 2008 : Re: RIB vs AppWorx (integration between Oracle POS and RMS)
RIB is a publisher/subscriber internal integration bus, like an enterprise service bus, for Oracle Retail modules like RMS, RWMS, SIM etc. Appworx/UC4 is a batch scheduling and execution platform - e.g. RMS comes with many programs that either need to be run multiple times per day, or once a (...)
1er août 2008 : Re: How to run multiple query paralelly in single session?
Hi some one else, i guess he can use some kind of scheduler tool, where the scripts are run parallely, and each time they connect to db, we use tool called uc4 to do it, i know only this way regards nic
23 juillet 2008 : Re: Two Columns reference lookup table
took me half the day ... but I figured it out ... select "HOST_NAME",t."STATUS_NAME",u."STATUS_NAME" as "UC4_NAME" from "SERVERS" left outer join "STATUS" t on t."STATUS_ID" = "HOST_STATUS" left outer join "STATUS" u on u."STATUS_ID" = (...)
23 juillet 2008 : Re: Two Columns reference lookup table
LEFT OUTER JOIN "STATUS" as "UC4" on "UC4"."STATUS_ID" = "HOST_UC4" At first glance there is an as "UC4" that should not be in the join. This is where you are getting your missing keyword error.
23 juillet 2008 : Re: Two Columns reference lookup table
select "HOST_NAME","STATUS"."STATUS_NAME","UC4"."STATUS_NAME" as "UC4_NAME" from "SERVERS" LEFT OUTER JOIN "STATUS" on "STATUS_ID" = "ID" LEFT OUTER JOIN "STATUS" as "UC4" on "UC4"."STATUS_ID" = "HOST_UC4" gives me ERROR at line 3: ORA-00905: missing (...)
23 juillet 2008 : Re: Two Columns reference lookup table
"SERVERS" table has "HOST_STATUS" , "HOST_UC4" "STATUS" lookup table has "STATUS_ID","STATUS_NAME" "HOST_STATUS" has a numerical value that corresponds to a row in "STATUS" "HOST_UC4" has a numerical value that corresponds to a row in "STATUS" select host_name,host_status from servers (...)
23 juillet 2008 : Re: Two Columns reference lookup table
Try... select "HOST_NAME","STATUS"."STATUS_NAME","UC4"."STATUS_NAME" as "UC4_NAME" from "SERVERS" LEFT OUTER JOIN "STATUS" on "STATUS_ID" = "ID" LEFT OUTER JOIN "STATUS" as (...)
22 juillet 2008 : Two Columns reference lookup table
select "HOST_NAME","STATUS_NAME","STATUS_NAME" as "UC4_NAME" from "SERVERS" LEFT OUTER JOIN "STATUS" on "STATUS_ID" = "ID" LEFT OUTER JOIN "STATUS" as "UC4" on "UC4"."STATUS_ID" = "HOST_UC4" I have two columns (HOST_UC4 and HOST_STATUS) that use a lookup table named "STATUS" for its values. (...)
