Upgrading RHEL3 To RHEL5 Is Not Possible

Sep 23, 2011

I have a virtual Linux RHEL 3 server with Oracle 9.2.0.8 DB running on VMWare. Now I need to update Linux to RHEL 5 and oracle to 11R2.upgrading RHEL 3 to RHEL 5 is not possible, so I need to install a new RHEL 5 server.

My plan is to install a new virtual server with RHEL 5and Oracle 11R2 in it. And then migrate DB there.What would be the easiest/fastest/safest way to do this? I would prefer using the DBUA method because of simplicity and my knowledge of Oracle :-)

I already tested this certainly unsupported scenario and it seemed to work:

I was unable to install Oracle 9 to RHEL 5 (not supported on RHEL5). So I just shutdown the DB on old environment and just copied everything related to Oracle from old RHEL 3 server to same locations on new RHEL 5 server. The DB started up just fine on RHEL 5 server.

So now as I had Oracle 9 DB running in RHEL 5 and also Oracle 11R2 binaries installed, I just followed DBUA instructions to do the upgrade and it seemed to succeed.

View 1 Replies


ADVERTISEMENT

Migrate Install From RHEL4 To RHEL5

Oct 14, 2010

I need to build a new server for my Oracle 10gR2 due to compatibilities with the new storage system that we have purchased, this server will run RHEL5 x64 and will replace a RHEL4 x64. Since doing an upgrade poses greater risk as the upgrade may fail, I am thinking about building a new server with RHEL5 x64 doing all the config/tuning and then simply running the same Oracle installation (after a full backup) which I was running on the RHEL4 x64.

For this to work I will just need to mount the SAN drives on the new server but and this may be a big but, considering that some versions of some libraries will change do I need to relink anything in my Oracle? I have never manually relinked anything but Oracle may have done so during the initial install.

View 7 Replies View Related

RAC & Failsafe :: Oracle Asm Packages For RHEL5.3 32 Bit?

Jul 3, 2011

I am unable to locate the asm packages for rhel 5 :2.6.8-128 kernel of 32 bit.

Only 64 bit rpm are availbale on OTN.Can ayone suggeet me the URL for 32 bit>

View 1 Replies View Related

Enterprise Manager :: Oracle 11g R2 On RHEL5

Jul 23, 2010

I have installed Oracle 11g R2 on the RHEL 5 platform. Once the installtion is complete we need to run two scripts:
1: orainstRoot.sh
2: root.sh

As the root user.When we run the root.sh script is ask us to overwrite three variables yes/no? we did yes.After Running these scripts we opened the database, tried to run listner as well, everything is running fine but when we are trying to run the Emterprise Manager using command:

emctl start dbconsole

we are prompted with a path to check the logs
/u01/app/oracle/product/11.2.0/db_1/localhost_orcl11g/sysman/log

I do not know which file I have to check.What could be the reason we are not able to run the EM.I need it urgently as we ahve to generate the AWR reports for the client.

View 7 Replies View Related

Import Data Into A 10g Database On RHEL5?

Sep 2, 2010

I am trying to import data into a 10g Database on RHEL5.

Fol are the type of TABLE_NAME's of the TABLEs on the export dump:

1.ABCD
2.A_BCD
3.XYZ_AM
4. XYZAM

My requirement is:

I need to import only tables 1 & 4. I would like to exclude tables 2 & 3.

This is what I have only par file:

EXCLUDE=TABLE:" LIKE '%!_AM' escape '!' "
EXCLUDE=TABLE:" LIKE 'A!_%' escape '!' "

When I run a query to check it works fine:

$>select TABLE_NAME from dba_tables where TABLE_NAME like 'A!_%' escape '!';

TABLE_NAME
------------------------------
A_...........
A_..............
A_...............

3 rows selected.

But when I run the import using the par file, i keep getting

ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-01740: missing double quote in identifier

View 4 Replies View Related

Upgrading From 10.2.0.4 To 11.1.0.7?

Sep 16, 2010

We have downloaded the 11.1.0.7.0 version from the below link

[URL]

The downloaded dump name is win64_11gR1_database_111070.zip.This dump is intended for Windows 2008.

we have installed this dump on Windows 2003 and upgraded from 10.2.0.4 to 11.1.0.7 .

In the process we have not encountered any issues. Whether the steps we followed would suffice for an upgrade from 10.2.0.4 to 11.1.0.7 or Should i go for 11.1.0.6 base version installation and apply 11.1.0.7 patch set.

View 8 Replies View Related

ODP.NET :: Upgrading From Version 10 To 11

Jun 6, 2013

We have several applications hosted on a server using ODP.NET 10, but we are the first to decide to upgrade to ODP.NET 11 which means we need a method where only our application uses ODP.NET 11 without affecting any other existing applications.

I've read about the policy files which automatically redirects application to use latest version installed on the machine. Is there a method available which can avoid this situation as the owners of other application may not allow this to happen.

How can I ensure that my application is using ODP.NET 11 or ODP.NET 10 if both are installed? I created two sample app one with Oracle.DataAccess.dll 10.2.0.100 and other one with Oracle.DataAccess.dll 2.112.3.0. With below line of code, I found both applications are showing Oracle.DataAccess 2.112.3.0 at runtime.

System.Data.Common.DbProviderFactories.GetFactoryClasses();

Last thing, I may be wrong saying latest ODP.NET wouldn't work with NHibernate 1.0.3.0. please validate.

View 4 Replies View Related

Server Administration :: Upgrading From 9.2.0.7 To 11.1.0?

Feb 15, 2011

I am upgrading oracle database from 9.2.0.7 to 11.1.0 (clients need 11.1. andnot 11.2).

Metalink tells me that I can do a direct upgrade and don't have to go to 9.2.0.8. so that's good news. Since time is of essence here : )

I ran the utlu111i.sql.

And made the following changes, per its recommendation.

Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--> "log_archive_start"
--> "max_enabled_roles"
--> "parallel_automatic_tuning"
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"

ISSUE 1:I already have a sysaux tablespace in my db, but the log still says, SYSAUX Tablespace:

[Create tablespace in the Oracle Database 11.1 environment]
**********************************************************************
--> New "SYSAUX" tablespace
.... minimum required size for database upgrade: 500 MB

ISSUE 2:I copied the 9i orapw file to the 11g $ORACLE_HOME/dbs location but when I try to login, using the same login (after I source the new profile) it still asks me for username/password. Doesn't allow remote sysdba login ? DO I NEED TO DO SOMETHING SPECIAL WITH THE PASSWORD FILE ?

ISSUE 3:Here are the steps I took before I get the next error:

I copied the init file from 9i location to the 11g location made the above changes in the init file.

I set the compatible to 10.1.0.

Added diagnostic_dest and got rid of bdump, udump and cdump

Then I shutdown the db (9i) I sourced the 9i profile (IS THIS TRUE OR SHOULD I SOURCE THE 11G PROFILE ?), and tried to start the db using startup upgrade (my changes have been made to the 9i init file and that is the one I am using to start the db with in the upgrade mode, is that ok ? ) I GET THE FOLLOWING ERROR SP2-0714: invalid combination of STARTUP options

View 11 Replies View Related

Server Administration :: Upgrading From 9i R1 To R2?

Nov 30, 2010

Need to clarify upgrade procedures from Oracle 9i R1 (9.0.1.0.0) to Oracle 9i R2 (9.2.0.3.0). Do we need to first upgrade to 9.2.0.1.0 (as base) before proceeding to patch it by version 9.2.0.3? Or could we patch it directly from 9.0.1.0 to 9.2.0.3?

View 3 Replies View Related

Server Administration :: Upgrading From 10.2.0.1 To 10.2.0.4?

Apr 25, 2011

I am upgrading my server from 10.2.0.1 to 10.2.0.4. in DST check the timezone values returned is 2 and not 4. I have checked using utltzpv4.sql and the jobs returned are as below.

Owner table_name Column_Name.
SYS SCHEDULER$_JOB LAST_ENABLED_TIME
SYS SCHEDULER$_JOB START_DATE
SYS SCHEDULER$_WINDOW LAST_START_DATE

I dont have any userdata using TSTZ or TSLTZ.

View 3 Replies View Related

Forms :: Error After Upgrading To 10G?

Mar 23, 2011

So I have an extremely weird error that I just found after several month of being upgraded to 10g from 6i. Right now I have several data blocks where users input data. The field that they input into is fairly long, so we give them the option to double-click which opens up the editor.

Now, if they do this when entering the field for the first time, everything works great. However, if they save, then decide to go back into the data block and edit the field, they can edit it in the text just fine. However, if they double-click and bring up the text editor, after they click ok (or cancel) it jumps back to the first data block.

What is more weird is I can't get it to happen on my own machine, only when it is running on the unix server. On top of that, I was able to avoid the issue by simply showing a message saying "field is about to be edited" and making them click ok. Of course, it's a work-around

View 5 Replies View Related

SQL & PL/SQL :: ORA-01843 After Upgrading To ORACLE 11.2g

Sep 12, 2011

I just upgraded my oracle DB version from 9 to 11.2g with the assistance of a DBA. The upgrade went fine, and all the data transfered as it should.

The only problem that I got is that almost every query that I try to run via my PL/SQL developer throws the ORA-01843 error. I checked the NLS-lang property from the previus DB and it is the same as the new one. The DBA says that the problem is in the PLSQL properties (althogh I didn't change them).

View 9 Replies View Related

Upgrade :: Upgrading Database From 10.2.0.1.0 To 10.2.0.4.0

Sep 6, 2013

When 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

View 8 Replies View Related

Server Administration :: Upgrading To 10g 10.2.0.2.0 Or Higher

May 8, 2010

where I can download the software for upgrading to 10g 10.2.0.2.0 or higher, but not 11g. I am not going to install 11g. Currently, I have 10g 10.2.0.1.0 and I have Windows XP. I don't consider to install 11g.

View 3 Replies View Related

Server Administration :: 10.2.0.5 - Upgrading Only 1 Database?

Feb 16, 2011

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 Related

Forms :: Upgrading Java With Reports 6i?

Feb 16, 2010

We currently are running Forms and Reports 6i.

We intend upgrading Java to jre 1.6.0_14. Would this have any impact on our environment? Can we safely go ahead with the upgrade?

View 2 Replies View Related

Upgrade :: Upgrading From 10.2.0.5 To 11.2.0.3 - Password Concern

Jul 29, 2013

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? 

View 2 Replies View Related

Application Express :: Error Upgrading From 4.0.1.00.03 To 4.1.1?

Aug 27, 2012

I receive this error. In my opinion the problem could be related to the presence of one personalized authentication schemas, based on a DB function, taken from a Packaged application, some years ago, called "menu_framework".
This is the error report:
........
-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
begin
*
ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x26962168], [0x1A1042F4], [], [], [], [], [], [], [], [], []

1) after the error trap, I copied the Image folder and tried to launch APEX. It was possible to lunch the development pages, but impossible to execute any application with the error: Authentication Schema not Supported
2) then decided to downgrade to APEX 4.0, following the proper instructions: received a similar error:
.......
SQL> exec apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000
');
BEGIN apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000');
END;

ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x16D5D9E4], [0x27F2074C], [], [], [], [], [], [], [], [], []

The execution of application reported the same problem.Then decided to restore the entirre DB.

Where is my problem?Are my suspects real or the Authentication schema malfunctiong is a conseguence of the upgrade error?

View 4 Replies View Related

Out Of Process Memory Error When Upgrading From Oracle 9.2.0.8 To 11.2.0.2

Apr 7, 2012

I got the following error when upgrading from Oracle 9.2.0.8 to Oracle 11.2.0.2 version using catupgrd.sql script.

=================================================================
CREATE OR REPLACE PACKAGE BODY kupm$mcp wrapped
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ERROR:
ORA-03114: not connected to ORACLE

SP2-1519: Unable to write to the error log table sys.registry$error
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8168 bytes
(callheap,kcbtmal allocation)
Process ID: 81984
Session ID: 1 Serial number: 5

==========================================================

My machine environment is:

UNIX AIX 5.3 level 12
Oracle 11.2.0.2
RAM size 2GB
ulimit settings:
> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) unlimited
coredump(blocks) 2
nofiles(descriptors) unlimited

Currently i tried to increase SGA & PGA to possible extent, but still getting this error? Is there any change required in ulimit, RAM etc?

View 1 Replies View Related

Server Administration :: Upgrading The Database To 11g From Oracle 8i?

Aug 27, 2013

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 Related

Automatic Storage Management :: Upgrading From 10g Raw Devices To 11g?

Dec 27, 2012

We have a 2 node rac cluster running on HPUX Itanium platform running oracle rdbms 10.2.0.4 that is currently configured using raw devices for ocr, voting disk, and all of the datafiles. We have a business requirement that is mandating that we have to use TDE tablespace encryption and in order to do so we must now upgrade to 11g.We are in the planning stages for the upgrade process and I am just trying to understand or find out what is going to be the best method to move the data that is currently in the tablespaces on the raw devices over to new tablespaces that will be created within ASM and will be created as TDE encrypted tablespaces?Our database is about 1.8 TB and we have alot of fairly large critical transactional tables that support a 24 x 7 oltp environment that cannot afford downtime.

View 2 Replies View Related

Upgrade :: Upgrading The 11g Database Using Dbua Utility?

Apr 22, 2013

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 Replies View Related

Forms :: After Upgrading To 11g / FRM-21011 - PL/SQL Unhandled Exception ORA-06508

Mar 16, 2012

After our client upgraded to 11g database and application server, they are getting this error while trying to access another form from the option menu (The option menu is generated with a library, the values are taken from a database table). This issue occurs only in one particular scenerio, and only in on form, other forms with similar functionality and same structure are working perfectly fine. The error is written below.

FRM-21011: PL/SQL unhandled exception ORA-06508

I tried in my environment (10G), no error exist there.In 11G environment, I tried re-attaching a library in the form and compiling again, the error does not come after recompiliation. But the client can still see the error even after recompiling the form (after reattaching that particular library).I could find the below info on google:

FRM-21011: PL/SQL unhandled exception %s.
Cause: An unhandled exception occurred while executing a menu trigger.
Action: Examine the text of the exception in this message. If this indicates a cause,
correct it. If the problem persists, contact Oracle Support Services.
Level: 25
Trigger: None

I am using form builder 10G, will compiling the form using Form builder 11G?

View 4 Replies View Related

Precompilers, OCI & OCCI :: Recompile Required When Upgrading From Oracle 9i To 11g

Dec 14, 2011

We are considering upgrading our current system from Oracle 9i to 11g. The current operating system is SUSE Enterprise 9.

The 11g requirements say an update to SUSE Enterprise 10 is required to support the Oracle 11g installation.

Will I need to recompile my existing application programs which use pro C precompiler to create code that accesses the Oracle database when I upgrade the operating system and database?

View 1 Replies View Related

Application Express :: Charts Not Displaying After Upgrading To HTML5 In 4.2

Feb 20, 2013

I just upgraded my APEX 4.0 application to 4.2, and ran the utility to upgrade my charts to HTML5. After completing the upgrade, I noticed my charts no longer displayed in the region.

I am currently using IE9 to view the application, since that's the browser over 90% of my users have. Is there something more I need to install?

View 4 Replies View Related

Application Express :: Upgrading To 4.2 On XE 11.2  / Blank Login-Page

Oct 24, 2012

I installed APEX 4.2 over XE 11.2

The Installation process succeeded.I Used the Installation Guide -> and followed the steps from chapter 3...My problem after the Apex-Upgrade ->

The page URL.... is blank, or say it better, ... there is nothing visible on that page (no Login-Form)The original GetStarted page from XE Database -> URL.... shows an Error Error Error processing request.ORA-01403: no data found

I can post the sourcecode from the "blank" HTML-Page...

View 20 Replies View Related

Server Administration :: Upgrade Oracle 9.2.0.1.0 From RHEL4 Platform To Oracle 11g Rel 2 On RHEL5 Platform

Feb 4, 2012

Can I directly upgrade Oracle 9.2.0.1.0 From RHEL-4 platform to Oracle 11g Rel 2 on RHEL -5 platform?I have the export dump and cold backup of Oracle 9.2.0.1.0 database.

View 11 Replies View Related

Real Application Clusters :: Upgrading From 10g2 Standalone To 11g2 RAC

Oct 17, 2012

I am doing a upgrade from 10g2 standalone (with out ASM) to 11g2 2 node cluster (on ASM) and the database is some what 1TB of the size. My problem is if I do a export and import the live system need to be down for over an a day. is there a better way of doing this and how ?

View 6 Replies View Related

Export/Import/SQL Loader :: Upgrading 9i Database To 11g That Supports 3rd Party Software

Apr 30, 2013

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?

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved