?
Solved

Upgrade to 10gR2 from 9.2

Posted on 2006-05-18
13
Medium Priority
?
2,258 Views
Last Modified: 2008-03-10
Hi guys,

I am doing an upgrade from 9.2 to 10gr2, box is solaris 10.
Have already installed 10gr2 and its working fine there, a small db have already created there using exp/imp,

but since yesterday I have started an upgrade 60 gb of db, everyting works fine,

have startup upgrade command,

created the new tbsp AUX and then executed the upgrade script:

@catupgrade.sql

yesterday 05/17 at 3:00 pm and since now it is still running, can't say what is the problem,
is there anyone who is aware of this kind of problem, that this script hanged for so long...

giving an excertp from the alert.log file: tail -f alert.log

tail of alert.log

Thu May 18 07:28:45 2006
Incremental checkpoint up to RBA [0x4ec.11a25.0], current log tail at RBA [0x4ec.11a25.0]
Thu May 18 07:59:05 2006
Incremental checkpoint up to RBA [0x4ec.11a44.0], current log tail at RBA [0x4ec.11a44.0]
Thu May 18 08:29:25 2006
Incremental checkpoint up to RBA [0x4ec.11a65.0], current log tail at RBA [0x4ec.11a65.0]
Thu May 18 08:59:45 2006
Incremental checkpoint up to RBA [0x4ec.11a82.0], current log tail at RBA [0x4ec.11a87.0]
Thu May 18 09:30:04 2006
Incremental checkpoint up to RBA [0x4ec.11aa7.0], current log tail at RBA [0x4ec.11aa7.0]

a little from begining of alert.log

ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY;
Wed May 17 15:47:27 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN MIGRATE
Wed May 17 15:49:54 2006
CREATE TABLESPACE sysaux DATAFILE '/db/db01/oradata/stg1/sysaux01.dbf'
SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
ONLINE
Wed May 17 15:50:05 2006
Completed: CREATE TABLESPACE sysaux DATAFILE '/db/db01/oradata/stg1/sysaux01.dbf'
SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
ONLINE
Wed May 17 16:11:40 2006
Beginning log switch checkpoint up to RBA [0x4e9.2.10], SCN: 4317919789
Thread 1 advanced to log sequence 1257
  Current log# 5 seq# 1257 mem# 0: /db/db01/oradata/stg1/redo05a.log
  Current log# 5 seq# 1257 mem# 1: /db/db01/oradata/stg1/redo05b.log
Wed May 17 16:16:51 2006
Completed checkpoint up to RBA [0x4e9.2.10], SCN: 4317919789
Wed May 17 16:17:52 2006

Require any one assistance, who has experienced of this kind of behaviour,
thanks in advance...
0
Comment
Question by:fouaddba
  • 7
  • 6
13 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 1500 total points
ID: 16709168
To run catupgrade.sql
you have to make sure that:
1. SYSTEM tablespace has at least 10 Mb free
2. SHARED_POOL is at least 150 MB
3. JAVA_POOL is at list 150 MB

Create an init.ora from SPFILE and change the values ov 2. and 3.
Using OEManager make sure 1.

It is unusual such a time for execution catupgrade.sql
 script.

Turn of the instance and begin again.
0
 
LVL 2

Author Comment

by:fouaddba
ID: 16709213
first thanks, but the space and all the SGA resources are more then enough

SQL> show sga

Total System Global Area 1593835520 bytes
Fixed Size                  1978976 bytes
Variable Size             771755424 bytes
Database Buffers          805306368 bytes
Redo Buffers               14794752 bytes
SQL>

so you are suggesting, to shutdown this process and starts again...
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16716755
i hope it is so,
but I can not see SHARED_POOL and JAVA_POOL size.
In 10g there is a famous fat Listener bug:

This is the typical 10g trap.

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Thats all.

After fixing this make sure that you connections to the instance run smootly.

Restart the instance and try again. check again the prerequisites fopr running catupgrade.sql
.
Create a log file and see the progress:

SQL>spool /u03/upgr.log
SQL>@   .../catupgr.sql
SQL>spool off

If there are errors you will see them in the log also.

I just upgraded 3  10g R2 Instances on Linux - had no problems at all!
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 48

Expert Comment

by:schwertner
ID: 16716762
Check also Kernel and Root user prerequisites for Solaris Oracle installations.
0
 
LVL 2

Author Comment

by:fouaddba
ID: 16718204
thanks schwertner,

but this is the status:

. first I tired with manul upgrade, it stucked at this location and doesn't move at all...

-- Load all the Java classes
begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
2 initjvmaux.rollbacksetup;

this is the location where it stucked when I first asked the question, next day I killed the session and
tried to do it with dbua, was looking a the log and the same thing happen,

after coming to 73%, it stucked at the same location:

-- Load all the Java classes
begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
2    initjvmaux.rollbacksetup;

we left yesterday, and today still it was there, stoped it and starts again,
now unchecking the OEM repository box and again it went fine,

but tell you one thing it was keep giving some sys.... table constraint violation errors...and I was ignoring it,
then it reached at 85% and I can see it is the same place, is it amazing....as usuall nothing GOOD response from Oracle support.

-- Load all the Java classes
begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
2    initjvmaux.rollbacksetup;


Can't say what to do...?


0
 
LVL 2

Author Comment

by:fouaddba
ID: 16718264
and one more to add, the alert log, in all the 3 instances looked liked this:

SERVER COMPONENT id=CATPROC: timestamp=2006-05-19 09:55:35
Fri May 19 09:56:02 2006
Incremental checkpoint up to RBA [0x4f2.13999.0], current log tail at RBA [0x4f2.1a114.0]
Fri May 19 09:56:40 2006
SERVER COMPONENT id=RDBMS: status=VALID, version=10.2.0.1.0, timestamp=2006-05-19 09:56:40
Fri May 19 09:57:32 2006
create rollback segment MONSTER2 storage (initial 2 m next 2 m maxextents unlimited)
Fri May 19 09:57:32 2006
Completed: create rollback segment MONSTER2 storage (initial 2 m next 2 m maxextents unlimited)
Fri May 19 09:57:32 2006
alter rollback segment MONSTER2 online
Completed: alter rollback segment MONSTER2 online

what do you think the problem is...
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16718977
What do you mean saying MANUAL UPGRADE?

Of the DB?

The best way to do Upgrade is Export/Import way!
I have posted many instructions here how to do this.
0
 
LVL 2

Author Comment

by:fouaddba
ID: 16719140
no I know, that is the best way and I did it too for my small db, 45gb,

but these 2 are 1.2tb & 2.9tb, they are pretty big,

that's the reason was using first manual upgarde and then dbua...but none worked...:-(
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16731811
If you have Metalink account call Oracle Support.
Also plan export/import way - schema by schema.
It is the most reliable way.
0
 
LVL 2

Author Comment

by:fouaddba
ID: 16737658
thanks, I am also in contact with them:

SR Number       5436801.992         Open Date       18-MAY-06 14:35:03
Support Identifier       1547029         Name       Syed Hashim
Severity       4         Last Update       22-MAY-06 14:32:17
Product       Oracle Server - Enterprise Edition         Product Version         10.2.0.1.0
Platform       Solaris Operating System (SPARC 64-bit)         Detailed Status       1st Callback
SR Reference         n/a         BUG Reference       n/a

but as usual nothing happend yet....
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16740126
I have indications that the upgrade is very long process.
May be you have to start it and to wait patiently for result.
Nevertheles try to backup the DB for security reason.
0
 
LVL 2

Author Comment

by:fouaddba
ID: 16742285
but more then 17 hours for a small db of size 60gb... I don't think so,

and the most important all the 3 sessions hung/stuck at the same place for that much long,
still struggling with Oracle support, but I think got to resolve it by myself, lets see;

-- Load all the Java classes
begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
2    initjvmaux.rollbacksetup;

and same type of messeges in the alert.log too, there must be something wrong,
where, can't say at this point in time...

what do you suggest over here, what is the best way to resolve this situation, because I know that I can do exp/imp,
but now I don't want to, want to upgrad w/out using exp/imp.

and thanks for your concern, schwertner, you always upgrade using exp/imp or ...?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16742799
May be you have an upgraded Oracle version (9i, 10g) but you have upgraded only the software. After upgrading the software you have also to upgrade the Dictionary.
If this is not done usually the DBA got a defect instance.

Seems that your java machine is not working.
The prerequisites
JAVA_POOL at least 150m
same for SHARED_POOL is very important.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question