RAC/ASM Clusterware Installation :: Difference Between Enterprise And Standard Edition For Oracle
Mar 18, 2013
In our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?
They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?
View 6 Replies
ADVERTISEMENT
Nov 4, 2011
The only supported technique for converting an EE database to SE is export-inport, as documented in note 139642.1. Our client is reluctant to do this because of the downtime involved. It is however possible to open the EE database from an SE home, no problem.
The note says only Quote:When you just install the Standard Edition software, you will end up with Data Dictionary objects which are of no use (or perhaps even invalid) and possibly create problems when maintaining the database.
View 2 Replies
View Related
Feb 18, 2011
My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:
Not a zip file(End header not found)
View 1 Replies
View Related
Sep 12, 2012
Recently we have downgraded our database from enterprise to standard edition.....our sga size before downgrade was 11 gb and now it is 11gb and there is no as such problem in database..I have read somewhere that standard edition doesn't support sga size more than 2 gb .
View 1 Replies
View Related
Feb 10, 2011
I am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.
How can we check and be sure that a downgrade to SE would not be any problem?
Some checks include:
* partitioning used in user schemas? --> no downgrade to EE
* bitmap indexes in user schemas? --> no downgrade to EE
How can we complete this list, or is there some script to make this easy?
View 7 Replies
View Related
Jun 26, 2012
When i am trying to uninstall Oracle 11g Standard Edition on Win 7 after sometimes it stopped.Checking for required files and bootstrapping..
14 File(s) copied
792 File(s) copied
1 file(s) copied.
1 file(s) copied.
Location of logs C:UsersinsajenAppDataLocalTempOraDeinstall2012-06-26_15-2
2-43logs
[code]....
After this message it stopped.
View 1 Replies
View Related
Jul 27, 2011
can I install/use Oracle 10g Enterprise Manager Grid Control if my organization has only Oracle 10g Standard Edition Licences.
View 2 Replies
View Related
Feb 20, 2013
I am using Oracle 10.2.0.3.0 standard edition. Now i want to use Oracle XDB in the same.
Can i use this directly or does this require license.
View 2 Replies
View Related
Apr 3, 2013
We are using Oracle 11g R2 on Windows 2008 R2 Server. I have noticed that there is no Enterprise Manager Installed on test environment ( I haven't did this installation). However I tried to configure the EM by using the following command
emca -config dbcontrol db -repos recreate
but got message that "Database Instance is Unavailable" (while instance is up and running with all listeners)
I checked the sysman directory under "$ORACLE_HOME/hostname_sid/sysman".
how can I configure Enterprise Manager (DB Console) in this scenario ?
View 0 Replies
View Related
Sep 13, 2011
I want to know, Is NVARCHAR2 available in Oracle standard edition?
View 5 Replies
View Related
Oct 8, 2013
I have requirement where replication should be done between two 11gR2 RAC on Standard edition.I have following queries,1. Does Standard edition support DDL capture?
Im asking this because on
[URL]......
it says "SE1/SE: no capture from redo" what that really mean ??2. Can it be possible to configure capture at schema level and skip only some of the tables / triggers ?
View 2 Replies
View Related
Apr 15, 2013
We are upgrading from oracle 9.2.0.8 to 11g r2, and both are Standard Edition database. The database is part of a product that runs on a customer site, and won't get bigger than 50 GB. It runs in archive mode, and our backup script does a hot backup every night, plus copying the archive logs, redos, controlfiles, etc. We save 2 entire backups - from the last night plus the night before last. Then there's a tape backup that saves the backed-up files to an off-server location.
This architecture has allowed us to recover our customer's data from many odd occurrences at customer sites (power loss during a hot backup, corrupt controlfiles/datafiles/archivelogs). My question is, given that we are running the Standard Edition database, which doesn't have most of the useful RMAN features, is it worth it to switch to RMAN?
I took an Oracle Backup and Recovery class and posed this question to the instructor, and the response was, it would be better to use RMAN over a manual user backup script. Our backup script is pretty battle-hardened - is that the best reason?
View 6 Replies
View Related
Feb 5, 2013
I read that Oracle RAC which is bundled in Standard Edition can support at max 4 sockets. One of my client has a proposal of using RAC but for 3 nodes each using single 1 quad core Intel processor. As far as i understood, an Intel quad core is a multi chip module and actually is a combination of 2 modules dual core, so each Intel quad core may be counted as 2 sockets. Which yield to the proposal of my client will be failed, as the total number of sockets in it will be: 2*3=6 that exceed the max 4 support.
View 4 Replies
View Related
Nov 6, 2012
my customer wants to create a standby database for his production database (Oracle Standard Edition 11g R2 @ Windows 2008 R2 64 Bit). Now any proof-of-concept which explains shortly the concept and how to achieve it.
View 4 Replies
View Related
Jun 7, 2013
I am trying to install Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox/Mac OS.But getting problem to set network & ip setting and yum is not able to reach oracle repository.
if anyone tried installing Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox on intel based Mac OS.
View 0 Replies
View Related
Dec 3, 2012
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
View 25 Replies
View Related
Aug 28, 2013
I am installing RAC 11GR2 in VMWARE on OEL 6.3. Everything went smooth but when i tried to configure ASM , I get below messages.
[oracle@RAC1 ~]$ /etc/init.d/oracleasm configure-bash: /etc/init.d/oracleasm: No such file or directory.
View 15 Replies
View Related
Jul 15, 2011
10g Oracle Standard Edition RAC feature and how it is charged. I mean: is it free option for Standard Edition or payable?
I read something about Baby Rac on wiki and there was information that only with Engerprise Edition RAC is an extra-charge option for Standard Edition RAC is included.
[URL]......
Quote:Oracle Corporation includes RAC with the Standard Edition of Oracle Database (aka Baby RAC), but makes it an extra-charge option for the Enterprise Edition
We do have corporate licencing model in our firm, so we can evaluate what version of Oracle we need to install (One, Standard or Enterprise) bu there is no matter what version we chosed, because our licensing model give us possibility to install the highest version. So usually we were choosing the Enterprise Editions.
But only limitation for us is an options. We can't have additional option like partitioning, RAC, Oracle Tuning Pack, etc... in order to have additional option we need approval from our financial management.
I have idea to change one of our installation from Enterprise Edition to Standard Edition in order to have RAC option for free. Like i said. If we want to have RAC in our Enterprise Edition we need additional approval of money expense - but this is not easy. But our licensing model give us possibility to install Standard Edition of Oracle instead or Enterprise Edition and have RAC option include without additional expenses.
View 2 Replies
View Related
Jul 11, 2013
I want to install Oracle Grid software 11g R2. What is the Latest Oracle Grid software 11g R2 version available?Is it 11.2.0.1 or 11.2.0.3?If it is 11.2.0.3, is it available in metalink download, because I see only 11.2.0.1 version in metalink download?
View 2 Replies
View Related
Jan 19, 2013
which are ALL the scripts which automatically get run by DBCA in ORACLE 11G Enterprise Edition.
View 2 Replies
View Related
Mar 20, 2013
My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...
I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.
So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...
That is for express version only.
My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?
View 3 Replies
View Related
Sep 2, 2011
I am querying v$sga and getting variable size : 211337216 bytes.when querying v$sgastat then getting
java Pool : 16777216
Large Pool : 41943040
Shared pool : 398560392
But as per my knowledge following condition should satisfy,but not getting
[code]
Variable sga = java pool + large pool + shared pool
select pool,name,sum(bytes)
from v$sgastat
where pool in ('shared pool','java pool','large pool')
group by pool,name;
Here variable size using v$sga : 211337216 bytes
and java pool + large pool + shared pool : 211302536 bytes.
[/code]
but it should match?
View 5 Replies
View Related
Sep 16, 2013
Am planning to install oracle RAC 11g on linux server. Have doubt on installation of clusterware or grid infrastructure first .?I think grid infrastructure covers clusterware and ASM both and then oracle 11g software to be installed. But how to download grid insfrastructure software. Will it come with oracle 11g software..? or need to download it seperately.? Because when i try to download oracle RAC 11g which gives link to download the 11g software not grid.
View 4 Replies
View Related
Mar 13, 2013
I am installed the Oracle database following the this link .
1.Downloaded 11g express edition
2.Created a new user 'oracle' under the group dba. Following steps are executed using this.
3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package
sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
4.Created /sbin/chkconfig file and added the entries as specified here
5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.
6.Below steps:
ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener
7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)
8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)
9.Set the following env variables in ~/.bashrc file
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
[code]....
Now when exectute any SQL statements on SQLplus, i end up with the following error
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
I have increased the swap memory as specified in here
free -m
total used free shared buffers cached
Mem: 3901 3428 473 0 182 1988
-/+ buffers/cache: 1258 2643
Swap: 5066 0 5066
View 6 Replies
View Related
Jan 2, 2013
Oracle version :11.2.0.2 standard edition one
I'm trying to enable Email Notification for Chain Jobs, Jobs are running successfully, but i'm not getting email Notification.
i have done necessary SMPT setting in the Enterprise manager and i'm receiving test email from EM.
Below are steps followed:
1) i have created two Program
2)Add this program to a Chain
3)Created a Scheduler Job using this chain
4)Enable Email notification
Code for Email Nitrification:
BEGIN
DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION (
job_name => 'ChainJob',
recipients => 's.sankar@test.com',
sender => 'sankars@test.com',
subject => 'Scheduler Job Notification-%job_owner%.%job_name%-%event_type%',
[code]....
View 3 Replies
View Related
Jan 16, 2012
In my production ENV there is two node RAC database is running , and on both machine RAM size is (35GB on node1,41GB on Node2) and other configuration is like below.
SGA SGA_TARGET DB_BLOCK_SIZE DB_MULTIBLOCK_READ_COUNT
NODE1 16G 14G 8K 16K
NODE2 16G 14G 8K 16K
Our Database size is 700GB approx.
The above SGA configuration is ok or need to be increase the size of SGA , our HIT RATIO is almost 99%.
View 5 Replies
View Related
Aug 16, 2013
when migrating from 32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of?
View 2 Replies
View Related
Sep 24, 2012
I need some professional article about how to configure DNS for using Oracle GNS with explanation.
I want to understand the role of DNS server for GNS.
I tried to search but what I found is not enough or they are not written with accuracy.
View 2 Replies
View Related
Feb 28, 2013
Here we are going to configure a new set up on new hardware :
clients requirements :
oracle 11g with ASM :
Number of instance = Single database
Platform = IBM AIX 6.1
View 6 Replies
View Related
Jul 9, 2012
I have been reading a lot of documentation regarding oracle services and I have an ok understanding of how they work. However, I have a general question regarding configuring services using Oracle RAC. For instance, if I have a 2 node oracle 11GR2 RAC on a Linux Redhat server. I have an application that connects to a service I have created. I create the service as follows.
srvctl add service -d ORCL_RAC -s APP_SERVICE -r ORCL_RAC1,ORCL_RAC2
The tnsnames contains:
APP_OLTP =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
[code]...
My questions are as follows:
1) When I do a 'srvctl status service -d ORCL_RAC', should I see the service running on both nodes of the RAC? Or does it run only one node, then it will fail over to the other when needed?
2) If I have a RAC environment where I see two services created (RAC_SRV1 and RAC_SRV2). I see that RAC_SRV1 is only running on node1 and RAC_SRV2 is only running on node2. There are two applications sharing the same database, one application is using RAC_SRV1 and the other application is using RAC_SRV2. Am I correct in thinking that there is no failover available here? If node1 goes down, the application connecting to RAC_SRV1 will not be able to connect to node2 right?
3) In the case of the scenario in question 2 above, would it be best practise to simply create one service and have both applications connecting to the one service? Could I configure the one service to point connections from one application to node1 and connections from the other application to node2?
View 1 Replies
View Related
