I have started to migrate 11.2.0.3 database from Enterprise to Standard edition with expdp/impdp (RHEL box). I've managed to transfer database without any problem (ok i had little difficulties with bitmap indexes but never mind).
But now i do not have all public synonyms in place as i already knew. So i have to create sql script and i have found several good ones. My question is do i need to recreate all public synonyms or there is a exceptions in my case because i now have Standard Edition database (old one was Enterprise)?
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?
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.
I like to switch from a rac to a standalone database including downgrading the license to standard edition one. Actually SE1 is not an install option for 10g.
Would it be enough to reconfigure the 2nd rac node ?
What I was trying to do is duplicate my 10.2.0.4 DB and overwrite my 11.2.0.2 DB. Is there a way to downgrade my 11.2.0.2 DB. my 11Gr2 DB I have already set the compatibility parameter to *compatible='11.2.0.2' My 11gr2 is a test DB I don't have a valid backup..
I want to downgrade my database from Oracle 11g (11.2.0.1.0) to Oracle 9i (9.2.0.1.0).
I've done trial of taking export of higher version(Oracle11g) through lower version(Oracle9i) exp utility and trying to import same exp.dmp files into lower version(Oracle9i), but not succeeded and getting some parameter related error.
On Oracle9i database client- Here i'm connecting to Oracle11g via use of 'wbdata.wbh-db1' service
[oracle1@WBDevelop smbshare]$ exp lab/lab@wbdata.wbh-db1 Export: Release 9.2.0.1.0 - Production on Tue Dec 28 15:45:32 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc tion With the Partitioning, OLAP, Data Mining and Real Application Testing options Enter array fetch buffer size: 4096 >
[code].....
On Oracle9i database client - Here i'm importing the lab.dmp
(Export taken from Oracle11g via use of 'wbdata.wbh-db1' service) [oracle1@WBDevelop smbshare]$ imp lab/lab Import: Release 9.2.0.1.0 - Production on Tue Dec 28 15:49:51 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
am trying to downgrade my oracle database 10g release 10.2.0.2.0 to 10.2.0.1.0the reason for this is that i had to copy /oracle_home/bin utilities from 10.2.0.1 to 10.2.0.2 because of this most utilities like rman,dbca were not working.
i think i need to downgrade my oracle database 10g release to 10.2.0.1.0 right?i read some oracle documentations of database downgrade instruciting me to
>take full backup of oracle DB >ORACLE_HOME/bin/emctl stop dbconsole SQL> STARTUP DOWNGRADE DROP USER sysman CASCADE; >SQL> SPOOL downgrade.log
We have Forms application created in Oracle Forms Builder version 9.0.4.0.19. We have done modification in some forms and few forms created using Oracle Forms Builder 10g version 10.1.2.0.2.
Now we need to convert those forms which are around 5 or 6 in number to Oracle Forms 9.
srvctl config PRCR-1119 : Failed to look up CRS resources of database type PRCR-1115 : Failed to find entities of type resource that match filters (TYPE == ora.database.type) and contain attributes DB_UNIQUE_NAME,ORACLE_HOME,VERSION Cannot communicate with crsd
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 .
i was unable to log in to oracle database. i am doing the following steps :
- sqlplus /nolog - connect /as sysdba connect to an idle instance - shutdown ORA - 01034: oracle not available ORA - 27101: shared memory realm does not exist
each command i give is showing the following error: ORA - 44412: XE edition memory parameter invalid or not specified.
I am trying to install Oracle 10g on my personal laptop. I have a Windows 7 system, with MS Virtual PC and XP mode. When trying to install 10g Personal Edition, I encounter the following error:
java.util.zip.ZipException: invalid stored block lengths at java.util.zip.InflaterInputStream.read(Unknown Source) at java.util.zip.ZipInputStream.read(Unknown Source) at java.io.FilterInputStream.read(Unknown Source) at oracle.sysman.oii.oiix.OiixFileOps.copyStream(OiixFileOps.java:1421)
Just installed Ora 10g Express Edition. It has a sample database. But is there a rather larger database outside that I can download and import into Oracle for some learning reasons?
I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? list out the steps that should be performed. I saw the concept of link but really failed to understand that.
When I am trying to create a public synonym for a package then I am getting this error. This error tells us that non editioned object(Public Synonym) can not refenrence the editioned object(Package in this case).One of the solution provided on one of t he site is to create local synonym instaed of public synonym but I need to create public synonym only.
I have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.
If there is any patch to connect forms 6i into oracle 10g express edition.
Ours is Oracle 11.2.0.2.0 Db 4 instances RAC on Unix AIX OS.Since long we are facing problem that CPU utilization reached 100% and reboot is required alteast once or twice a month.On seeing the Events Logs we find that the Event "CURSOR PIN S WAIT FOR X" is consuming a lot of waits.
On analyzing i came to know that we are firing same query from Application 15 to 20 lack times for which a lot of Mutex keeps spining for getting Shared Mode and consumes a large amount of CPU.
I first started database, then gone to option Run SQL command line. After that while creating table it is showing error like "SP2-0640: Not connected."
I am running Ubuntu 13.04. I am attempting to install Oracle XE 11g R2. It seems that everything was fine until I got to configuration of the database as root I ran /etc/init.d/oracle-xe configure command. I have received the following output Starting Oracle Net Listener...Done Configuring database...
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details
When I look at the logs I get the following error ORA-01034: ORACLE not available. After receiving this error I have attempted to start Oracle manually.
sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 3 11:34:07 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORA-00845: MEMORY_TARGET not supported on this system
As you can see I got
ORA-00845: MEMORY_TARGET not supported on this system error. Ok let's see what's going on with my partitions
i am using windows xp home edition (with oracle 11g r2). oracle installed with out any problems but when i click get started internet explorer it says(internet explorer cannot display the webpage) this is the address get started open up to [URL]...but does not work.
I am a new to Oracle, Installed Oracle 11g express edition. Also I had installed Oralce SQL Developer tool but i don't know the user name and password to connect.
what is my default instance? what is my default user name and password? How to connect ?
1. I installed Oracle 11g Personal Edition, Release 11.2.0.10, 64bits, 2. Test connection(oracle in oradb11g_home1) is successed in data source, odbc, 2. Then, I tried to connect this with Visual Basic(Visual Studio 2010), data connections, add connections, .net framework data provider for oracle, 3. but I received an error message as "Attempt to load Oracle client libraries threw BadImageFormatException." 4. Then, I download the ODAC(11.2.0.3.0) for 64bits, and installed, 5. I tried to test the connection, but failed with error message as stated above, "Unable to connect SQLState=08004 Oracle ODBC Ora-12154: TNS:could not resolve the connect identifier specified"
Am moving data from 10g enterprise edition to 11g standard edition using normal import commandafter completing i just go through the Log.i found a thing which makes me confusing
in some tables alone a row is not inserted stating the ORA-12899 while checking with the database it shows the column is varchar(100)in the log the error showing it tries to insert 101 character. how it happening to a single row
