Stand-alone EM For Oracle 12c Database
Sep 2, 2013
I 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
ADVERTISEMENT
Sep 10, 2013
I have stand alone 11gR2 database. Do I need to configure the listener and have the tnsnames.ora file entries under Grid home and start the listener from Grid home or do I need to start from Oracle database home?
View 5 Replies
View Related
Jun 5, 2013
DB Version- 11.2.0.3
For the maximum protection and maximum availability as well as to enable Real Time Apply we need to setup the standby redo log group. My question is what would be the standby redo log group configuration in case if we setup single instance standby database for 2-Node RAC primary database. Do we require a separate standby redo thread for each primary online redo thread or RFS use the Multiple Standby redo group from the same thread to receive the redo changes from both the node ?
View 3 Replies
View Related
Aug 28, 2012
One of my physical stdby DB's have been offline for a while due to some disk issues,l which were rectified. I don't have all the .arc files dating back from when the stdby went off line.
Is there an RMAN command / script I can use to re-instantiate the stby DB?
View 4 Replies
View Related
Feb 6, 2013
Mistakenly I have configure dataguard on different versions. Primary is 11.2.0.3.0 and Stand By is 11.2.0.1.0. Log shipping is perfectly working, but cannot put Stand By in read only mode.
View 3 Replies
View Related
Jun 21, 2012
started using APEX recently and am trying to configure the APEX Listener in standalone mode to listen to two databases simultaneously. Is it possible?
View 2 Replies
View Related
Mar 11, 2010
What is the Difference between a Stand Alone Function/Procedure & a Function/Procedure declared in a Package.
View 2 Replies
View Related
Apr 22, 2011
I 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
View 2 Replies
View Related
Oct 11, 2012
i 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 ?
View 2 Replies
View Related
Feb 6, 2010
Can we use M.S Sql Server Database with Forms 6i with out oracle database install.
View 1 Replies
View Related
Sep 11, 2003
I'm trying to migrate a mySQL database into an Oracle database.
View 7 Replies
View Related
May 17, 2011
But 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.
View 1 Replies
View Related
Jun 13, 2012
I 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.
View 17 Replies
View Related
Sep 22, 2011
When I installed Oracle 11.g I set 'GlobalDataBaseName' ("orcl.net").SID was "orcl". from where can I invoke 'GlobalDataBaseName' value ?
View 1 Replies
View Related
Nov 5, 2012
I'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?
View 7 Replies
View Related
May 30, 2011
Actually 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 Related
Mar 5, 2011
In 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.
View 3 Replies
View Related
Jun 10, 2013
While 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.
View 9 Replies
View Related
Sep 3, 2010
I 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.
View 13 Replies
View Related
Aug 3, 2012
I need download the Oracle 10g to do some migration tests, but isn't not available in oracle website.
View 1 Replies
View Related
May 2, 2007
I 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 Related
Sep 16, 2006
I 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 .
View 7 Replies
View Related
Mar 8, 2013
how 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.
View 24 Replies
View Related
Dec 8, 2010
I 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
View 2 Replies
View Related
Mar 23, 2007
I 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 Related
Apr 25, 2012
row can be marked as read only in Oracle database
View 7 Replies
View Related
Dec 6, 2010
I 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?
View 3 Replies
View Related
Aug 20, 2010
Whats 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.
View 1 Replies
View Related
Jan 23, 2013
I have to do oracle database cloning from asm to non-asm.
View 4 Replies
View Related
Oct 19, 2012
I 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 Related