I am getting error message while installing oracle database gateway 11.2 on linux el6 64 bit machine
Error in invoking target 'install of makefile dg4mqs.mk'...if we ignore the error and continue...after installation we can see missing executable files .
I am getting ora-24010 error in the target database where I am configuring the apply process, DB is 10.2.0.1 on RHEL
SQL> conn strmadmin/strmadmin@db2
Connected.
SQL> begin dbms_streams_adm.add_table_rules
2 ( table_name => 'scott.test',
3 streams_type => 'apply',
4 streams_name => 'apply_stream',
[code]...
The capture process and the propogation rule and scn instantiation on the source were executed fine withut issue, I am having problem in the apply process.
I'm inserting to a table through a procedure, I want to log the rejected records to a log table with the execption / reason.How can I get the exception name and error text in PL/SQL ?
View 20 Replies View RelatedI am getting following error in my alert log file of my database
ORA-07445: exception encountered [kduget () +1032][sigbus]
as i can perform some of my database activity but from some of the users i cannot login.
i tried to search out and found that some Memory needs to be flushed out so restarting of database is only action to be taken?
My cursor went to the exception when its got the error " ORA-01403: no data found"
But my cursor need to run even though it got the error " ORA-01403: no data found"...This is my exception part
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (c1rec);
DBMS_OUTPUT.put_line (SQLCODE);
DBMS_OUTPUT.put_line (SQLERRM);
-- RETURN NULL;
-- code change added as part of GCA642 -- END
END get_geo_test1;
I have installed Oracle 11gR2 on Windows 7 professional. I created a DB and a listener also.No issues there; I can connect to the DB with sqlplus and SQL Developer.when I try to configure dbcontrol on this DB, it fires errors;
--------------------------------------------------------------------------------------------
C:Windowssystem32>emca -config dbcontrol db
STARTED EMCA at Jun 7, 2012 2:20:15 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: ORA112
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableExcep
[code]...
How this can happen?
I am trying to build one custom 10g form from TEMPLATE.fmb. when i try to compile my form in desktop it is giving error as Error FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508.
View 1 Replies View RelatedI am using Oracle 10.2.0.1.0. My intention is to create a new database instance.
Here are the steps I have taken,
1. Using DBCA, I created a new database instance, oracle sid = MYORCL0318
2. I created the tablespaces for this instance.(I obviously have not imported any data into this database yet.)
then, I went to Enterprise Manager,
Login = sys
password = xxxxxxx
role = SYSDBA
After I login, I would get an Error like this
java.lang.Exception: Exception in sending Request :: null
when ever the developer connecting to database to generate froms or While trying to create inventory categories below error is appearing.
FRM-40735: On-error trigger raised unhandled exception ora-06508..
I am using forms 10g developer suite, AIX in appl server.
When I run the form on my local drive through web I am getting error that,FRM-40735:ON-ERROR trigger raised unhandled exception ORA-06508.
My fmbs & fmxs are in e:fmb, libraries are in d:applicationlib.
FORMS_PATH in Registry is C:DevSuiteHome_1cgenf61admin;C:DevSuiteHome_1forms;e:fmb;d:applicationlib
I have set the same path in default.env also.What should I update, to run the form successfully.
I am in process of migrating Oracle 6i Forms to Oracle 10g Forms.
In 6i, the Form compiles and runs without any giving any error.
In 10g it does complie without any error but gives following Runtime Error Message -
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508
I am using database 10g and Form 6i. We are working under client server technology. Frequently we are receiving the following error to every user at randomly when they are idle few seconds/minutes.
FRM-40735 or error trigger raised unhandled exception ora-03114
I have importing a dump file which is of size upto 6GB, its working fine. At the last step after the import of all the tables when it enables constraints , indexed and everything a pop-up window with the above mentioned error in the subject pops-up.
I am not able to mention the error exactly so find the screen shot as attachment.
APEX 4.2Oracle 11g Database We are using the standard exception handler that was introduced in APEX 4.1, and we have code in packages & procedures in the database (following proper processes of keeping code in the database where possible). When an exception is found in the procedures/ packages/functions, should the APEX application level exception handler catch any errors that occur or should they be handled in the package/procedure/function they occurred in? Why I ask if, we right now have exception handling code in the pl/code bodies BUT they write their errors to the same table that Apex's Exception handler does, but the errors are NOT presented to the user using the APEX exception handling mechanism.
View 2 Replies View RelatedI have to implement exception handling in the exception block of a trigger, Quote:exception
when ora_java.java_error then
message( 'Unable to call out to java, ' || ora_java.last_error );
ORA_JAVA.CLEAR_EXCEPTION;
when ORA_JAVA.EXCEPTION_THROWN then
ex := ORA_JAVA.LAST_EXCEPTION;
message( Exception_.toString(ex));
-- lv_exception := Exception_.getMessage(ex);
I get an error for the line: 'message( Exception_.toString(ex));'I have imported the java classes FException et IObject with their methods.
I have to create a Web Service Client, so I wonder if the paragraph Quote:when ORA_JAVA.EXCEPTION_THROWN then ex := ORA_ JAVA. LAST_ EXCEPTION; is mandatory.
I'm trying to call a simple batch file from dbms_scheduler, the job created successfully but I it doesn't invoke the batch file I've created.
This is the contents of my batch file :
EXEC hr.load_employees
And this is the job attempting to invoke it :
begin
dbms_scheduler.create_job
(job_name => 'EMP_HIST',
job_type => 'EXECUTABLE',
job_action => 'C:sql_scriptsemployees_load.sql > nul',
start_date => SYSDATE,
-- repeat_interval => 'FREQ=DAILY;BYHOUR=23', -- Every night at 23:00.
repeat_interval => 'FREQ=SECONDLY; INTERVAL=2', -- Every Minute
enabled => true,
comments => 'Copy the emp table to history');
end;
/
I want to create a DB job on APEX Server-1, when runs every 30 mins and on finding records, invokes an API available on another APEX Server-2 passing the parameters from Server-1. How do I achieve this ?
View 3 Replies View RelatedI try to install the Grid Control 10.2.0.5 on Solaris 10 in an existing (empty) Database Oracle 10.2.0.4. All steps work without problems except
-- OMS Configuration (in Configutaion Assistants)
emca_repos_create15_25_32.log :
Quote:
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647)
[code].......
ORA_NLS10 is set to $ORACLE_HOME/nls/data of DB
Also tried to set to $ORACLE_HOME/nls/data of oms10g but get Problems to start opmn and later on it report also ORACLE_HOME and NLS Parameter set incorrectly. I checked MetaLink / Internet without success.
I am trying to install the 11GR2 on HPUX 11.31 U ia64 with silent option.while tried to launch runinstaller, I hit the below issue.
dfltest> ./runInstaller -ignoreSysPrereqs -force -silent -responseFile > /db/dfltest/oracle/product/11.2.0/database/db_install.rsp.mainStarting Oracle Universal Installer... Checking Temp space: must be greater than 240 MB. Actual 475 MB PassedChecking swap space: must be greater than 150 MB. Actual 23189 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2013-07-17_12-01-18PM. Please wait ...oradev1 oradflts /db/dfltest/oracle/product/11.2.0/databasedfltest> Error: could not find libjava.soError: could not find Java 2 Runtime Environment. ----extracted from following files -----p10404530_112030_HP64_2of6.zipp10404530_112030_HP64_1of6.zip
I need to find out the exact DML statement which invoked a particular trigger inside a trigger body.
View 7 Replies View RelatedI need to invoke a JavaMail code from oracle server. Conditions are :
On insertion of a row in a table a TRIGGER is to be run. This trigger would invoke a java code, that shoots an email, with desired credentials and login.
The code to send email, is based on JavaMail API, and is compiled on JVM version, 1.6.
The javaMail code can be loaded in oracle server using:
loadjava -user scott@TESTDB SendMailSSL.class
Another code doscmd.class is written and loaded in oracle, that is compiled in java 1.5. It is intended to call the SendMailSSL.class
import java.util.Properties;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
[code].....
Is there a way to invoke SendMailSSL.class, without upgrading the oracle Java version
OS=Redhat 5
Oracle=11gr2
Grid=11gR2
I am trying to install Oracle Database 11gR2 database on Oracle Grid 11gR2. I successfully installed Grid without errors. However, when installing the database, I got an OLR Integrity error during the prerequisit Check
OLR Integrity - This test checks the integrity of OLR on the local node.
Expected Value : n/a
Actual Value : n/a
List of errors:
- Permissons of file
"/u01/app/oracle/product/11.2.0/grid/cdata/localhost/localhost.olr" did not match the expected value. [Expected = "0600"; Found = "0660"]
- Cause: Cause of Problem Not Available
- Action: User Action Not Available.
When trying to install Oracle Grid Infrastructure on Virtual Box RHL 5.5 (2.6.18-194.el5 kernel) machine it gives error.
Quote:$ Xlib:connection to ":0.0" refered by server
Xlib:No protocol specified
Exception in thread "main" java.lan.NoClassDefFoundError
at java.lan.Class.forName0(Native Method)
..........at oracle.install.ivw.crs.driver.CRSInstaller.main(CRSIntaller.java:103)
I'm doing some testes installing grid 11.2.0.3 32bits software on a OEL6 32bits (virtual box environment). The problem appeared where i ran root.sh script on node 1. The following error appeared to me:
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
[code]..
I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:
[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory.
CAUSE: The central inventory location provided is not empty.
The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.
I am running this command to install oracle:
/runInstaller -silent -ignorePrereq -showProgress -waitForCompletion -responseFile /tmp/db_install.rsp
drwxrwx--- 6 oracle oinstall 4096 Apr 2 10:42 oraInventory
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:39 ContentsXML
drwxrwx--- 3 oracle oinstall 4096 Apr 2 10:41 backup
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:41 logs
[code]....
I have a confusion with MEMORY_TARGET and MEMORY_MAX_TARGET parameter. if i set SGA_TARGET, SGA_MAX_SIZE along with MEMORY_TARGET and MEMORY_MAX_TARGET then how oracle will manage the memory? Because as per my understanding if we set MEM
View 3 Replies View RelatedI have an error with this request :
SELECT SEQ_ENTITE.nextval, ENT_CODE_ENT, ENT_GPL_ID, TO_NUMBER('2012')+1,
pkg_etl_fdx.f_getseqexe('LPG_TYE', 'TYE_CODE_CON', ENT_CODE_TEN, 'TYE_SEQ', TO_NUMBER('2012')),
ENT_LIB_ENT, ENT_SEUIL, 'O', 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, ENT_CODE_UNI, ENT_CODE_MERE, ENT_IND_FIN, 0,
0, 0, ENT_NIVEAU, ENT_CODE_TEN, CHAR_TO_LABEL('EXERCICE', 'PUB:EXE'||TO_NUMBER('2012')+1||':'), OLS_GRP
FROM ENTITE
WHERE ENT_OLS_EXE = TO_NUMBER('2012');How to fix ORA-01722 PL/SQL: numeric or value error string ?
The description of the table Entite :
desc entite
Nom NULL Type
------------- -------- -----------------
ENT_SEQ NOT NULL NUMBER(38)
ENT_CODE_ENT NOT NULL VARCHAR2(6 CHAR)
ENT_GPL_ID NOT NULL NUMBER(10)
ENT_OLS_EXE NOT NULL NUMBER(38)
ENT_TYE_SEQ NUMBER(38)
[code]....
FUNCTION get_attributed_sedol( p_ref_number IN VARCHAR2,
p_field IN VARCHAR2 )
RETURN VARCHAR2
IS
l_query VARCHAR2(1000);
[code]...
It gives me an error on the line where the execute immediate statement is.
Quote:
ORA-00905
missing keyword
Cause: A required keyword is missing.
Action: Correct the syntax.
But when I check my stack trace table to see what the actual query string looks like, I see this
Quote:
SELECT sedol INTO l_attributed_sedol_code FROM integration.tmp_attributed_sedol WHERE CLIENT_LEDGER_REF='LEAE057090' AND ROWNUM=1
There's nothing wrong with that, is there? It executes fine if I try it manually.
how to resolve this error
proc = connection.prepareCall("{?,?=call pr_add_user_diary_event(?,?,?,?,?,?,?,?,?,?)}");
proc.setString(1, p_event_date);
proc.setString(2, p_start_time);
proc.setString(3, p_end_time);
[code]..
Error:SQLException caught: Malformed SQL92 string at position: 2. Expecting "=" got ","
Is there a way to get around the "cannot insert NULL" error when inserting a row with an empty string.
For example:
create table t (
col1 varchar2( 8 ),
col2 varchar2( 8 ),
...,
PRIMARY KEY (col1, col2)
);
insert into t (col1, col2, ...) values ('Hi', '', ...);