database upgrade to 12c

[Roshan]

Hello Erman,

I am performing a database upgrade to 12c.

https://oracle-base.com/articles/12c/upgrading-to-12c

I am getting a blank wizard.(Oracle 11g is already specified)

upgrade.PNG

Regards,
Roshan

[ErmanArslansOracleBlog]

Check your /etc/oratab.
You probably don't have the necessary record for your database, there.

[Roshan]

I have already set the oratab. The environment variables also.

environment variables
export ORACLE_HOME=/app/PMTG/db/tech_st/12.1
oraprod#export PATH=$ORACLE_HOME/bin:$PATH
oraprod#export ORACLE_SID=PMTG

When I click 'Next', wizard does not proceed.

pastedImage_0_(1).png

Thanks

[ErmanArslansOracleBlog]

What is the platform that you are executing the dbua?

Is it windows ? I m asking this because I don't see any Xming or VNC connection in your screenshot..
Your ORACLE HOME seems Linux style but I will ask you a question.

[Roshan]

It is AIX. I am using Mobaxterm. I have exported DISPLAY on putty and it opened.

[ErmanArslansOracleBlog]

Try VNCserver or Xming.

Are you able to reproduce the issue there?

[Roshan]

I will try it and update. Is upgrading with scripts easier than dbua?
https://oracle-base.com/articles/12c/upgrading-to-12c

[ErmanArslansOracleBlog]

It was in earlier releases. But for 11g or 12c upgrades, I prefer dbua..

[Roshan]

I am getting
# xhost +
Xlib: connection to "10.105.10.160:0.0" refused by server
Xlib: No protocol specified

1356-200 xhost unable to open display "10.105.10.160:0.0"

[ErmanArslansOracleBlog]

This is one of the standard X errors Roshan..

You know what.
Install vncserver to the server and use vnc viewer to connect to it and retry.

[Roshan]

Hello Erman,

I can't use DBUA for  this upgrade. X-11 forwarding is not supported for this system. I executed the script
catctl.pl

https://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE 

The instance freezes. I contacted the os Admin, they are telling me

There were errors on paging. The system crashes as the Database start due to memory usage and Virtual Memory settings.

Do I increase the memory in database?

Regards,
Roshan

[ErmanArslansOracleBlog]

System Crashes? You mean OS right? 

If your OS admins say, the server is crashing / hanging because of a paging, then it seems you don't have required amount of Memory on your machine. So if that's the case, you need to decrease the SGA, increasing will trigger more paging.

Ask OS admin to give the details about this paging issue.

2016-12-08 12:08 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hello Erman,

I can't use DBUA for  this upgrade. X-11 forwarding is not supported for this system. I executed the script
catctl.pl

https://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE 

The instance freezes. I contacted the os Admin, they are telling me

There were errors on paging. The system crashes as the Database start due to memory usage and Virtual Memory settings.

Do I increase the memory in database?

Regards,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/database-upgrade-to-12c-tp1530p1705.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Roshan]

I have checked the memory. I think it is ok
oraprod#svmon -G -O unit=GB
Unit: GB
--------------------------------------------------------------------------------------
               size       inuse        free         pin     virtual  available   mmode
memory         15.6        4.17        11.4        1.31        3.58       11.4     Ded
pg space       19.8        0.02

               work        pers        clnt       other
pin            0.84           0           0        0.47
in use         3.58           0        0.59


I will check with the os admin about the paging issue