How To Determinate Oracle 12C Is A Container Database Or Not
Jul 15, 2013How to determinate connected 12C is a container database or not?
View 6 Replies
ADVERTISEMENT
Oracle 12c - Container And Pluggable DB Config
Oct 19, 2012We've all heard the news about the new 12c capability to have a container database hosting multiple pluggable database instances.
This obviously will provide significant reduction in overhead on systems (like Exadata) where we'd like to host multiple databases, but can't consolidate them due to conflicts that prevent them running under the same instance (public synonyms / dblinks, schema name collision, etc). Not to mention the effort required to get different application databases to co-exist on the same DB instance ... which in and of itself can be a major project.
My question - does the container database need to have the same character set as the pluggable databases?
If not, this still presents a limitation, as there are numerous vendors of COTS applications that don't (or won't) support ALT32UTF8, which is what we're building all our bespoke applications on.
Forms :: Export Files From OLE Container
Jun 15, 2010how do I export files ole container forms forms 6i to 10g? OLE container I keep in the database in a BLOB field.
I want to watch it in Forms 10g using WEBUTIL or export to disk.
Forms :: Treeview With Images And Checkboxes With OLE Container?
Jun 4, 2009I have an issue with an OLE-Container (ITreeView).
I have already a form with the treeview (database no necessary) with some nodes added manually.
All this nodes have checkbox and style properties, drag and drop (drag automatic and drop manual).
I added also to the form an OLE-Container for the listImage and put into the container the images that i need.
I put checked the father and when it is true then a variable into the declaration of the check of the childrens change and the child nodes are checked too, but when i do it manually nothing happened.
What I want to do is the next thing: I want to be able to drag and drop in every place of my tree to change the positition between the nodes of the node father and to change it also with childnodes of other parent. To Put an Image next to each node (how to call the images that are inside of my imagelist) When I checked the parent then check all the child nodes of it.
Application Express :: Button With Pre-element Text Is Given A Container Div?
Aug 8, 2013Just installed 4.2.2.00.09 and imported a workspace and an application. Worked fine.I noted a page display difference when compared to the exported application (4.1.0.00.32). I have (so far) found this:If I have a button with Pre Element Text set to <div class="dummy"> and Post Element Text set to </div>, Apex generates an extra div around it all.If my button was named P1_SUBMIT I end up with
<div id="P1_SUBMIT_CONTAINER">
<div class="dummy"> <input type="button" value="Search" id="P1_SUBMIT" /></div>
</div>
Is it possible for me to turn this extra div off?
Application Express Listener :: Standalone Vs Deploy To J2EE Container
Jan 16, 2013I planing use latest APEX listener and Apache with mod_jk on new server.I wonder what are pros and cons use APEX listener standalone comparing when deployed to J2EE container e.g. Glassfish? URL.....
View 4 Replies View RelatedData Guard :: Apply Patches On Oracle Database With Logical Standby Database?
Apr 22, 2011I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site
Convert Oracle Database (schema Data) To Postgresql Database
Oct 11, 2012i want to convert oracle database(schema data) to postgresql database
which tool would be best and url to download and steps to convert from one database to another ?
Forms :: Use MS Sql Server Database With 6i Without Oracle Database Install
Feb 6, 2010Can we use M.S Sql Server Database with Forms 6i with out oracle database install.
View 1 Replies View RelatedMigrate MySQL Database Into Oracle Database?
Sep 11, 2003I'm trying to migrate a mySQL database into an Oracle database.
View 7 Replies View RelatedNetworking And Gateways :: Oracle Database Gateway Installing On Oracle 8?
May 17, 2011But i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.
The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.
I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.
PL/SQL :: Oracle SQL Template To Create Re-usable DDL / DML Scripts For Oracle Database
Jun 13, 2012I have a requirement to put together a Oracle SQL template to create re-usable DDL/DML Scripts for Oracle databases.Only the Oracle DBA will be running the scripts so permissions is not an issue.
The workflow for any DDL is as follows:-
1) New Table
a. Check if the table exists from the system/admin views.
b. If table exists then give message "Table Exists"
c. If table does not exist then execute DDL code
2) Add Column
a. Check if Column exists for a given table from system/admin views
b. If column exists in the specified table,
b1. backup table.
b2. alter table to make changes to the column
b3. verify data or execute dml script convert from backup to the new change.
c. If Column does not exist
c1. backup table
c2. alter table to add column
c3. execute dml to populate column with default value.
The DML scripts are for populating base tables with data required for business operations.
3) Add new row
a. check if row exists by comparing old values of each column with new values to be added for the new record.
b. If exists, give message row exists
c. If not exists, add new record.
4) Update existing record (We have createtime columns in these tables so changes can be tracked)
a. check if row exists using primary key.
b. If exists,
b1. deactivate the record using the "active" column of the table
b2. Add new record with the changes required.
c. If does not exist, add new record with the changes required.
Oracle 11g - Global Database Name Value?
Sep 22, 2011When I installed Oracle 11.g I set 'GlobalDataBaseName' ("orcl.net").SID was "orcl". from where can I invoke 'GlobalDataBaseName' value ?
View 1 Replies View RelatedDatabase Redundancy With Oracle SE ONE?
Nov 5, 2012I'd like to get database redundancy with Oracle Standard Edition One. currently have one physical database server and are considering getting a second physical database server.
What's the best way to achieve that without going to Oracle Standard Edition using RAC?
Importing Of Oracle Database?
May 30, 2011Actually I am using Oracle 9i in Windows Operating System. Now I want to move to my entire Oracle Database to Oracle 11g in Linux version. What are all the correct steps to do this. I am not a DBA.
View 1 Replies View RelatedOracle Database Overloaded
Mar 5, 2011In my Production server, Database size increased very high due do to logs generated in a table called "Process Activity". And the table size is 50GB.
We deleted the data from the table "Process Activity". And still the table size and Database size remain same. Space not released by DB. One of my friend, recommended me to sync the oracle DB to release the space. how to synchronize the DB to release space.
11.2 - How To Mount Oracle Database
Jun 10, 2013While I was trying to configure an Oracle DB called "NW6" using the Database Configuration Assistant, I have Oracle 11.2 database installed on a Windows 2008 Server, the configuration wizard thrown an error : ORA-01507:database not mounted
So I am not able to successfully complete the DB configuration. Also I tried to test the service using the net configuration assistant, it throws an error: ORA-27101 shared memory realm does not exist.
Database Duplication With Different DB ID And Oracle SID
Sep 3, 2010I have the following question:
I try to duplicate a database on Host B with ORACLE_SID=hostb from an offline full backup plus archive log backup was taken from Host A with ORACLE_SID=hosta. Host A and Host B cannot communicate between them.
I don�t want to make a full restore of database, i want to make a duplicate database from that offline backup.
I need the duplicate database must be run with different ORACLE_SID and different DBID.
PD: I was reading the Oracle Documentation about that but i can�t find a step by step guide to follow.
Environment
Oracle 11gr2 with a Linux OS on x86_64 on host A and host B.
Download Oracle Database 10g
Aug 3, 2012I need download the Oracle 10g to do some migration tests, but isn't not available in oracle website.
View 1 Replies View RelatedOracle 9i With PHP - Connectivity To Database
May 2, 2007I would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?
View 3 Replies View RelatedSQL & PL/SQL :: Sending SMS Through Oracle Database
Sep 16, 2006I have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms
How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed .
SQL & PL/SQL :: How To Insert PDF Into Oracle Database
Mar 8, 2013how can i insert .pdf file into my oracle database.
insert statement how can i insert this pdf file into my oracle database using insert statement.
ORACLE - While Connecting To Database?
Dec 8, 2010I am building the Oracle on RHEL 5(on Virtual machine with fixed disk space). I could install, after configuring and tried to connect to the database using "sqlplus system" on the command prompt(logged in as root), I get the following error message:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Replicate Oracle XE Database In 10G?
Mar 23, 2007I want to replicate my Oracle XE database in Oracle 10G. Is their a 'simple' way to do that? I know that XE does not have server backup.
View 2 Replies View RelatedSQL & PL/SQL :: Read Only Row In Database Oracle?
Apr 25, 2012row can be marked as read only in Oracle database
View 7 Replies View RelatedSQL & PL/SQL :: Possible To Create More Than One Database In Oracle
Dec 6, 2010I have installed oracle 9i in my PC.I would like to know the answer for the following questions.
1.Is it possible to create more than one database in oracle? If so, can it be used simultaneously through sqlplus?
2.If it is not , how can I move from one database to another?
Monitoring Oracle Database
Aug 20, 2010Whats is the best Tool for monitoring ORACLE DBs ?
I've heard about Toad, Spotlight, and of course The EM from Oracle..but i know there some other tools that i maybe don't know.
Oracle Database Cloning From ASM To Non-ASM
Jan 23, 2013I have to do oracle database cloning from asm to non-asm.
View 4 Replies View RelatedODP.NET :: Connect To Database Oracle With C#
Oct 19, 2012I am trying to develop a web application with C # VS.net, my application is to connect to an Oracle database on a server (LAN), the problem I want to connect to the database without install oracle or ODP on my client machine.
View 1 Replies View RelatedStand-alone EM For Oracle 12c Database
Sep 2, 2013I am exploring the features of Oracle 12c.After having installed the databases as "general purpose", I don't see in $ORACLE_HOME/bin no utility like emctl to manage the Stand-alone Console (EM) for that specific database. Is there such a utility with Oracle 12c?
View 3 Replies View Related