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

Networking And Gateways :: Stand Alone 11gR2 Database - Listener Configuration

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

Data Guard :: Stand By REDO Configuration

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

Backup & Recovery :: Re-syncing Physical Stand By DB

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

Data Guard :: Upgrade Stand By To Primary Version

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

Application Express Listener :: Stand Alone Mode To Listen Two Databases Simultaneously?

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

SQL & PL/SQL :: Difference Between Stand Alone Function And Function Declared In A Package?

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

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

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

Convert Oracle Database (schema Data) To Postgresql Database

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

Forms :: Use MS Sql Server Database With 6i Without Oracle Database Install

Feb 6, 2010

Can we use M.S Sql Server Database with Forms 6i with out oracle database install.

View 1 Replies View Related

Migrate MySQL Database Into Oracle Database?

Sep 11, 2003

I'm trying to migrate a mySQL database into an Oracle database.

View 7 Replies View Related

Networking And Gateways :: Oracle Database Gateway Installing On Oracle 8?

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

PL/SQL :: Oracle SQL Template To Create Re-usable DDL / DML Scripts For Oracle Database

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

Oracle 11g - Global Database Name Value?

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

Database Redundancy With Oracle SE ONE?

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

Importing Of Oracle Database?

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

Oracle Database Overloaded

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

11.2 - How To Mount Oracle Database

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

Database Duplication With Different DB ID And Oracle SID

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

Download Oracle Database 10g

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

Oracle 9i With PHP - Connectivity To Database

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

SQL & PL/SQL :: Sending SMS Through Oracle Database

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

SQL & PL/SQL :: How To Insert PDF Into Oracle Database

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

ORACLE - While Connecting To Database?

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

Replicate Oracle XE Database In 10G?

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

SQL & PL/SQL :: Read Only Row In Database Oracle?

Apr 25, 2012

row can be marked as read only in Oracle database

View 7 Replies View Related

SQL & PL/SQL :: Possible To Create More Than One Database In Oracle

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

Monitoring Oracle Database

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

Oracle Database Cloning From ASM To Non-ASM

Jan 23, 2013

I have to do oracle database cloning from asm to non-asm.

View 4 Replies View Related

ODP.NET :: Connect To Database Oracle With C#

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







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