I have installed oracle 11g R2 in windows and i ve created database of vesrion 11.2.0.1.0. I tried to upgrade the database to higher version using the dbua utility . But in this utility source & destination both is showing as 11.2.0.1.0. upgrade the database from 11.2.0.1.0 to higher version using the dbua utility
View 16 RepliesWhen upgrading database from 10.2.0.1.0 to 10.2.0.4.0 , i am getting following error$
/run Installer Starting Oracle Universal Installer...Checking installer requirements...Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3 Passed All installer requirements met. Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-07_01-25-05AM. Please wait ... error: invalid compressed data to inflate /tmp/OraInstall2013-09-07_01 -25-05AM/oui/jlib/ewt3.jarerror: invalid compressed data to inflate /tmp/OraInstall2013-09-07_01-25-05AM/oui/gui de/htmlguide.jar
We are trying to upgrade oracle database from 10.2.0.4 to 11.2 using DBUA, but when we try to launch the DB upgrade assistant uisng dbua.sap.sh script, we are getting the below error
for input string SP2-0640 not connected.
Find below last few lines from the logs from location /oracle/cfgtoollogs/dbua/logs/trace.log
[Thread-13] [ 2013-02-12 14:34:00.002 CET ] [Database.updateNonDefaultInitParams:1199] mts value altered based on db version:null
[Thread-13] [ 2013-02-12 14:34:00.005 CET ] [CompManager.obtainGenericDbInfo:2436] get number of data files backing up
[Thread-13] [ 2013-02-12 14:34:00.024 CET ] [CompManager.obtainGenericDbInfo:2470] Source Database Version :=10.2.0.4.0
[Thread-13] [ 2013-02-12 14:34:00.024 CET ] [CompManager.obtainGenericDbInfo:2479] Source Database Version :=10.2.0.4.0
[Thread-13] [ 2013-02-12 14:34:00.027 CET ] [CompManager.obtainGenericDbInfo:2605] backupNo =0 ...
I am currently in the process of trying to upgrade a 10.2.0.4 database to 11.2.0.2. I am using DBUA to complete this work. I have a small issue which I cant work out and cant find anything on Google or oracle docs about it.
The home where the software for 11.2.0.2 is an ORACLE_HOME that was recently cloned from another 11g home. When im in the DBUA summary page before I kick off the upgrade the summary page lists the "TARGET" oracle home as the old 11g home and not the new "CLONED" one.
Obviously DBUA is picking up the target ORACLE_HOME from a file in the cloned home that has not been updated with the new CLONED home info. I have made sure all variables are set correctly including the PATH variable.
I am trying to upgrade 10.2.0.4 DB to 11.2.0.3 using DBUA.10g oracle is owned by user ora10gr4 and 11g oracle is owned by user ora11203.I started DBUA from 11g/bin path and while selecting DB i want to upgrade I am getting following error.
Oracle home owner check failed:-PRKH-1014.Current user "ora11203" is not the owner user "ora10gr4" of oracle home "/oracle/ora10gr4"..I cannot give the ownership of both oracle home for same user because of project criteria.
Servers: Linux 5 & Windows 3 (seperate servers)
Database: Oracle 10.2.0.5.
Upgrade to: Oracle 11.2.0.3
Upgrade type: Inplace upgrade (DBUA) on same servers ...
I am about to start our Oracle Production database from Oracle 10g to 11g and get a quick question: Will all database service accounts or usernames, or schema AND their passwords moved to the new environment?I am mostly concern about the password. I don't want to change them in the new environment. We have hundreds of jobs from all over the world using these usernames and password and do't want to change them.
Example: Will username app_users and its password (PassWord@rAll)be usable in the new 11g environment?
If have several databases running on a 10.2.0.4 Oracle Home. I want to upgrade one of them to 10.2.0.5. My thinking is that I install 10.2 to another location e.g. /u01/app/oracle/product/10.2.0.5 and patch this OH to 10.2.0.5. Regarding the steps to upgrade a particular database. Oracle documentation as I'm unable to locate?
View 11 Replies View Relatedfind reference note IDs for DB upgrade from 11.2.0.2 to 11.2.0.3.2, as I am finding only Exadata which I don't want but I want to find for Ebiz database, on OS - Solaris 10 9/10 s10s_u9wos_14a SPARC.
View 1 Replies View RelatedAlong with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory
Select * from dba_directories; (there are other commands to get this info as well).
I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?
Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.
All my sys tables are very slow after my database upgrade from 10.2.0.4 to 11.2.0.3 on AIX 6.1
For example
select * from ALL_TAB_COLUMNS; -- taking 19 seconds in 11.2.0.3 and few millisec in 10.2.0.4
I have deleted and updated fixed and dictionary table statistics , till I facing this issue
I need to upgrade an oracle 8i database on HP-Unix server to Oracle 11g on Linux server, whether to upgrade it first to 10g linux and then to 11g ?
View 4 Replies View RelatedI wanted to know the best utility in oracle to load data in crores from excel sheets in the database temporary tables in a minimum time.
Is sqlldr the best utility to use in this scenario or to use the parallel and append hint in the insert statment.
how much time the sqlldr and above mentioned hints take to load 10 crore data in the database table.
I'm going to backup this un-maintained Oracle 11g server in my office. I'm being told it's never been backed up and extremely critical to our success so tomorrow I'll be performing my 1st backup of the database using RMAN. My question is if I connect to the Oracle 11g database and run the:
[oracle@db1 ~]$ rman target=/
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 13:18:05 2012
connected to target database: CQDB (DBID=1854033249)
RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
BACKUP DATABASET FORMAT �/oracle/u01/app/oracle/backup/%d-%T-%s-%P�;
My question is the above sufficient for a safe full backup? We only have the one single target database called 'cqdb' which houses several schemas. Can you tell me if this is correct? I've shut the database down so it's in a cold state so I don't think I need to configure the FRA (Flash / Fast Recovery Area) but I honestly don't know. This is my 2nd time on a Oracle DBMS.
What about the 'archivelog' files? Do I back those up? Do I need them in case a recovery? Also what about the 'controlfile'? Do I need to back those up as well as the mentioned above?
I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
SCHEMA USERNAME
PASSWORD
HOSTNAME
PORT NO
SID/SERVICE NAME
these details. May be am wrong to ask this question but i need to login and check the requirement. Is there any other anyway to login without sqlplus utility?
Upgrading one of the 9i database to 11g that supports a 3rd party software - ***Vendor provided an over-simplified documentations*** and recommends moving from 9i to 10g before going to 11g. A few changes from 9i to 10g.
1) db_block_size
2) character sets
etc.
Anyway, created the database DBUPGTEST on 10.2.0.1 (ultimately moving to 11gR2, so no point patching to 10.2.0.5, is there?) with all the parameter changes. At this point, these are the 2 db in play:
Current production db: Oracle 9i - PROD dbname => 2048K db block size
Current migrating db to: Oracle10g - DBUPGTEST dbname => 8192k db block size
Steps
According to vendor notes / documentation,
1) create db
2) exp full from 9i
3) imp full to 10g
Problems
1) import ended with completed unsuccessful.
2) user accounts are imported (because their default tablespace is USERS - which had already been created during DB creation); but, user accounts (schema accounts) with a different default tablespace are not imported.
Looking at the imp.log - seems like it's complaining about the db_block_size during tablespace creation - which explains why the schema accounts are not imported; because the tablespace was not created.
My questions
1) How do I import to 10g? Can I create all the tablespace in 10g first? Then import? Will it crap out because it already exists? Or will it import the objects in the schema?
2) How do I refresh data from PROD? Remember this is 9i and most of the expdp functionalities are not available. And I cannot re-exp and re-imp because there are steps (sql to run) after moving to 10g to fix some software upgrade table mappings. If I re-exp from 9i and re-imp to 10g, won't I have to re-run all those steps before the apps will run?
We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1
No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.
can we upgrade the oracle database from enterprise edition to latest standard edition?
Iam doing some oracle database upgrade from 9.2.0 to 11gr2 . is it possible to upgrade directly from this 9i version to 11gr2 .
Version : 9.2.0 to 11gr2
Does EM have a utility that I can get to scan a set of host machines and their disks and tell me what oracle products are installed? Sort of like that common inventory tool used on windows desktops, but just for Oracle products.
If not EM then any third party tool or some other Oracle tool?
After many tries of upgrade'ing oracle I decided to make backup of my database and then remove 11.2.0.1 and install 11.2.0.3 to recover db. Unfortunately I am not sure how should I perform restoration.I backed up data by calling RMAN> backup database include current controlfile;
After that I moved files from fast_recovery_area and cleared my machine from current oracle release.I also did a copy of directories:
ORACLE_HOMEdbs
ORACLE_HOME
etworkadmin
ORACLE_HOMEowbinadmin
ORACLE_HOMEhostname_dbname
ORACLE_HOMEoc4jj2eeOC4J_DBConsole_hostname_dbname
i have upgraded the Database from 11.2.0.2 to 11.2.0.3 , after that while i was accessing the D.B i am getting this error.
ORA-00020: maximum number of processes (600) exceeded
after that i have modifed number of process and made it to 1200.
but then i got the same issue
ORA-00020: maximum number of processes (1200) exceeded
is it any Bug or the upgradation went wrong. Is there any change in the primary and foreign keys before and after the upgrade...
i want to know is there any difference between upgradation of SID and database. while upgrading my database from oracle 11.2.0.2 to 11.2.0.3 in DBUA it shows my SID is upgrading (ORCL) but i have few other databases ex (test and prod).
is it enough if we upgrade the SID or we must perform any other actions..
and
2nd QUERY :
i have 2 oracle homes in my server with different versions like (11.2.0.2 and 11.2.0.3)and i have few databases and there tablespaces. how to determine which database is created on which version and which database is upgraded from 11.2.0.2 to 11.2.0.3.
Why is knowing the backup policy important before starting any upgrade.
View 17 Replies View RelatedI have an upgrade question. My customer wants to minimize downtime and so wants to do a rolling upgrade of crs, asm, dbhomes and databases from 10.2.0.4 to 10.2.0.5.
Customer wants to upgrade server1 during normal business hours- CRS/ASM/DBHOMES, then move databases from server2 to server1 and upgrade during planned downtime, then upgrade server2 during normal business hours -CRS/ASM/DBHOMES.
3 steps, taking 3 days to complete. Is this possible? I know CRS can be done in a rolling upgrade, but what about ASM?Is this doable?
we have a very critical application running and the backend database is 10.2.0.3. we are planing on upgrading to 10g to 11.2.0.2 and looking ways to look with minimal downtime off production. steps for upgrade with very minimal downtime of appliction?
View 2 Replies View RelatedI 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 RelatedI want to upgrade our database version (9.2.0.7) to 10g (10.2.0.2)
I know if I set COMPATIBLE parameter to 10.2.0.2 at first then I can't downgrade to 9.2.0.7 if any problem occurs I am not sure that our application can deal with 10g or not so I think it's better to leave the COMPATIBLE parameter to 9.2.0 several days for sure and if all things go well then change COMPATIBLE to 10.2.0.2 (I need to say that I can’t test our application in a test environment )
Now do you think leaving COMPATIBLE to 9.2.0 (after upgrade) for many days can cause any problem to Database ?
I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in Linux 32 bit . I faced the version incompatibility error during patch set installation and hence ran the patchset installation with -ignoresysprereqs option.
Now during the patchset installation i encountered the below error in in the install logfile.
**************************************
INFO: Start output from spawned process:
INFO:
--------------------------------------------------------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
INFO: make:
INFO: *** [client_sharedlib] Error 1
INFO:
INFO: End output from spawned process.
INFO:
--------------------------------------------------------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/oraInventory/logs/installActions2012-06-24_11-45-11AM.log' for details.
Exception Severity: 1
***********************************************
Provide me the certified os and versions for oracle db 10gr2
After upgrading 11gR1 database (11.1.0.7.0) to 11gR2 (11.2.0.3.0), the datapump exports have been taking quite a bit longer. When database was 11gR1, a full expdp took approx. 40-45 minutes. After upgrade, it takes approx. 1 hour 40-50 minutes. These times were with parallel=4. I tried with parallel=8 and parallel=12, both of these took around 1 hour 5-10 minutes, better but still quite a bit slower than pre-11gR2 upgrade. I tried with exclude=statistics, index_statistics, indexes; it still took approx. 1 hour 40-45 minutes. This is a PeopleSoft database so there are many, many objects to be exported. The database was upgraded using dbua.
View 1 Replies View Relatedi 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 Relatedwe had our Oracle RAC database at primary and Standby database as DR. It was running in 10g (10.2.0.1.0) in HP UX 11i platform.
We need to upgrade both the setups from 10.2.0.1.0 to 10.2.0.4.0 . I will go through the upgrade guide, i like to know is there any special case for upgrading when we do for both primary and standby database.
And whether i need to create a new Oracle home with 10.2.0.4.0 software or i can upgrade in the same oracle home which already exists.