Server Administration :: Discrepancies In SYS / SYSTEM Object Counts After Migration

May 3, 2010

We had a new outsourcer who completed migration of 1 of our system running under Oracle10g-Solaris 10. We created an inventory script that will list all objects counts of SYS, SYSTEM and ORACLE and all other schemas. This script will be ran before (old server) and after migration (to new server). After migration to the new & bigger server, we noticed from the output of the inventory script for SYS/SYSTEM object counts had been reduced compared from the original/actual value (from the old server). Our outsourcer said that this is not an issue since SYS/SYSTEM objects are not transactional and cannot be controlled.

As we will conform that the migration was completed successfully by our new outsourcer.

View 7 Replies


ADVERTISEMENT

Server Administration :: DB Migration From 9i To 10g?

Feb 1, 2011

i have to migrate the current production database to test 10.2.0.4 on windows. Any non-export way to upgrade 9i to 10 g?

i have following steps me know if i am wrong?
1) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
2) shutdown oracle 9i database on server A
3) copy database file, controlfile, redolog, and other files to new server B
4) alter the controlfile backup with new location of bdump, udump, and log file and data file locations
5) user oradim ORADIM -NEW -SID SID [-INTPWD PASSWORD ]-MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOMEDATABASEINITSID.ORA
6) start dabase in upgrade mode
7) run catpat.sql and util102.sql take backup
9) open database for users

View 4 Replies View Related

Server Administration :: Use Of Views In Migration

May 6, 2011

Can we use views for real time migration? If yes then will you prefer to perform migration using views?

View 3 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

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

Server Administration :: Oracle DB Server Migration Checklist

Apr 11, 2012

We will be having a meeting with our client regarding their Database Server Migration (They are planning to buy a new server). Their current database is Oracle 10gR2, they will not upgrade to 11g, they just plan to migrate to a new more powerful machine.

I was planning to ask the following questions.

1. Specifications of the current server and the new one.
2. Operation system (I think they will use same OS, just an updated one)
3. Can the business afford full downtime on current servers?
4. Size of the DB, because it can take hours to move large files.

And is there documentation regarding Server Migration (Change of machine only, not database upgrade or anything,

View 5 Replies View Related

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

Server Administration :: Data Migration Between Two Different Application?

Mar 9, 2011

We are planning to migrate data from an application called clintrace to another application called argus safety. Both the applications are related to pharmacovigilence safety operation. Both the applications functionality are similar. So both the database are having the same data though the table structures might be different. Both the database are oracle clintrace db is 9i and argus db is 11g.

View 8 Replies View Related

Server Administration :: Migration Of Oracle Jobs

Nov 22, 2010

Recently we are planning to migrate oracle 10g to 11g. We are migrating PHASE WISE (Schema wise) as this is a 50TB of Production instance. We are using Oracle Golden gate for this purpose.

Is there is any way that we can migrate oracle jobs from 10g to 11g?

View 6 Replies View Related

Server Administration :: How Segment Different From Object

Dec 26, 2012

Are the terms object and segment same ? what are the differences between them? what are similarities between them?

View 3 Replies View Related

Server Administration :: Migration Of Oracle 10gR2 To 11gR2?

Jun 23, 2010

I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.

For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?

OS; solaris sparc 10

Oracle 10g: 10.2.0.1.0

oracle 11g: 11.2.0.1.0

View 1 Replies View Related

Server Administration :: How To Query A Tablespace Being Used By Which Object

Jul 6, 2013

My Oracle db have this tablespace named INDX which is 80% full. I tried to query on the table, user using it but there is no one using this tablespace

May I know if there is a query that i can used to find out which dba_object is consuming the 80% of this tablespace.

View 5 Replies View Related

Server Administration :: Object Created In Different User?

Jul 15, 2010

Whenever I create a table using login A, the table gets created successfully. But when I query the dba_objects, the object owner is different, login B. What might be the reason behind this?

View 9 Replies View Related

10g RAC HP-UX To AIX Cross Platform Migration Along With Raw File System To ASM Conversion?

May 7, 2011

We got a request from Customer to migrate a RAC database of size 1.8TB from HP unix raw file system to AIX ASM with a min downtime. I have seen lot of methods of doing cross plat form migration and non-ASM to ASM but not together.

Do we have any proven method for migration such cross platform migration with raw file system to ASM conversion in a single go with min downtime?

View 1 Replies View Related

Server Administration :: System TableSpace Is So Big?

Sep 26, 2011

Today I see my system tablespace is 98%, 480 MB used. Why the system tablespace is so big?

View 5 Replies View Related

Server Administration :: System Tablespace Had Been Used More?

May 4, 2012

In my database ,the size of the system tablespace is 1024M.now i found its free space is 477.875M.

SQL> SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024 M FROM DBA_FREE_SPACE where tablespace_name = 'SYSTEM' GROUP BY TABLESPACE_NAME ;
TABLESPACE_NAME M
--------------- -------
SYSTEM 477.875

In system tablespace ,the max size segment is IDL_UB1$,it is 167M

SQL> SELECT SEGMENT_NAME, SX || 'M' "Size" FROM (SELECT SEGMENT_NAME,SUM(BYTES)/1024/1024 SX FROM DBA_SEGMENTS WHERE TABLESPACE_NAME = 'SYSTEM' GROUP BY SEGMENT_NAME) WHERE SX > 100 ORDER BY SX DESC;
SEGMENT_NAME Size
------------- -----
IDL_UB1$ 167M

QUESTION: what's the table IDL_UB1$ used for ?

View 4 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

Server Administration :: Non-expiring SYSTEM And SYS Password

Aug 27, 2012

that's what I did:

SQL> select profile from DBA_USERS where username = 'SYSTEM';

PROFILE
------------------------------
DEFAULT

SQL> alter profile DEFAULT limit password_life_time UNLIMITED;

Profile altered. But I get still the warning message every login. ORA-28002: the password will expire within 7 days.

$ sqlplus system/oracle111@XE
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 27 10:29:03 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

View 2 Replies View Related

Server Administration :: OFA And Raid System For Oracle

May 5, 2011

Can I use OFA and Raid system together for Oracle 11g in Windows 2008 Server? I am installing the OS in C drive. Where to install the oracle, location for Oracle_Base, number of logical and physical drive required, size of each etc.

I am planning to use
Raid 1 - Controlfile, redolog file and archive log file
Raid 1+0 - Datafiles

Also I want to multiplex virtual memory page also.

View 6 Replies View Related

Server Administration :: System Tablespace Resize?

Dec 23, 2012

My system tablespace size is 800mb and it sends an alert saying that it has exceeded 80% of its usage.However its total max size is 30gb.

FYI
Its autoextensible is set to 'YES'.
2 Node RAC database.
File system is ASM

My question here is... is it advicable to resize a system tablespace to some size when autoextensible is set to 'YES'
or genrally can we resize a system tablespace when autoextensible is set to 'No' ?

SQL> col FILE_NAME format a40
SQL> /
FILE_NAME BYTES/1024/1024 AUT MAXBYTES/1024/1024
---------------------------------------- --------------- --- ------------------
+DATA/ge01114/datafile/system.556.2254454 800 YES 30000.9844

View 4 Replies View Related

Server Administration :: Why Can't SYSTEM Tablespace Extend

Mar 19, 2010

The SYSTEM tablespace refuses to autoextend (3 segments in SYSTEM tablespace unable to extend). It sits on its current size of 559MB (auto set to 2GB, increment 10M).

I guess there are no free extends that are that big as 10M.

View 5 Replies View Related

Server Administration :: System View Cannot Found

Feb 22, 2012

There are some sys views can not found. why?

SQL> connect / as sysdba
Connected.
SQL> show user;
USER is "SYS"
SQL> desc dba_users;
ERROR:
ORA-04043: object dba_users does not exist

View 2 Replies View Related

Server Administration :: Sys Password Changed By System?

Feb 18, 2010

Here is an article to show a case when SYS password is changed by SYSTEM:

[URL]....

This behavior is not working on all the environments.

View 10 Replies View Related

Server Administration :: Collect Object Stats - When Enough Of Data Has Changed

Aug 29, 2013

Quote:Oracle collects new statistics when enough of the data (about 10%) has changed.I read the above statement in the oracle documentation that Oracle collects new statistics when enough of the data (about 10%) has changed every day during 10 pm to 6am .

But still i see some object statistics are stale and empty.Do i need to collect statistics for these objects manually ? and would like to know why these objects statistics were not collected during maintenance window ?

View 4 Replies View Related

Server Administration :: How To Identify Object Residing In Which Datafile In Tablespace

Mar 6, 2011

I have create one table emp under scott schema, and this schemas default tablespace is USERS and this tablespace has 3 datafiles.

Now how do I identify the object EMP is residing on which datafile in USERS tablespace?

View 2 Replies View Related

Server Administration :: Move File System Datafile To ASM

Oct 23, 2012

I mistakenly added a datafile to a tablespace which is asm, however the datafile was created in a default location and not the asm location:

alter tablespace pdaiidata1 add datafile '<filename>' size 2048M;

What I should have done:

alter tablepsace <tablespace_name> add datafile '+DATA1' size 2048M;

Is there any way to move this filesystem datafile into the asm tablespace? In previous Oracle versions, I've taken a tablespace offline, moved a datafile, renamed it, then brought the tablespace back online. Can I do something similar here in this situation?

View 4 Replies View Related

Server Administration :: Reduce The System Tablespace Size?

Aug 6, 2011

how to reduce the system tablespace size

my system01.dbf size is 6gb

i want reduce from 6gb to 2gb

View 3 Replies View Related

Server Administration :: System And Users Table Space

Oct 15, 2011

a newbie dba here..

select TABLESPACE_NAME,
sum(BYTES) Total_free_space,
max(BYTES) largest_free_extent
from dba_free_space
group by TABLESPACE_NAME
/

result output is attached .txt file.

the SYSTEM & USERS table space shows only <10 mb free space. Is it a bad sign? What I should do ?

View 7 Replies View Related

Server Administration :: System / Manager Not Accessing In Oracle9i?

May 31, 2010

Recently i am installed oracle9i in my laptop.In oracle scott/tiger accessing. But system/manager not accessing.

View 4 Replies View Related

Server Administration :: ORA-04021 / Timeout Occurred While Waiting To Lock Object

May 25, 2011

When i try to compile a package, im getting below error.

ERROR at line 1:ORA-04021: timeout occurred while waiting to lock object

i gave below query and found the sid of object.

select * from v$access where object='THINKING_PKG'

From v$session view,i found sid and serial# and at same time i queried dba_jobs and saw one jobs is running at this time.Now how to compile this object.

View 26 Replies View Related







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