Queueing :: Propagation Not Working - Only After Reboot?

Sep 7, 2012

I migrated an AQ solution which sends messages between three instances from a development environment to an UAT environment and my propogation from one instance to another is not working as per development.

When I enqueue a message I note that the enq_time is one hour behind the actual sysdate.

All the messages are been stored in the queue table and are propogated through only when the instance is restarted.

FYI - the datbase is 11i Express.

The progration job is:

dbms_aqadm.schedule_propagation(queue_name => 'ITEMS',
destination => 'DIBS_MSG_DIBS_EXT'
,start_time => sysdate
,next_time => 'sysdate + 100/86400'
,duration => 60
,latency => 3000
,destination_queue => 'DIBS_STREAMS.ITEMS');

View 5 Replies


ADVERTISEMENT

Queueing :: Callback Function Not Dequeuing?

May 23, 2013

A trigger is enqueuing to a queue. This works fine, but the callback function is never called. The queue already worked for a while, but since i changed something at the procedure called by the callback it does not work anymore.

I already have tried the following:
-Stopping and restarting
-Dropping and recreating (with the scheduler having no jobs anymore)
-Dropping, restarting the database and recreating

None of these worked. Where do I fail, when considering that the queue with the same scripts worked already? I post the script for creating the queue and adding the subscriber:

CREATE OR REPLACE TYPE pat_history_queue_payload_type AS OBJECT
( TSTAMP VARCHAR2(22 CHAR),
TYP VARCHAR2(10 CHAR),
DELTA_MENGE NUMBER,

[code]...

The function CALLBACK which is called by the queue, is never called, I checked that with log messages. Also the package that contains the function is compiled ok.

View 2 Replies View Related

Queueing :: How To Configure Oracle AQ For Distributed Environment

Sep 23, 2013

I have a scenario In which I have say 4 AQ in which I will post the message.Also i have say 2 database.I am planning to create an MDB which will poll on these AQ's,  so whenever I post message the MDB will read it and perform a specific action.I believe I can create only one MDB per queue, if it is so then I have to create 8 MDB.

As there 2 datasource and 4 MDB. Is there any other way to handle this I mean without creating 8 MDB as the Data sources can increase to 10 to 20 so the number of MDB will be 20 to 40.I guess this will affect the application performance. Can I make some changes in application so that only few MDB's are required? 

View 0 Replies View Related

Queueing :: ORA-24550 - Signal Received Error While Using OAQ Receive

Jul 17, 2012

I am trying to read a message from Oracle queue using OCCI.I am getting this run time error:

ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=2] [si_int=-389971137] [si_ptr=0x34e8c1833f] [si_addr=0x615db0] Killed.I have checked for the line that is throwing error and found below line causing it:

*messageFromQueue = cons.receive(Message::RAW);

It seems like RECEIVE function is throwing this error: Here is my code:

void Cdatabase::connect(string user, string passwd, string db)
throw (SQLException)
{
env = Environment::createEnvironment(Environment::OBJECT);
conn = env->createConnection (user, passwd, db);
messageFromQueue = new Message(env);
}
[code]....

View 0 Replies View Related

Queueing :: Error When Create Sub-consult With DBLink Between 3 Instances

Nov 7, 2012

I have 3 instances and i want to work between then. The error occurs when i use subquery, This is the code:

update erie.rie_cbtrega@l$e_tfcries rgr
set rgr.c_descri = ( select rg.c_descri
from dadm.cbtrega@l$e_tfccie rg
where rg.c_idrega = rgr.c_idrega
)
;

When i execute update without subquery "( select rg.c_descri from dadm.cbtrega@l$e_tfccie rg where rg.c_idrega = rgr.c_idrega)" the result is successfully, but when i add subquery the result is

ORA-02019: no se ha encontrado la descripción de la conexión para la base de datos remota
ORA-02063: line precediendo a TFCCIE
ORA-02063: 2 lines precediendo a L$E_TFCRIES

View 1 Replies View Related

Windows :: Oracle Not Available After Reboot

Oct 16, 2010

my problem is

Sir, i have installed oracle8i successfully on my computer but when i reboot my computer & try to run SQL by using username:- system & password:- manager or scott/tiger i get message "Oracle not available".

im insert the after its working connection of data base

SQL> conn /as sysdba
Connected to an idle instance. (after)
SQL> startup mount
ORACLE instance started.

Total System Global Area 569496844 bytes
Fixed Size 70924 bytes
Variable Size 165638144 bytes
Database Buffers 403709952 bytes
Redo Buffers 77824 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL> alter user system identified by manager ;

User altered.

SQL> conn system/manager
Connected.

so this is process follwing is working but system is restart its not working...

View 1 Replies View Related

Server Administration :: Reboot DB For Better Performance?

Apr 20, 2011

question about DB, i wanna know if the DB performance will be better after the reboot of this db

View 12 Replies View Related

Auto Startup Active DataGuard After Reboot

Apr 6, 2011

I try to auto startup my standby database after reebot machine. I used trigger " on startup" , srvctl but still it doesn't work..Database 11g , operating system RedHat 5 or HP-UX.

View 2 Replies View Related

ORA-01115 - ORA-01110 - Cannot Access Dbs.after Reboot Server Only Db?

Jul 22, 2012

After getting the following error ,Our production oracle db server is crashed,we cant access the dbs.after reboot the serveronly we can access the db,

ORA-01115: IO error reading block from file ORA-01115: IO error reading block from file 83 (block # 639938)
ORA-01110: data file 83: '/oradata/prod/prod_data04.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error

[code]...

View 3 Replies View Related

RAC & Failsafe :: Oracle Server Reboot - IP Ping Failed

Jun 20, 2011

Every time interconnect IP ping failed between RAC servers,CRS causing reboot to the server. As documented,it is of 3 sec. Can we alter this setting to increase the ping failed (private IP) by more than 3secs.

View 4 Replies View Related

Performance Tuning :: DB Import Too Slow After Server Reboot

Jul 4, 2011

Few days ago, My database server no access to StorageBox then I reboot it then after works fine. But, know DB import process is too slow. Before 100GB DB import process completed within 10 hours when server normal running. Now 2 day working, but not complete

How to investigate this issue? Maybe I miss increase some parameters on the Server or Oracle?

Here is my server brief info:

RAM is 16GB,
SWAP size is 16GB,
CPU 12 cores

SQL> show sga;

Total System Global Area 4294967296 bytes
Fixed Size 1984144 bytes
Variable Size 369105264 bytes
Database Buffers 3909091328 bytes
Redo Buffers 14786560 bytes

View 11 Replies View Related

Real Application Clusters :: DB Not Coming Up Along With Crs After Node Reboot?

Oct 2, 2013

Grid Version: 11.2.0.3 OS: Red Hat Enterprise Linux 5.6  Node2 of our two node RAC got rebooted. Upon reboot, CRS and ASM instance came up. But the DB didn't come up.  How can I check if DB is linked to CRS startup ?How can I enable DB startup upon CRS startup ?

View 3 Replies View Related

Enterprise Manager :: Disable DB Console To Start On Server Reboot

Feb 20, 2012

$emctl stop dbconsole stops the OEM process.

however,it starts back up on server reboot,how can we prevent that is emca deconfig the only option?

View 6 Replies View Related

Server Administration :: Clone Database Cannot Be Connected After System Reboot

Oct 21, 2010

1. I installed oralce with Service_Name=DB1 it works fine,

2. I created another database with dbca named DB2,

3. I connected both system/password@db1 and system/password@db2 without any problem,

4. After rebooting the computer I can connect only the first database DB1 which I installed with Oracle installation. But, I can not connect to the 2nd database which I created with dbca. Error Message Shows: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

DB1 has no problem I can connect to that, but I can not connect to DB2 after rebooting the system. Now I need to know how to connect to DB2.

Quote:

connection messages:
oracle@pc ~]$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 21 12:51:43 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: SYSTEM@DB1
Enter password:

[code]....

View 9 Replies View Related

RAC & Failsafe :: Can't START Instance After Apply Critical Patch And Reboot

Apr 21, 2011

This is 2 node RAC database. Usually every month my system admin was applying OS critical patch then reboot the server.

While doing this activity i have stop all CRS and DB services. As usual i have did same in both the nodes and applied the patch and reboot the server.

After tried to start the CRS service and database services was used the following command. Except node1 instances all services are started.

E:oraclecrsproduct11.1.0crsBIN>crs_Stat -t
Name Type Target State Host
------------------------------------------------------------
ora....main.db application ONLINE ONLINE inf-...b-03
ora....n1.inst application ONLINE OFFLINE
ora....n2.inst application ONLINE ONLINE inf-...b-04
ora....SM1.asm application ONLINE ONLINE inf-...b-03

[code].....

Then i have tried to applied to old ocr backup also, then also i am getting same error.

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Installing 10.2.0.1 Database Binaries Machine Reboot?

Dec 7, 2012

I am installing RAC on my Laptop using VM ware workstation . I have created two linux machines on VM ware with 1 gb merory on each machine . I installed 10.2.0.1 clusterware successfully but when i am installing 10.2.0.1 database binaries my machine reboot every time .

View 3 Replies View Related

Queue To Queue Propagation

Jan 19, 2010

I am trying to propagate messages between two queues that are in the same database.I did exactly as it says here: URL.....

The message is propagated successfully.The problem is that it doesn't to dequeue the message with the default subscriber of the destination queue.

The only difference between what I did and what is in the example above is that I didn't create a database link. I don't think I need to because the queues are in the same database, and the problem is not the propagation because as I said the message has moved to the destination queue.

View 4 Replies View Related

ORA-00932 - Sample Code Working Fine In 10g And Not Working Now In 11g

Apr 1, 2013

Below is the sample code working fine in 10g and not working now in 11g.

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....

we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class

Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

View 3 Replies View Related

PL/SQL :: To_char Not Working / (||) Is Working With Join Query

Mar 22, 2013

I have two tables : oa_membership_dtl(in this created_by field is varchar2(200 byte) ,oa_partner_usr_dtl(in this table partner_userid is number(8,0) i need to do join on above fields.

I am using following two queries:

select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on to_char(partner_user.partner_userid,'9999')=membership.created_by
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on rtrim(ltrim(partner_user.partner_userid||' '))=rtrim(ltrim(membership.created_by))

by using first data is not fetched but 2nd is working fine , i am getting the matched records using 2nd query.

whats the diff between to_char and || symbol?

View 1 Replies View Related

Sqlplus UI - Not Working?

Apr 22, 2008

I'm having some minor trouble with my sqlplus in Windows. Don't know which feature I accidentally edited by cosole seems to be in debug mode. Everything is ok, except that it print the old and new values of my variables. How can't I restore it to it's original behavior.

View 3 Replies View Related

SQL & PL/SQL :: How To Calculate Working Day

Jan 1, 2013

I need a query to find out the working days. I have attached the sample script to create table and data. Here is the description of the tables.

Emp1 : To record the employe's information and weekly rest day.
Attendance :- To record daily attendance.
Leave_appovd : To record the approved leaves.
Holiday : To record the holidays.

W = Attendance
R = Weekly Rest
L = Leave
H = Holiday
A = Absent

Required output is

Emp No.In Date Out Date Type
736912/1/201212/1/2012W
736912/2/201212/2/2012R
736912/3/201212/3/2012W
736912/4/201212/4/2012W
736912/5/201212/5/2012W
736912/6/201212/6/2012L
736912/7/201212/7/2012H
736912/8/201212/8/2012H
736912/9/201212/9/2012R
736912/10/201212/10/2012A
736912/11/201212/11/2012W
736912/12/201212/12/2012W
736912/13/201212/13/2012W
736912/14/201212/14/2012W
736912/15/201212/15/2012L
736912/16/201212/16/2012L
736912/17/201212/17/2012L
736912/18/201212/18/2012W
736912/19/201212/19/2012W
736912/20/201212/20/2012W
736912/21/201212/21/2012W
736912/22/201212/22/2012W
736912/23/201212/23/2012R
736912/24/201212/24/2012A
736912/25/201212/25/2012A
736912/26/201212/26/2012A
736912/27/201212/27/2012W
736912/28/201212/28/2012W
736912/29/201212/29/2012W
736912/30/201212/30/2012R
736912/31/201212/31/2012W
778212/1/201212/1/2012W
778212/2/201212/2/2012W
778212/3/201212/3/2012W
778212/4/201212/4/2012W
778212/5/201212/5/2012W
778212/6/201212/6/2012W

Separate Query will be run for the following output.

Wroking Days
EmpnoAttend WeeklyRestsLeavesHolidays TotalAbsentsG. Total
7369 17 4 4 2 27 4 31
7782 6 0 0 0 6 25 31

If any body work on weekly rest or holiday, it will be considered as weekly rest and holiday. There working on these days will be treated separately.

View 10 Replies View Related

SQL & PL/SQL :: Update Is Not Working

Apr 27, 2012

with a as (
SELECT subscriber_agn,max(ixml_id) ixml_id, claim_id
FROM
(

[Code].....

i want to combine above two and need only one sql stmt.

View 2 Replies View Related

SQL & PL/SQL :: DDL Trigger Not Working?

May 14, 2013

I have a trigger to automate grants to a Role whenever a table is created in my schema.I have dba rights.

CREATE OR REPLACE PROCEDURE deepa.myddl
(p_ddl IN VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE p_ddl;

[Code].....

This works perfectly when i create a table as deepa user. But say when another User creates a table in my schema

like create table deepa.test1 ( a number) This trigger is not fired. Whenever a table is created by me or by any other user in my Schema, i need the trigger to be fired.

View 2 Replies View Related

SQL & PL/SQL :: In Clause Is Not Working?

Sep 18, 2013

SELECT sno,mid,mname
FROM manage_date
WHERE mname IN
('KIRAN-KUMAR',
'RAHUL-RAJ',
'KAUSHAL-SONI');

IF I use this query directly in DB it's working fine. But when this query is calling in .net using parameter as below it's not giving any records for more than one value. IN (:p_mname)

If I pass one name 'KIRAN-KUMAR' from .net It's working.

If I pass multiple names from .net query not returning any records.

View 4 Replies View Related

Oradim Is Not Working

Dec 13, 2010

I trying to create the new service for my physical standby database. It's on the same vista machine. But somehow it's not working.

C:\Oracle\product\10.2.0\mayuprd\database>oradim -new -sid -intpwd ananya -start
mode manual
DIM-00003: An argument is missing for the parameter.

View 5 Replies View Related

SQL & PL/SQL :: Recycle Bin Not Working

Jun 14, 2010

I went through the link given in orafaq and tried to work on my system but the things did not work.

SQL> select *
2 from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> ALTER SYSTEM SET recyclebin = ON;

System altered.

SQL> SELECT Value FROM V$parameter WHERE Name = 'recyclebin';

VALUE
--------------------------------------------------------------------------------
ON

SQL> CREATE TABLE TEST_RBIN(VAL NUMBER);

Table created.

SQL> INSERT INTO TEST_RBIN(VAL) VALUES(10);

1 row created.

SQL> COMMIT;

Commit complete.

SQL>
SQL>
SQL> DROP TABLE TEST_RBIN;

Table dropped.

SQL> SHOW RECYCLEBIN;
SQL> SELECT * FROM USER_RECYCLEBIN;

no rows selected

View 6 Replies View Related

SQL & PL/SQL :: Select INTO Is Not Working

Mar 8, 2013

why my "select into" not working.i also create the table testjobs but also not working

SQL> select *
2 into testjobs
3 from jobs;
into testjobs
*
ERROR at line 2:
ORA-00905: missing keyword

View 8 Replies View Related

Oracle 11g EM Not Working (Linux OS)

Jan 20, 2011

I am unable to configure EM(Oracle 11.2g) on Redhat Linux 5 Enterprise edition(32 bit). Environment variables are set to correct SID. If I try to run dbca the wizard does not display the Enterprise manager configuration screen. I have tried to create repository by using emca -config dbcontrol -db config.

But it throws exception that database instance is unavailable?

View 5 Replies View Related

Self Join No Longer Working?

May 20, 2010

I have a piece of code that joined the same table onto itself twice in order to get the previous, current and future year's into columns in the same output.

Up until recently this has been working fine but the most recent data has just been uploaded into the table and now it comes up with an error.

On the second (left outer) join it now says that the column is ambiguously defined (ORA-00918). It doesn't matter which order the joins are in it is always the second join that the error pops up on.

View 4 Replies View Related

Working With Date In Oracle?

Oct 31, 2011

I tried to insert date in date column from another table date column. Below is SP ans execute procedure.

CREATE OR REPLACE PROCEDURE test(
start_time Varchar
)
AS
BEGIN
DBMS_OUTPUT.ENABLE(1000000);
DBMS_OUTPUT.PUT_LINE(start_time);
Insert into test_ora (report_date) (select start_time from

[code]....

execute test ('27-10-2011 12:01:01');

It gives error as Invalid number.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved