TimesTen In-Memory :: Unable To Receive XLA Events After A While?

Mar 12, 2013

We have been using XLA to capture events on TimesTen for a while now without any issues. We were on TimesTen 7.0.5 and then moved to 11.2.2.3.0 and now 11.2.2.4.0. The XLA processes used Java 6 64 bit and works well with TimesTen versions 11.2.2.4.0 - 64 bit and 11.2.2.3.0 - 64 bit, without any issues.

However, we recently upgraded to Java 7 64 bit both during build time of our XLA processes as well during runtime. The problem we see now is that XLA process upon startup processes events for a while and then after that doesnt receive any events. The process doesn't throw any errors/exceptions. If we restart the XLA process, all the unprocessed events are received and then it behaves normally for a while after which it fails to receive any further events.

Is there any issue with Java 7 64 bit and the TimesTen XLA API? I read the TimesTen 11.2.2.4.0 manual and it says that Java 7 and the ttjdbc7.jar have been certified to work well. Was just wondering if there were any other issues.

In addition, to debug the problem, we ran XLA on a single node and on a two safe setup. The same observations are noted. On Java 6, the process runs just fine capturing all events without any issues, but with Java 7, the issues persist.

In addition, we are only performing updates/inserts on to TimesTen, no delete actions. The OS on which TimesTen's and XLA runs is Red Hat Enterprise Linux Server release 5.7 (Tikanga).

View 2 Replies


ADVERTISEMENT

TimesTen In-Memory :: Process Of Initialization Of Database Into Memory

May 23, 2013

Can i know the internal process of initialization of DB into memory in timesten , when a new connection is establishing? Will timesten create tables and indexes in RAM when first connection is established if the RAM policy is default?

want to know the internal functional flow of timesten when any command is fired against it.

View 3 Replies View Related

TimesTen In-Memory :: Integration With Radware

May 2, 2013

As per my understanding , Timesten or IMDB Cache can be connected through DSN by any external client. Want to know whether Radware can be integrated with Timesten or IMDB Cache.

View 1 Replies View Related

TimesTen In-Memory :: JDBC Connection - Is It TCP/IP?

Jul 18, 2012

I connection to TimesTen as follow:

String url = "jdbc:timesten:direct:dsn=my_ttdb";
String username = "ADMINISTRATOR";
String password = "";
Connection connection = DriverManager.getConnection(TestTT.url, TestTT.username, TestTT.password);

I wonder if this JDBC Connection is a TCP/IP connection on the backend? If this is not a TCP/IP connection, how can I make a connection with TimesTen via TCP/IP protocol?

dsn:my_ttdb configuration likes:
[my_ttdb]
Driver=/home/tttest/TimesTen/tt1122/lib/libtten.so
DataStore=/home/tttest/ttdata/database/my_ttdb
LogDir=/home/tttest/ttdata/logs
PermSize=40
TempSize=32
DatabaseCharacterSet=ZHS16GBK
OracleNetServiceName=orcl

View 12 Replies View Related

TimesTen In-Memory :: Limit For Size Of A Table

Oct 24, 2013

I'm using TimesTen Release 11.2.1.9.8 (64 bit Linux/x86_64)  1. is there any limit in size for a single table. How much a table size can be increased? 2. Is there any limit in number of records in a table?

View 2 Replies View Related

TimesTen In-Memory :: Configure Redundancy For Propagator?

Jun 28, 2013

,Im having following replication scheme: M1,M2 and M3 are multimaster replicated datastores.These three datastores will replicate its data to a node which is going to act as a Propagator.The Propagator will then replicate data to a set of subscribers.  Question:-------------

Can we configure the Propagator to be redundant.ie, can we configure an additional propagator  which will act as redundant and replicate to the same set of subscribers?

View 11 Replies View Related

TimesTen In-Memory :: No Support For Trigonometric Functions

Sep 2, 2013

We cache oracle 11g2 data in timesten 11.2.2.5.0   ( IMDB ) We can't find any trigonometric functions like  cos(x), sin(x)  or so in timesten. Does that means timesten doesn't support trigonometric functions?

View 2 Replies View Related

TimesTen In-Memory :: Using Propagators To Replicate To Many Subscribers

Oct 9, 2012

The document says "Propagators are also useful for distributing replication loads in configurations that involve a master database that must replicate to a large number of subscribers".

Link [URL]........

My question is how do we define this " large number ". Is 5 a large number or 10 a large number ? I've a bidirectional legacy replication scheme wherein a node replicates to 10 other nodes. Should i introduce Propagator between these nodes.

View 3 Replies View Related

TimesTen In-Memory :: How To Create DB Cache Groups

Jul 22, 2013

Is it possible to use TimesTen to create cache groups that have different table structures from original Oracle tables based on relational conditions?

View 3 Replies View Related

TimesTen In-Memory :: Query To Retrieve Previous Day Data

Jun 13, 2012

I would like to have a query which should fetch previous day records from column which is having timestamp data type.

select mdn from user_table where updatetimestamp > trunc(sysdate) - INTErVAL '24' HOUR;

But this gives output not for previous day, but all records which are 24 hrs less than current day. How to get records for previous day based on column having timestamp data type.

View 4 Replies View Related

TimesTen In-Memory :: Execute Statement SELECT CURRENT_DATE FROM DUAL On 11.2.2?

Sep 24, 2013

We are trying to execute a statement SELECT CURRENT_DATE FROM DUAL on Timesten 11.2.2  . It throws error unknown referenced column error. Command> select current_date from dual; 2211:

Referenced column CURRENT_DATE not foundThe command failed. But the following doc shows the support. 

TimesTen PL/SQL Support: Reference Summary CURRENT_DATE function

Returns the current date in the session time zone. YIn TimesTen this returns the current date in UTC (universal time). TimesTen does not support local time zones.

View 4 Replies View Related

TimesTen In-Memory :: Manual Refresh Cache Groups From Oracle DB?

May 3, 2013

we want to truncate a oracle Table in the Oracle DB. After the truncate the fact table will be loaded again. After the new load in the fact table we want to tell the times ten db to refresh the cache table. The cache Table is a user owned read-only cache group with no autorefresh. We want to tell times ten in a PL/SQL Block from Oracle DB that starts the refresh from the cache group in times ten. The refresh should not be a autorefresh because the refresh should only start if the fact table will new loaded after the truncate.

View 1 Replies View Related

TimesTen In-Memory :: Ttisql - Execute Prepared Statements In Script?

Dec 13, 2012

I want increase speed of importing data using ttisql. My script contains about 12k simular MERGEs. Can I prepare this state,ent once and later substitute params from script?

View 1 Replies View Related

TimesTen In-Memory :: Multiple Active Standby Pairs On Same Pair Of Hosts

Dec 25, 2012

I have already created an active standby pair(without cache group) and managed by Oracle Clusterware and it work fine.

Now ,I create another DSN and I also want to create another active standby pair on the same 2 hosts.

I try to setup and reference this setting:

[URL]...

But I get error message in ttcwmessage :

TT17013 The default hostname cannot be set to host_name because a local host of host_name is currently in use

Is it possible that I can create more than one A/S pair(with different DSN) ? Or any other solution? !

TimesTen version:11.2.2.3.3 (64 bit Linux/x86_64)

View 5 Replies View Related

TimesTen In-Memory :: How Big Heap Size Of JVM To Be Set For Java Application When Enabling Direct Model

Nov 24, 2012

For applications and Timesten databases on the same server we can use direct model to gain the base performance. But I want to know that how big heap size of JVM to be set for my java application when enabling direct model?

Does my application need more head memory when direct model than other local communication protocols, such as Unix domain socket or IPC? Supposing my Timesten database takes 12GB memory from OS, does it mean I need specify the same size for JVM heap(-Xmx12G)?

View 2 Replies View Related

TimesTen In-Memory :: Cannot Connect To Server With Ttisqlcs / Failed To Retrieve IP Address Of The System

Nov 16, 2013

I installed timesten server and client on different machines in LAN, but with the same user and group - ttadmin:ttgroup When I tried to connect to server with ttisqlcs -connStr "DSN=sampleCS"The output gave me error messages as below connect "DSN=sampleCS";S1000: Failed to retrieve IP address of the system. System error: -2The command failed.Done. The related part in sys.ttconnect.ini is set as below 

[192.168.0.206]Description=TimesTen ServerNetwork_Address=192.168.0.206TCP_PORT=53397 

And the

sys.odbc.ini [ODBC Data Sources]sampleCS=TimesTen 11.2.2 Client Driver [sampleCS]TTC_SERVER=192.168.0.206TTC_SERVER_DSN=nredb_ds 

What does it mean by "retrieve IP" ?Does it try to resolve IP by the hostname even when I already gave it the ip address?By the way I can ping 192.168.0.206 and telnet at port 53397 with no problem.

View 4 Replies View Related

Data Guard :: Unable To Receive Result From A Database

Mar 21, 2013

standby db /primary db in sync managed recovery working but

broker
show configuration
Connected.
DGMGRL> show configuration

Configuration - GenesisDR

Protection Mode: MaxAvailability
Databases:
orcl - Primary database

Warning: ORA-16629: database reports a different protection level from the protection mode

standby - Physical standby database
Error: ORA-16664: unable to receive the result from a database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR
DGMGRL>

View 3 Replies View Related

TimesTen In-Memory :: Error 802 / 6220 / Permanent Data Partition Free Space Insufficient

Oct 29, 2012

try to evaluate it as IMDB cache.I am facing this error repeatedly. I have increased perm size from 6.25 GB to 10 GB.After inserting about 460.000 rows I get the error again. Is it possible that 460.000 rows need 3.75 GB space?

In Oracle database these rows occupy about 200 MB space.

View 2 Replies View Related

Data Guard :: ORA-16664 / Unable To Receive Result From Database

Oct 17, 2013

I decided to configure our current standby databases for administration in EM 12c via the "Manage an existing standby database with Data Guard broker". The first one went off without issue but on the second I got "ORA-16664: unable to receive the result from a database". I've scoured through everything and confirmed, more than once, that the tnsnames, listener and pwfile are all good to go. I can tnsping everything from both servers. The sby1 database is functioning fine and all log files are being transported and applied without issue from primary to standby, on different servers. I can connect via sqlplus to each database from opposite servers. I  don't understand how I can do the below in DGMGRL:The listener doesn't not know of service requested (PRI1) and is unreachable in the first connect, but then I can turn around and successfully connect to PRI1 without issue? 

DGMGRL> connect sys@sby1Password:Connected.DGMGRL> show configuration; Configuration - PRI1_ora-9002.xxxx   Protection Mode: MaxPerformance  Databases:    PRI1 - Primary database    sby1 - Physical standby database Fast-Start Failover: DISABLED Configuration Status:ORA-12514: TNS:listener does not currently know of service requested in connect descriptorORA-16625: cannot reach database "PRI1"DGM-17017: unable to determine configuration status DGMGRL> connect sys@pri1Password:Connected.DGMGRL> show configuration Configuration - PRI1_ora-9002.xxxx   Protection Mode: MaxPerformance  Databases:    PRI1 - Primary database    sby1 - Physical standby database      Error: ORA-16664: unable to receive the result from a database Fast-Start Failover: DISABLED Configuration Status:ERROR DGMGRL> ;

View 12 Replies View Related

TimesTen In-Memory :: OracleDataReader - Object Reference Not Set To Instance Of Object

Jan 25, 2013

I have a problem with executing oracleCommand.ExecuteReader() method. Whatever I try it always returns null and it won't create OracleData reader object. I'm using ODAC 1120320_x64 for .net 4.0 and timesten112241.win64. Don't sure what to do. Debugger is showing strange thing in OracleConnection object : ConnectionState = Closed, but output of ttStatus shows connection to TimesTen data store and ExecuteNonQuery() command works just fine with or without (in or out) parameters. But when I try to execute some query with multile output such as select *, I can't get any result.

I also have a strange problem with connection.Open() When I execute Open() i throws AccessViolationException that can be handled with [Handle ProcessCorruptedStateExceptions] attribute, but connection is established after that and my application works fine until I try to instance OracleDataReader object.

Here is the code:
OracleCommand select = null;
OracleDataReader reader = null;

select = new OracleCommand(selectStmt, connection);
select.CommandType = CommandType.Text;
try
{
reader = select.ExecuteReader(); // this line throws NullReferenceException
if (reader.HasRows)
{
[code]....

Just to mention, I tried it with different queries (pl/sql, plane sql, stored procedure) and all of them works fine in SQL Developer, but not in app.

View 10 Replies View Related

TimesTen In-Memory :: AWT Cache Group With Cache Awt Parallelism

Jul 10, 2012

I have some question.

TTversion : TimesTen Release 11.2.2.3.0 (64 bit Linux/x86_64) (tt112230:53376) 2012-05-24T09:20:08Z

We are testing a AWT cache group ( with CacheAwtParallelism=4 ).

Application(1 process) to the DML generates to TimesTen(DSN=TEST).

At this point, Are delivered to the 4 parallel DML?

[TEST]

Driver=/home/TimesTen/tt112230/lib/libtten.so
DataStore=/home/TimesTen/DataStore/TEST/test
PermSize=1024
TempSize=512
PLSQL=1
[code].......

View 7 Replies View Related

Unable To Allocate Shared Bytes Of Memory

Sep 21, 2010

How to overcome from the below error.

Database Error-ORA-04031:unable to allocate 76320 bytes of shared memory("shared pool","SELECT/*+Norewrite*/DIST...","sql area","kkmevw:view_txt")

Here I attached that error.

Attached File(s)

Disco_Error_1.jpg ( 49.03K )
Number of downloads: 3

View 2 Replies View Related

SQL & PL/SQL :: Unable To Allocate 104 Bytes Of Shared Memory

Mar 9, 2012

When i try to extract create statement of table i get below error message.

SQL>
SQL> set heading off
SQL> set pagesize 0
SQL> set long 1000000
SQL> set feedback off
SQL> select
2 dbms_metadata.get_ddl( 'TABLE','CATALOG_TBL','JACK')
3 from
4 dual
5 /

ERROR:

ORA-04031: unable to allocate 104 bytes of shared memory ("shared pool",

"SELECT
/*+rule*/ SYS_XMLGEN(...","SQLA^fc8f5280","qecsub : qkxrPXformQbc")
ORA-06512: at "SYS.DBMS_METADATA", line 2625
ORA-06512: at "SYS.DBMS_METADATA", line 2668
ORA-06512: at "SYS.DBMS_METADATA", line 2983
ORA-06512: at "SYS.DBMS_METADATA", line 3897
ORA-06512: at "SYS.DBMS_METADATA", line 5678
ORA-06512: at line 1

Note:
----
I am executing this command from another user 'DEMO' which has got DBA privilege.

how to fix this error and extract the create table statement.

View 5 Replies View Related

Unable To Allocate 264 Bytes Of Shared Memory

Jan 13, 2013

I'm getting the following error when i shutdown or startup the db,

SQL> shutdown immediate;

ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 264 bytes of shared memory ("shared pool","unknown object","PCUR^18465427","kglob")

View 1 Replies View Related

ORA-04031 - Unable To Allocate 32 Bytes Of Shared Memory

Jun 19, 2013

I am seeing the following error message in alert.log (ORA-04031: unable to allocate 32 bytes of shared memory ) and my database goes into hung state and wont let any new sessions to connect and old sessions just hung with no response. i have to kill the instance to come out of this problem.

I am running 11.2.0.3 on AIX and have memory_target=35GB. I would like to know what approach to take to find out the root cause of this? btw - does AWR show if memory was under pressure and what SQL's were consuming more memory just before the problem surface?

View 2 Replies View Related

SQL & PL/SQL :: ORA-04031 / Unable To Allocate Bytes Of Shared Memory

Jun 17, 2011

If I am log in through crystal reports , I am getting the following error.

ORA-04031 unable to allocate bytes of shared memory("","","","").

If I log in through TOAD from back end I am not getting any error.

View 14 Replies View Related

ORA-04031 - Unable To Allocate 104 Bytes Of Shared Memory

Aug 30, 2012

Let me put my current Environment Info.

Single Laptop Machine of 16GB RAM.
Assigned 13GB to VM.

I have installed Oracle Database 11g. 11.2.00. When I try to access my application many times I received below error

• Error:
“”Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLExceptio n: weblogic.common.resourcepool.ResourceDeadException : Could not create pool connection. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAlloca te")
[code]......

Even when above error occur I have 7GB free JVM so JVM is not an Issue.

•I have updated Max Capacity of oimOperationsDB =100,oimOperdationDB, oimJMSStoreDS=80,SOADATAStore =80. But still I have error

• ERROR::
• ““Aug 30, 2012 3:24:10 PM EST> <Warning> <oracle.integration.platform.blocks.event.saq> <SOA-31013> <Error handling message (rolling back).
java.sql.SQLException: ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAlloca te")
ORA-06512: at "SYS.DBMS_AQ", line 335
ORA-06512: at "DEV_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY", line 14”
[code]......

I have modified Shared_pool_size,large_pool_size. Content of my modified Pfile is as below.

o orcl.__db_cache_size=822083584
o orcl.__java_pool_size=2777216
o orcl.__large_pool_size=56777216
o orcl.__oracle_base='/home/oracle/app/oracle'#ORACLE_BASE set from environment
o orcl.__pga_aggregate_target=805306368
o orcl.__sga_target=1174405120
o orcl.__shared_io_pool_size=0
o orcl.__shared_pool_size=601989888
o orcl.__streams_pool_size=0

What’s value of parameter I need to set for datastore, pfile ? (I have 13GB of memory).

View 8 Replies View Related

ORA-04031 Unable To Allocate 16 Bytes Of Shared Memory

May 17, 2013

Windows 2003 Server Enterprise Edition, Service Pack 2. 3.5GB RAM.Two Oracle Databases running on this server, one not heavily used. On the database i am concerned with it is 10.2.0.3.0.

I have just started to look at this database and am seeing various things in the alert log and have had user error messages as well.Initially when i started looking at this server it was running with quite a small SGA (600MB) and the memory_target_advice was saying to take it to 1000MB.(PGA is around 200MB)

In January, before i looked at it, it started to throw:

ORA-04031 unable to allocate 16 bytes of shared memory ("shared pool","........", "sql area", "tmp") These would occur regularly and mostly during nightly processes, it seems, and thus not bubbling up to users.Having switched the SGA_MAX_SIZE to 1GB a new set of errors starts to appear in the alert log:

ORA-27301: ..... Not enough storage is available to process this command
ORA-27302: ..... ssthrddcr

At the same time the ORA-04031 errors start to bubble through to the users. Before i could return to the scene of the crime someone else set the SGA back to 600MB and the error messages stopped. However the ORA-04031 message start to reappear in the alert log. My questions are many and, mostly, from a lack of knowledge ;) In particular:

1. Why would increasing the SGA lead to a different memory error? I would assume this would have something to do with the amount of memory a 32bit OS will allow a single process to address but the PGA+SGA is only 1200MB.

2. How does a ORA-273xx error end up with a ORA-04031 being shown to the users? I would look at the listener log but its over 2GB!!!

View 7 Replies View Related

ORA-27123 - Unable To Attach To Shared Memory Segment

Oct 11, 2012

we are having a test server in bank environment.

Details:

IBM p series servers
AIX 5.3
Server memory : 16G
there are 2 instances on this server.
1. Near DR - 9840M
2. Test server - 1344M
Rest is for server.
Oracle 10.2.0.3.0 - Production

2 days ago we are running a stored procedure on this test server. After some time DB gave this error and stored procedure stopped.After that we were unable to login through Oracle Client Software. Whenever we try to login to this DB through client software, it gives following errors.

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
IBM AIX RISC System /6000 Error: 13: Permission denied

We tried to shut the DR database and then login but still gives error..

View 11 Replies View Related

11G R2 On Win 2008 - Unable To Allocate 32 Bytes Of Shared Memory

Jun 8, 2012

on 11G R2 on Win 2008,

We had the following error in alertlog repeatedly from 5 PM to 10 PM :

ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT VERSION FROM PSVERSIO .....Since MEMORY_TARGET is defined in spfile then shared pool is managed automatically.

Then what to do to avoid this error in future ?

View 3 Replies View Related







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