Install Multiple Versions Of Oracle Databases 10GR2 And 11GR2 In A Single Node?

Oct 28, 2010

ORACLE DBA
EXPERTS

�I can install multiple versions of Oracle databases 10GR2 and 11GR2 in a single node using a unique Oracle ASM single instance?

View 6 Replies

Setup Oracle 11gR2 Single Node At Linux?

Jan 11, 2011

I need to setup Oracle 11gR2 single node @ Linux RHat 5 64-bit for long performance tests, huge loads, high speeds, a lot of transactions, having a good scalability, etc.

It's not a production server, but for strong system/volume tests.

CPU
Motherboard
Memory
HDD
Network

View 2 Replies View Related

Upgrade :: 10gR2 Single Instance To 11gR2 RAC?

Aug 3, 2012

upgrading a single instance 10.2.0.2 database of approx size 2TB to 11.2.0.3 rac 2 node db on linux.

View 3 Replies View Related

Install 11gR2 RAC On CentOS 5.5 / Root.sh Failed On First Node

Nov 1, 2010

I am trying to install ORACLE 11gR2 RAC on CentOS 5.5 .

when run root.sh on first node. I am gettign 2/3 failed command lines but the end went successful

=======================================================================
ohasd is starting
ADVM/ACFS is not supported on centos-release-5-5.el5.centos
...
add nodeapps -n perflabhp03 -A perflabhp03-vip/255.255.254.0/eth0 on node=perflabhp03 ... failed
...
PRCR-1001 : Resource ora.net1.network does not exist
add scan=perflab-cluster-scan ... failed,
Configure Oracle Grid Infrastructure for a Cluster ... failed
...
'UpdateNodeList' was successful.
=========================================================================

Because of this output, when see the ./crsctl stat res -t , it showing LISTENER offline for perflahp03, and I can not see any status line for "perflabhp03-vip " and "Scan-listener".

Do I need to reinstall the entire cluster setup because of VIP issue?

View 1 Replies View Related

SQL & PL/SQL :: Give Grant To Schema Of Different Versions Of Oracle Databases?

Aug 8, 2012

I have a task assigned to "grant select on sys.link$" to a user which exists on 500 different databases.

This needs to be done in Oracle database.

View 6 Replies View Related

Real Application Clusters :: 2 Node - Multiple Databases Supported

May 15, 2013

if multiple databases on one 2 nodes RAC is supported ? Explain me the inconvenient to have multiple databases on RAC ?

View 14 Replies View Related

Oracle Database Migration From 9iR2 / 10gR2 To 11gR2

Apr 22, 2013

Which is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.

Current Environment
Server1
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 9.2.0.8 (32 bit)
Average Db Size: 600Gb
RAc Configuration: No
Server2
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 10.2.0.3 (64 bit)
Average Db Size: 600Gb
RAC Configuration: No

Proposed Environment
Server1 and Server2
Operating System: Sun Solaris 10
Oracle Database: Oracle Database Enterprise Edition 11.2.0.3 (64 bit)
RAC Configuration: No
Hardware is New : Yes

View 2 Replies View Related

Server Administration :: Migration Of Oracle 10gR2 To 11gR2?

Jun 23, 2010

I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.

For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?

OS; solaris sparc 10

Oracle 10g: 10.2.0.1.0

oracle 11g: 11.2.0.1.0

View 1 Replies View Related

Migrate From Oracle 10gR2 In Windows To 11gR2 In Linux

Jun 22, 2012

Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:

1.     need to expdp all schemas/users from oracle 10gR2 in Windows,
2.     then impdp each schema/user into oracle 10gR2 in Linux first,
3.     then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4.     Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?

Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?

View 5 Replies View Related

Multiple Oracle Homes And 2 Versions Of Listener

May 19, 2010

Dose any shell script that would be able to set the oracle_home & the listeners based on the versions of software on the box?

View 1 Replies View Related

Application Express :: Oracle 11gr2 RAC 2 Node

Nov 2, 2012

Can i setup 2 node oracle RAC using vmware server in a single laptop..? cpu-intel i3 memory 4GB.

View 1 Replies View Related

Windows :: Unable To Install Oracle 11gR2 On Win 7 Professional?

Mar 28, 2012

I am trying to install Oracle 11g R2 on Windows 7 professional at the time of database creation they give error.

ORA-12638:Credential retrival failed.

View 9 Replies View Related

Installation :: Oracle 11gR2 Install Through Response File

Sep 28, 2012

How can i set db home name at the time of installation of oracle 11.2.O.3 .

View 3 Replies View Related

RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment

Jan 24, 2011

We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?

View 3 Replies View Related

Windows :: How To Install 10gr2 In Win 7

May 1, 2010

Is it possible to install 10gr2 in windows 7?

View 12 Replies View Related

RAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?

Sep 13, 2012

I would like get more details about single node RAC.. What is single Node RAC?..

1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...

is there any advantage using single node rac(other than online upgrade to full RAC).

View 3 Replies View Related

RAC & Failsafe :: Upgrade Database With ASM Storage From 10gR2 To 11gR2?

Mar 7, 2011

I have a database running on 10205 version. It is a RAC database with ASM storage.

I want to migrate this database to other server and upgrade this database to 11202 version .

View 1 Replies View Related

Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?

May 4, 2011

I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?

View 1 Replies View Related

Server Administration :: How To Install Oracle 8i And 9i Databases On Same Server

Feb 20, 2011

How to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server.

View 7 Replies View Related

RAC & Failsafe :: Multiple Oracle Home Machine On Two Node ENV?

Mar 6, 2012

I have two node RAC database running on linux machine (Oracle10G SE), our requirnment is to install new oracle binaries for Oracle10G EE on diffrent home location.after install Oracle10G EE binaries on new oracle home , i want to point our existing database to new Oracle10G EE home to adotp a features of Oracle10G EE features.

But at the same time i dont want to deinstall our Oracle10G SE binaries.So it is possible to rollback our process to point our database back to Oracle10G SE from Oracle10G EE in case anything going wrong.

View 1 Replies View Related

RAC & Failsafe :: Can Server (node) Have More Than One Databases In RAC Environment

Feb 7, 2013

Can a server (node) have more than one databases in RAC environment?

View 2 Replies View Related

RAC & Failsafe :: 2 Node 11gR2 RAC Running On AIX 6.1

Oct 11, 2011

I have 2 node 11gR2 RAC running on AIX 6.1, after I shutdown the database and restart crs using crsctl start crs, ASM instance comes back up but not the database and I had to start the database using srvctl, isn't that the database should come up when I start the crs?

View 4 Replies View Related

Windows :: Fast Method To Install Oracle Client In Multiple Machines?

May 25, 2010

I need to install Oracle Data Provider for NET (and all depending Oracle client SW components) in multiple client machines.

Exist any other options (faster) without installing oracle client on each of the machines?

View 4 Replies View Related

Add 3rd Node To 11gr2 Grid With 11.2.0.2 And 10.2.0.4 Homes In Linux Environment?

Feb 23, 2011

We have 2 node cluster with 10.2.0.4 home and 11.2.0.2 home under 11gr2 grid infrastructure with ASM in LINUX environment. We are planning to add 3rd node to this cluster. Is there any issues to add 3rd node to existing environment or running fine.

View 2 Replies View Related

Application Express :: Install 3.0.1 On RDBMS 11gR2?

Sep 19, 2012

if it is possible to install APEX version 3.0.1 on oracle database version 11.2.0.3? We currently have a 10g database with APEX 3.0.1 installed. Now for an upgrade project we need install the latest database version. Unfortunately we do not have enought time to migrate the APEX application. Therefore the APEX version should stay the same.

So any experiences with APEX 3.0.1 and RDBMS 11.2?(I searched for oracle documentation but couldn't find anything useful.)

View 5 Replies View Related

Server Utilities :: Migrate 10gR2 To 11gR2 On Different Server

Jul 11, 2011

Here are the cards I've been dealt:

I've inherited a 10.2.0.1.0 instance running on a windows 2003 box; running fine, no problems other than system has been in production since 2005 and has gotten pretty old and tired. This old box has one tablespace on it... called "gateway".

I've installed 11.2.0.1 on a new (Windows 2008 R2 Enterprise 64-bit) server and created an empty database also called "gateway".

Now to move the data and views, objects, everything.

I've read up on a variety of migration techniques (oops, I mean "upgradation" LOL) and can follow the steps...

In short, I want to pull everything off of server a (10.2) and put it into production on server b (11.2). There seems to be quit a few options.

1. install 10.2 on my NEW server (server b), move the data over and get everything running, then install 11.2 and have it upgrade the database as part of the installation process.
2. drop the empty tablespace on server b, stop the database on server a, copy the files over from the old to the new home, run DBUA or set the compatibility attribute...
3. run some type of server a to server b utility that can bridge the two over the network. Some type of mirroring technique?
4. run file export scripts on server a, copy files to server b and run various import scripts

I tend to think that option 3 would be the best because both instances are in great health and are running right now. Is there a mechanism that allows the 11.2 instance to see and upgrade from a different server?

View 9 Replies View Related

Consolidate RAC Databases In Single GI For A Cluster

Jul 11, 2012

I had installed grid infrastructure for a cluster, and RAC database. The ASM is the storage option. The configurations as follows:

Grid Home: /u01/grid/app

Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1

Can I have another RAC Database to use the existing Grid infrastructure ? The second RAC database will have different owner than db1.

The configurations as follows:

Grid Home: /u01/grid/app

DB1 Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1 and Database Name: RACDBA so the current instances are RACDBA1 and RACDBA2

DB2 Oracle RAC Home: /oracle/db2/app/product/11.2/dbhome2 and database name: RACDBB so the future instances will be RACDBB1 and RACDBB2

View 1 Replies View Related

Enterprise Manager :: Warning EM Won't Run After Default 64bit 11gR2 Install

Jul 8, 2011

I've inherited a 10.2 instance here in Kuwait and I'm attempting to migrate to a brand new server; I downloaded and attempted to install 11gR2 (11.2.0.1.0) on my brand new HP clean and patched server running Windows 2008 R2 Enterprise.

I've tried clean install, re-install, install software first then database, install all together, a complete default install (other than putting the database on a different drive letter)... every time I get the same error-

Enterprise manager configuration succeeded with the following warning -

Error starting database control. Please execute the following command(s)

1) Set the environment variable ORACLE_UNQNAME to database unique name

2) ...emctl start dbconsole

There is plenty about this on the internet, google, forums. Some suggest dropping and reconfig of EM; tried that. One error leads to another error and I think I'm getting close, then some other error, more obscure than the last. VERY FRUSTRATING!

- Is this distribution broken?

- Should I try the 32-bit or just install and run the 10.2 on my brand new 64-bit server (that kinda hurts my head but I bet it would work!)

I've tried numerous re-boots, several fresh clean installs (after using the Oracle uninstaller and cleaning out the registry and deleting old files), I've set every environmental variable that I can in the system variables section including ORACLE_HOSTNAME, ORACLE_SID and ORACLE_UNQNAME.

I've tried unlocking SYSTEM and SYSMAN user accounts, I've deconfig'd the EM and have recreated the repository, reconfig'd...

Database is installed and working find. SQL plus is working and fine. It's just EM that's broken and I... just... can't... fix... it.Web page for EM starts just fine... log in (oddly, won't let me log in as SYSDBA from the web) then throws this error:

Error Internal Error has occurred. Check the log file for details.

The log files are pages long and I'm not sure what I'm looking at.

- Install different distro (like the 32-bit 11g)

- Install 10.2 and get on with my life- maybe upgrade later

- Wait for a patch?

View 7 Replies View Related

RAC/ASM Clusterware Installation :: Grid Install And Error (First Node Configuration Failed)?

Jan 26, 2013

I'm doing some testes installing grid 11.2.0.3 32bits software on a OEL6 32bits (virtual box environment). The problem appeared where i ran root.sh script on node 1. The following error appeared to me:

clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile

[code]..

View 2 Replies View Related

ODP.NET :: Can Multiple Calls Execute Within Single Oracle Session

May 8, 2013

Can multiple ODP.NET calls potentially execute within a single Oracle session due to connection pooling?

How can I test/observe this behavior?

We have an IIS application that uses one connection string for all logged in users and call aspx pages.

View 1 Replies View Related