Server Administration :: Upgrade From 10G Standard ED To EE ED
Feb 12, 2012We are going to upgrade our production database from Oracle10g Standard ED to Oracle10G EE.
View 5 Replies
ADVERTISEMENT
Upgrade :: Upgrade Patch For Enterprise Versus Standard 11.2.0.1
Sep 22, 2012is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?
View 5 Replies View RelatedServer Administration :: Non Standard Block Size
Aug 15, 2011I am using oracle 10g with sga_max_size =4GB and db block size 16k. Now i am creating a tablespace with block size 32 kb , whats value i select for the parameter db_32k_cache_size.
Is there any standard way to calculate the value of this parameter.
Server Administration :: Oracle Rac Standard / Enterprise
Jul 15, 201110g 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.
Server Administration :: Getting NVARCHAR2 In Oracle Standard Edition?
Sep 13, 2011I want to know, Is NVARCHAR2 available in Oracle standard edition?
View 5 Replies View RelatedServer Administration :: Upgrade From 11.0.6 To 11.0.7?
Apr 25, 2011I have installed 11g ,i.e 11.0.6 then applied the 11.0.7 patch after that , when i tried to open the db in upgrade getting the error like
$ sqlplus '/as sysdba'
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Apr 26 02:56:43 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
[code]...
Server Administration :: Upgrade From 10.2.0.2 To 10.2.0.4
Feb 23, 2010We are using Oracle standard edition 10.2.0.2 on Solaris x86-64 platform, and I'm trying to estimate reasonability of movement to 10.2.0.4.A disadvantage I see is according to 10.2.0.2 "Availability and Known Issues" amount of "issues introduced" is about 10, but in 10.2.0.4 there are 63 "issues introduced", according to similar document. I suspect that some of bugs can be eliminated by applying 10.2.0.4.3 patchset, but I'm not sure that all of them will be eliminated. A benefit of 10.2.0.4 (and especially 10.2.0.4.3) is presence of all necessary critical patches (up to Jan2010).
View 4 Replies View RelatedServer Administration :: Upgrade DB 10.2.0.1 To 10.2.0.4
Nov 22, 2011i want to upgrade my database version is 10.2.0.1.0 to 10.2.0.4.0 steps and patch information on windows
View -1 Replies View RelatedServer Administration :: Upgrade 10g To 11g
Apr 22, 2010i m planning upgrade my server from 10.2.0.1 to 11.2...we have license for oracle 10g standard edition.
tell me the procedure from licensing point.
Server Administration :: Upgrade From 10g To 11g
Oct 27, 2011We plan on using our current enterprise application, which is using 10.2.0.5.0 on the backend, until the end of 2012. Then we're going to switch over to a whole new system.
Our vendor is telling us that Oracle will stop issuing security patches and bug fixes for Oracle 10g at the end of 2011. Should we upgrade to 11g? If we do not upgrade to 11g, then we would be on 10g for about one year without these security patches and bug fixes. Should this be a concern?
Server Administration :: Upgrade From 10g To 11g?
Nov 11, 2011 I'm planning on upgrading our 10.2.0.4 database to 11.2.0.1 on the same server. Would like to hear the best efficient method to do so from the experts.. My first option is to use datapump method, so I can take a backup and uninstall 10g on the server, Install 11g and import the data. But as I was reading through the documents on the upgrade, I think it is best to use DBUA instead. I'm planning to follow this document to upgrade using DBUA. [URL]
Few doubts on this..
1. Since I will be upgrading the existing 10g database, I suppose I need not uninstall 10g prior to the upgrade. I read that DBUA will shutdown the database during the upgrade. Currently we have Oracle 10g software in c:oracleproduct10.2.0db_1 and the data files are in different disk drives and also in c:oracleoradata folder. So will DBUA move the physical datafiles to the new location?
2. Do I need to stop 10g listener prior to running DBUA?
3. Will I be able to uninstall 10g after the upgrade?
Server Administration :: Upgrade 9i To 11g
Jul 21, 2011We have a 9.2.0.5 1.09TB Database running on windows 2000 Advanced server(32Bit) and we want to go to Windows 2008R2(64bit)on 11gR2(64bit).
View 3 Replies View RelatedServer Administration :: Upgrade 10.2.0.5 To 11.2.0.3
Apr 28, 2012Point for upgrading my 10G to 11G. It is a standalone DB on windows 2003. I have already install the 11G software on a different oracle_home. I need know to re-direct my datafiles to the new oracle_home.
View 1 Replies View RelatedServer Administration :: Upgrade From 11.2.1 To 11.2.2.0
Sep 17, 2010Oracle has changed the way to upgrade the software, i'm completely lost and angry i used to be able to just download the patch and install however the new patch that came out on the 13th of September is completely different, I just want to upgrade the current version of 11.2.0.1 to 11.2.2.0 somehow the software i got wont let me keeps saying the "software is on version 10.2.1. need to upgrade" how to upgrade to that? these are the files I have after the unzip of all 7 downloads
drwxr-xr-x 8 oracle oinstall 4096 Sep 7 01:10 database
drwxr-xr-x 8 oracle oinstall 4096 Sep 7 01:12 grid
drwxr-xr-x 6 oracle oinstall 4096 Sep 7 01:16 examples
drwxr-xr-x 6 oracle oinstall 4096 Sep 7 01:17 client
drwxr-xr-x 7 oracle oinstall 4096 Sep 7 01:19 gateways
drwxr-xr-x 20 oracle oinstall 4096 Sep 17 15:50 deinstall
[code]....
Server Administration :: Upgrade Database From 11.2.0.1 To 11.2.0.3?
Dec 15, 2012I tried updating the oracle database from version 11.2.0.1 to 11.2.0.3 but I have no clear procedure. I chose the option of the installer "upgrade database" and install the software on a new home. To migrate, must be all oracle services stopped? In the migration phase, it is normal to ask me listener data, etc .... or installer now detects the same database?
View 1 Replies View RelatedServer Administration :: Upgrade 10.2.0.4 To 11.2.0.2 On Solaris?
Aug 28, 2011I tried to upgrade oracle 10.2.0.4 to 11.2.0.2 on the Solaris 10 server, but after 40 minutes it hangs bei oracle XML Database.
View 5 Replies View RelatedServer Administration :: Oracle Upgrade To 11G
Dec 28, 2012I have been trying to upgrade my personal laptop with 11G from 10G. Since I didn't had any important data, so i removed 10G and tried to go for a fresh install of 11G.
Below are the entries of my files:
Listener.ora
# listener.ora Network Configuration File: C:appNikproduct11.2.0dbhome_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL.WORLD)
(ORACLE_HOME = C:appNikproduct11.2.0dbhome_1)
[code]........
If i start the database in no mount it doesn't give any error. Once I try to mount it, it gives the following error:
SQL> alter database mount
2 ;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> show parameter control;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string C:APPNIKPRODUCT11.2.0DBHO
ME_1DATABASEORA_CONTROL1.CTL
, C:APPNIKPRODUCT11.2.0DB
HOME_1DATABASEORA_CONTROL2.C
TL
control_management_pack_access string DIAGNOSTIC+TUNING
Server Administration :: Upgrade Oracle 11.2.0.1 To 11.2.0.2
May 2, 2012Currently, We are running oracle 11.2.0.1 on Linux server. There are 32 DB instances on this server. As per requirement, we need to install 11.2.0.2 DB on the same server. Is it advisable to have both 11.2.0.1 and 11.2.0.2 databases on the same server with different ORACLE_HOME.
How about ORACLE_BASE?? OR, do we need to upgrade all the DB's from 11.2.0.1 to 11.2.0.2. During the upgrade process, if i need to take backup with exp/imp utility, what is the best way to take 32 DB's backups instead of taking each DB backup at a time?
Server Administration :: Upgrade Oracle DB From 11.1.0.6 To 11.2.0.1?
Nov 8, 2010steps required to upgrade oracle db from 11.1.0.6 to 11.2.0.1.
Is it a single step or i need to patch it to 11.1.0.7 then upgrade it using dbua to 11.2.0.1?
Server Administration :: Upgrade To 10g (10.2.0.1.0) From Oracle 8i (8.1.7.0)
Feb 23, 2010Currently installed 8.1.7.0 .i want to upgrade to 10.2.0.1.0 in the upgrade documentation its written the direct upgrade is not supported for 8.1.7.0, first update to 8.1.7.4 and then direct upgrade to 10.x.
unable to find 8.1.7.4 update.any link to find update or guideline to direct upgrade to 10.x.
Server Administration :: Oracle 9i Upgrade To 10g?
Jun 15, 2010We have production environment running on oracle 9i database. we are planning to upgrade it to 10g. I have reviewed many documents and blogs but still have few concerns. Pls provide me complete steps to upgrade our 9i db to 10g.
1. For 9i to 10g upgrade we need to install oracle 10g with different oracle_home and then launch dbua and upgrade 9i?
2. will new installed 10g home will read 9i home when dbua launched?
3. Is there any upgrade installer available to upgrade to 10g like patchset upgrade installer?
Server Administration :: Upgrade 9i To 10g Using RMAN Backup?
Mar 22, 2011I have upgraded a 9i db to 10g on another server using rman backup (9.2.0.8.0 on linux to 10.2.0.4.0 on Linux)
I copied the hot backup - rman from 9i db server to 10g db server
Then I restores the rman backup on the 10g db server opened the database with
alter database open restlogs upgrade;
@?/rdbms/admin/catupgrd.sql
shutdown immediate;
startup restrict
@?/rdbms/admin/utlrp.sql
Now I have all components in VALID state but the db server itself in INVALID state as can be seen from results below
SQL> select comp_name, status, version from dba_registry;
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
Oracle Database Catalog Views
VALID 10.2.0.4.0
Oracle Database Packages and Types
VALID 10.2.0.4.0
SQL> @?/rdbms/admin/utlu102s.sql TEXT
.
Oracle Database 10.2 Upgrade Status Utility 03-22-2011 10:35:20
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:06:59
.
Total Upgrade Time: 00:07:05
PL/SQL procedure successfully completed.
SQL>
Has the upgrade failed?
Note that
OS for 9i db server is
Linux 2.6.9-42.EL #1 x86_64 x86_64 x86_64 GNU/Linux
OS for 10g db server is
Linux 2.6.18-53.el5 #1 x86_64 x86_64 x86_64 GNU/Linux
Server Administration :: Upgrade 10g (10.2.0.1.0) 64bit Database To 11i?
May 23, 2012i want to upgrade my 10g(10.2.0.1.0) 64bit database to 11i. how can perform it. os windows xp.
View 1 Replies View RelatedServer Administration :: Upgrade Oracle 10g To 11gr2
Nov 25, 2011Im planning to upgrade oracle10g to 11gr2.. i have query on that ..
my 10g having ORACLE_HOME=/app/ora/10.2.0, orainventory =/app/ora/oraInventory
new 11g ORACLE_HOME=/app/ora/11.2.0 .orainventory =?
my question is where i need to set ora inventory location for my new 11g? or it will create new location for that?
OS version : IBM AIX
Server Administration :: Getting Error During Upgrade To Oracle 10.2.0.5?
Jun 24, 2010I have upgraded my database from 10.2.0.4 to 10.2.0.5. however while upgrading database using DBUA I am getting this error.table or view does not exist ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579 ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596 ORA-06512: at line 1The WMSYS.OWM_MIG_PKG is warped package and I can't understand what it means. How can I understand what view or table is absent in my database?
View 6 Replies View RelatedServer Administration :: Upgrade Oracle Version From 10.2.0.1.0 To 10.2.0.4.0
Apr 27, 2011I want to upgrade my Oracle version from 10.2.0.1.0 to 10.2.0.4.0 but but i don't know what are the correct ways. i read the read me file in the patch set and fallowed the steps but its giving me error e.g. "Error in writing to file D:Oracleproduct10.2.0.2.0inoraevrus10.dll" every time. We have no RAC and Cluster Environment.
View 10 Replies View RelatedServer Administration :: Upgrade 9.2.0.8 Database In Oracle 11.2.0.2
Sep 21, 2011I am trying to upgrade the oracle 9.2.0.8 database in oracle 11.2.0.2. I have installed the new oracle home for 11g and after running the pre-upgrade script and setting the all environment variable like oracle base, oracle home, oracle sid and ora_nls
i am running the dbua but after click on finish button it's do the processing of 2% but after that i get
-------------------------------------------------
ORA-12709 error while loading create
database character set
--------------------------------------------------
Server Administration :: Convert Enterprise Edition DB To Standard Edition?
Nov 4, 2011The 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.
Server Administration :: Download Patchset To Upgrade Database From 10.2.0.3 To 10.2.0.5?
Apr 23, 2012where I can download patchset to upgrade my database from 10.2.0.3 to 10.2.0.5?
View 1 Replies View RelatedServer Administration :: Migrate And Upgrade Oracle 9i Database To 10g?
Mar 10, 2011I am looking to migrate and upgrade an Oracle 9i database to 10g.
Would there be any fallout if the characterset were changed from US7ASCII to UTF8?