Tuesday, January 24, 2017
Important links about TimeSten 11g
>Comparation about SSD and HDD
http://www.databasejournal.com/features/oracle/oracle-11gr2-io-performance-tuning-solid-state-drives-1.html
>Tutorials about installation an configuration
http://www.oracle.com/technetwork/database/timesten/overview/timesten-tutorials-demos-1443972.html
>Initial configuration
http://download.oracle.com/otn_hosted_doc/timesten/1122/quickstart/html/admin/admin.html
>Installation over linux
http://vtgdb.blogspot.mx/2016/03/install-oracle-timesten-step-by-step.html
http://gerardnico.com/wiki/exalytics/timesten
http://gerardnico.com/wiki/timesten/tnsnames.ora#tns_admin
Best regards,
Thursday, January 12, 2017
How to solve pluggable problem in 'Continuous Query Notification'?
A required feature for CQN registration of store procedure is that the database where is creating objects should be not pluggable an error will appear like below:
65131. 00000 - "The feature %s is not supported in a pluggable database."
*Cause: An attempt was made to use a feature that is not supported in a
pluggable database.
*Action: Do not use this feature in a pluggable database.
The solution is to create a new database with not PDB configurate that make enable pluggable parameter not appear in ora file.
Another problem is when you are doing a registration of a store procedure via CQN a problem will occur with other DML executed after by CQN registration, the error will be as the follow text:
ORA-29973: Unsupported query or operation during change notification registration
Important links:
65131. 00000 - "The feature %s is not supported in a pluggable database."
*Cause: An attempt was made to use a feature that is not supported in a
pluggable database.
*Action: Do not use this feature in a pluggable database.
The solution is to create a new database with not PDB configurate that make enable pluggable parameter not appear in ora file.
Another problem is when you are doing a registration of a store procedure via CQN a problem will occur with other DML executed after by CQN registration, the error will be as the follow text:
ORA-29973: Unsupported query or operation during change notification registration
Important links:
- http://oraerrormsgs.blogspot.mx/2012/05/ora-29973-unsupported-query-or.html
- http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_cqnotif.htm#CIHBBFDD
- https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm#BGBGAGEF
- https://jsao.io/2015/02/real-time-data-with-node-js-socket-io-and-oracle-database/
- http://stackoverflow.com/questions/33388155/alternatives-for-continuous-query-notifications-in-oracle-12c-cdb-pdb-setup
- https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9522537800346597791
- https://technology.amis.nl/2015/05/11/invoke-a-rest-service-from-plsql-make-an-http-post-request-using-utl_http-in-oracle-database-11g-xe/
Subscribe to:
Posts (Atom)