Upgradation And Migration Of 9i Database On HP-UX OS To 10g Database On Solaris Environment

Dec 29, 2010

I am part of a upgradation and migration proj where an Oracle 9i db on a HP-UX OS is going to be upgraded and migrated as 10g db on a solaris OS environment.I am from the application team(Data warehouse team) and we are yet to allocate a specific DBA for taking care of this activity.

We are still in the requirements stage...different requirements and challenges that should be taken care and would occur in the roadmap of this project from a DBA perspective.All your inputs would be very valuable to me.

View 2 Replies


ADVERTISEMENT

Server Administration :: Migration Of Oracle From AIX To Solaris

Jan 4, 2013

We have to migrate our database from current OS (AIX 5.3) to Solaris 10. We'll do it through expdp / impdp. Is there any other way to do it as well?

Also, we have dataguard configured at current setup. So is there any way we can take backup of existing database at DR & restore it at new server (Solaris) or we'll have to take a fresh backup from DC (after migration) & ship it to DR & create a new standby?

View 8 Replies View Related

Two-node RAC Database Running On Solaris 5.8

Jun 1, 2013

We have an Oracle 9i (9.2.0.7) two-node RAC database running on Solaris 5.8. Recently we have switched our production database from no archive log mode to archive log. We changed the parameter CLUSTER_DATABASE=FALSE on one of the instances before converting and reverted back.why this parameter needs to be changed to false?

View 2 Replies View Related

Migrate Database From Linux To Solaris?

Sep 12, 2011

We are planning to migate Oracle database from Linux 10gR2 (non-ASM) to Solaris (ASM) and then Oracle upgrade that database from 10gR2 to 11gR2 on Solaris.

View 4 Replies View Related

Solaris 11 / Oracle Database Performance

Sep 16, 2013

We've been battling with very slow performance for some time. Herewith a detail description of the problem:

Solaris-11/ZFS/Oracle problem

We purchased Oracle T4-2 servers, and are experiencing some weird performance problems.

Hardware:
T4-2
2 x 600GB HDD per server
128GB memory per server
2 x dual port QLE2562 FO HBAs
IBM V7000 StorWyse data array
2 x CISCO MDS 9148 fibre optic fabric switches
Software:
Solaris 11.1
MPXIO
Solaris 10 branded local zones
ORACLE 10g Enterprise edition
Project for the oracle user:
user.oracle:100::oracle::process.max-file-descriptor=(basic,8192,deny);process.max-stack-size=(priv,32768,deny);project.max-shm-memory=(priv,21474836480,deny)

We received the first server and wanted to migrate our APPB application system and Oracle 10g Standard Edition database from our SUN T5240 to the T4-2.

T4-2 setup � Disk 0:
Global zone: Solaris 11.1 ( ZFS - whole disk for the root pool)
Local zones: On the Solaris 11 environment we built two branded Solaris 10 zones using an Oracle template provided on the Oracle website - solaris-10u11-sparc.bin.

Our complete database resides on the IBM data array, in UFS LUNs.The UFS LUNs were mounted onto ZFS mount-points in the root partition (/), and then LOFS mounted into the zones.

We started with the Solaris 11.1 environment.

1)After a day or two the performance of the database starts deteriorating rapidly. We then stop the database and reboot the machine. After the reboot the performance level is restored.
2)Another huge deterioration in performance happens when we unmount the V7000 LUNs, and reboot to the alternate Solaris, and re-mount the LUNs.
3)What further compounds the issue is that when we start another the database in the second zone, we see another huge performance degradation.
4)We have logged a call with ORACLE. They requested us to gather information which was analysed by them. They did not find anything wrong with the way ORACLE was installed and the setup of the instances.

On Disk 1 we did a Solaris 10 8/11 (Update 10) installation, which we patched with the April 2013 CPU patchset. In this Solaris 10 global zone we built two native Solaris 10 local zones. The Oracle 10g databases were built in the zones (same configurations settings) not in the global zone, onto UFS LUNs. The database in its entirety lives on the IBM V7000 data array. This works fine.

We then received our next T4-2 server.Loaded it again with Solaris 11.1, and upgraded to ORACLE 12c SE Release 12.1.0.1.0 - 64bit12xxx seeing that Oracle 10 is not certified on Solaris 11. To keep things simple, we built two small databases in the ZFS root pool. The complete system now resides on one disk no UFS LUNs to consider, no Fibre Optic fabric, no CISCO switches, no IBM data array, BUT we get the same problem. The system will run for some time and then slow down drastically. Starting the second database slows the system down abnormally.

View 1 Replies View Related

Server Administration :: Move Database From 10.2.0.4 (Solaris 9) To 11.2.0.2

Sep 17, 2011

I have to move a database from 10.2.0.4(solaris 9) to a 11.2.0.2(Solaris 10) . 11g shell database is ready .Its a 400GB database.

View 7 Replies View Related

RAC & Failsafe :: Test Environment - SAN Migration?

Feb 15, 2012

We have a RAC in a test environment.It's 2 nodes connecting to an IBM DS3512. The DS3512 has one pool of 8 hard disks (RAID10) which has been then sliced into logical drives:

2 x 1GB
then
2 * 400GB

I have been tasked with changing the current configuration as follow:

2 pools of 4HDs in a RAID10 configuration

Then from the first pool:
2 * 1GB
1 * 398GB

from 2nd pool:
1 * 400GB

What I intend to do:
1) shutdown
SQL> shutdown immediate;
./srvctl crs stop
2) backup
dd if=votingdisk of=voting_disk_backup
I already got backups of OCR in $CRS_HOME/cdata/crs/
3) Perform changes on SAN
4) recreate ocfs2 partitions
5) mount the disks to their folder.
6) recovery
recover voting from backup
recover ocr from backup
7) Turn service on again
./srvctl crs start
SQL> startup;

Would this scenario work. There can be some glitches like the disk names changing after the reconfiguration but I only need to modify fstab for that.

View 3 Replies View Related

Oracle Solaris 11 Database Control Failed To Start Set ORACLE_UNQNAME

Apr 20, 2013

Oracle Solaris 11
Oracle Database 11.2.0.3

Create a new database using dbca and at the end dbca reports it could not start database control.

The dbca warning window asks to set ORACLE_UNQNAME and to start database control again.

su - oracle
$ . oraenv
rcat
export ORACLE_UNQNAME=rcat
emctl stop dbconsole
emctl start dbconsole
failed...

I tried that and dbconsole still cannot start.

View 3 Replies View Related

Security :: Active Directory Authentication For Oracle 10g Database Running On Solaris?

Jul 25, 2011

I have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have already made sure that remote_auth = true and have created user in oracle with OPS$. But still I cannot connect.

I have the same setup but with oracle on windows server, the os authentication from windows clients works just fine.

does oracle 10g on solaris 10 supports windows os authentication?

View 4 Replies View Related

Server Utilities :: Using Expdp / Impdp To Migrate 4 TB Database From Solaris To Linux

Aug 4, 2011

I am using expdp/impdp to migrate 4 TB database from solaris to Linux.But the import process is taking forever.

View 13 Replies View Related

Installation :: Install Latest Release Of Oracle Database On A Solaris 11 Zone

May 11, 2013

which is really a HA zone clustered in VCS(not important for installation of the database).

What parameters do I need to set or change in the Solaris zone, there seems to be no /etc/system file.

View 3 Replies View Related

Migration Of Whole Database?

Dec 20, 2010

we are planning to do the migration from 10g to 11g and from old servers to new servers.

View 1 Replies View Related

Migration From VFP9 To Database

Jul 19, 2013

Migration from VFP9 to Oracle Database for my personal and microbusiness DBMS.

For a start, having installed Oracle ORACLE win64_11gR2_database (see Attached file) and logged in, how do I create a simple data table and how do I create a front end for the user - a "FORM" to get user input of name, date, bill no etc.,

Attached File(s)
ORACLE_win64_11gR2_database_Installer_Success_Files_Where_all_stored_Be_Cautious.jpg ( 194.7K )
Number of downloads: 1

View 1 Replies View Related

Standby Database Migration

Nov 19, 2012

I am migrating one of my live database from 10g to 11g, which is having its standby database.how can we migrate standby database as well in 11g. do we need to create standby database again or is there any steps?

View 3 Replies View Related

Database Migration With Oracle 9i?

Mar 18, 2013

I wanted to migrate my database from one of the Solaris machine to other solaris(High performance) machine.We are using oracle 9i database.

I wanted to take RMAN backup with oracle 9i database.and wanted to restore that database to other machine and perform recovery.This process will be on production database and requirenement is to reduce downtime.

let me know RMAN backup procedure which will have less downtime of the database.

View 4 Replies View Related

Data Guard :: Shutdown Down In Primary Database In Environment

Jun 29, 2010

I have configured data Guard on oracle 11gR2. It is working fine. The only issue i am facing is that when i am stopping the database on the primary server, it is taking a long long time to down the database.

Is it normal?

Furthermore, regarding backup i used veritas Netbackup to perform hotbackup. Can i still used the same principle.

View 3 Replies View Related

Data Migration From MySQL Database

Oct 31, 2008

I need to migrate data from Mysql database to Oracle11g database.

a) is there any method available to import the all the sqls like table script,constraint scripts,data(insert ) script from Mysql.so that we can apply the sql directly to the oracle schema after making necessary changes(like datatype).

b) Is there any free tool available for the migration.

View 1 Replies View Related

SQL & PL/SQL :: Database Migration Project To Oracle

Nov 8, 2010

I am working on database migration project SQL server to oracle, convert this query sql server to oracle basic thing i change but i still getting following error: ORA-01799: A column may not be outer joined to a subquery.


SELECT
h.unique_id,
h.customer_id, h.sequence_id, h.name_first, h.name_last, h.email,
h.tn_work, h.tn_home, h.tn_cell, h.tn_work_do, h.tn_home_do, h.tn_cell_do, h.primary_contact_id,h.ssn, h.created, h.customer_status_id, h.doi, h.dod,
NVL(CASE WHEN h.primary_contact_id = 1 THEN tn_home WHEN h.primary_contact_id = 2 THEN tn_cell
WHEN h.primary_contact_id = 3 THEN tn_work END, '') AS ext_primary_contact, ext_customer_status_desc FROM customer c
INNER JOIN customer_history h
[code]...

View 4 Replies View Related

Server Administration :: Reg Database Migration

Jun 26, 2012

I want to migrate our production database from 9.2.0.8.0 to 10.2.0.4.0 through startup migrate ,so request you to kindly provide me a step by step doc or some reference link pertaining with same.

View 2 Replies View Related

Performance Tuning :: Big Database Migration?

Jul 4, 2012

I have one big database which I need to migrate to Oracle, because it rocks with big databases, instead of other databases and when I was made transfer software and all works great except one more think. During this process I found that Oracle normally fill log & undo table, and my question is how to migrate (or can I migrate) database to oracle without filling undo database (deactivate this process) and after that to put database to work normally, because I just need to transfer data as is and from that point Oracle goes on...

View 4 Replies View Related

Replication :: Database Migration From HP-Ux To AIX Server

Oct 29, 2010

I am planning to move the databases in multi master replication from HP-Ux to AIX server. I am planning to use export/import to moving the database. But do I need to drop the replication administrator user before I do export/import?

View 1 Replies View Related

Server Administration :: Migration Of Database

Jan 20, 2013

currently holding 9i database on win2000 and front end is dev4.5 so the thing is want to upgrade by win2008 pn 32bit with 10gdatabase want to keep the front end application as it is 4.5...

will it be compiatble 10g database on 32bit 2008 and front end 4.5developer forms and reports?

can i migrate 9i database to 10g database, what are the steps for full import??

View 1 Replies View Related

Backup & Recovery :: Process Of Setting Up DR Environment For SAP And Oracle Database

Feb 7, 2012

We are in the process of setting up a DR environment for our SAP and Oracle databases . The netapp and our architects came up with solution as follows .

1.Standby databases are built for all production databases.
2.The SAP file systems are replicated to the secondary site
3.The Oracle logfiles and controlfiles are replicated by netapp snap mirror every 10 mins interval
4.The database is recovered through recover standby database every 15 mins at standby site
5.Please note there is no data guard involved .
6.To test the failover , the mirror is broken .The standby controlfile is replaced with Production controlfile and Redo logs files.
7.The standby database issued a startup comnmand and it worked .

Would like to know whether the step 6 is a correct approach ? I tried to convince the architects that this will result in a very disastrous situation for us but none is listened to .

View 3 Replies View Related

Ways Provided For Database Migration Except Datapump?

Jul 2, 2013

what are the ways provided by oracle for database migration,except datapump? and which one is recomended

View 1 Replies View Related

RAC & Failsafe :: Single Instance - Migration To Database

Oct 20, 2010

2 Database.

TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

View 4 Replies View Related

Oracle Database Migration From 9iR2 / 10gR2 To 11gR2

Apr 22, 2013

Which is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.

Current Environment
Server1
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 9.2.0.8 (32 bit)
Average Db Size: 600Gb
RAc Configuration: No
Server2
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 10.2.0.3 (64 bit)
Average Db Size: 600Gb
RAC Configuration: No

Proposed Environment
Server1 and Server2
Operating System: Sun Solaris 10
Oracle Database: Oracle Database Enterprise Edition 11.2.0.3 (64 bit)
RAC Configuration: No
Hardware is New : Yes

View 2 Replies View Related

Enterprise Manager :: Configuring Grid Alerts For Two Different Groups Based On Database Environment

Aug 12, 2010

i have implemeted grid control for monitoring database. we have different database environment like PROD , STAGE, TEST, BETA.

Now my requirement is, i need to configure PROD & STAGE alert for one group (group1@oracle.com) means, what ever alerts generated by grid should sent notification to group1@oracle.com and TEST AND BETA database alerts should to group2@oracle.com.

Now i am following the oracle manual to configure notifications. unfortunately i could not find to complete my requirement.

[URL]

did any one implemented alerts to send different groups.

View 2 Replies View Related

Oracle Standalone Database To (RAC) Real Application Cluster Migration

May 16, 2011

How to migrate Oracle Standalone Database to Oracle Real Application Cluster?

View 1 Replies View Related

Server Administration :: Oracle Database Migration From 11gR2 32bit To 64bit?

May 28, 2012

"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"

Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition

View 4 Replies View Related

RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment

Jan 24, 2011

We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?

View 3 Replies View Related







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