Home » RDBMS Server » Server Administration » Database version change (oracle 10.2.0.1.0,Redhat Linux 4.5 [Enterprise edition])
Database version change [message #442328] Sat, 06 February 2010 23:56 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Dear All,

i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard

please give me the steps, i need same tablespace,data's everything same as of now.

thanks,regards.
Re: Database version change [message #442329 is a reply to message #442328] Sun, 07 February 2010 00:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Reinstall Oracle.
You don't need to touch the database but reexecute catalog.sql after the install.

Regards
Michel
Re: Database version change [message #442334 is a reply to message #442329] Sun, 07 February 2010 00:33 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
thanks Mr.michel

but please explain in details, reinstall mean just could i insert oracle CD and can run runInstaller for the same oracle home??

please give me in details

thanks
Re: Database version change [message #442335 is a reply to message #442334] Sun, 07 February 2010 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The best way to be sure to no more use EE is to first deinstall the current version, drop the directory, adn reinstall.
You cannot reinstall in the same directory without first deinstall.Of course this mean database downtime.

If you can't have a downtime more than a couple of minutes, then install in a new directory/home, stop the database and restart it with the new home and in the end deinstall the previous version.

Regards
Michel
Re: Database version change [message #442340 is a reply to message #442335] Sun, 07 February 2010 01:18 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Mr. Michel

sorry for again & again.

i have installed EE on /u01/app/oracle. as you suggested if i uninstall EE and drop directory then what about my database whitch is created in the same directioy.

what are all the directory i need to drop

if you dont mind give the steps in details
if i m giving trouble to you sorry.
Re: Database version change [message #442345 is a reply to message #442340] Sun, 07 February 2010 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what about my database whitch is created in the same directioy.

Oh! Very bad organization, I could not imagine someone does this, this is wahy I said drop the directory.
Then drop all directories in Oracle home but the ones that contains your database files (including pfile, spfile, archived logs and so on).

Regards
Michel

[Updated on: Sun, 07 February 2010 01:27]

Report message to a moderator

Re: Database version change [message #442355 is a reply to message #442345] Sun, 07 February 2010 04:58 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Mr.michel

i m clearly explain

oracle_base=/u01/app/oracle
oracle_home/u01/app/oracle/product/10.2.0/db1
database_files+logfiles+control files=/u01/oradata/db1 /u02/oradata/db1 /u03/oradata/db1 /u04/oradata/db1

oraInventory=/u01/app/oracle
prameter and dump destination=/u01/app/oracle/admin
spfile+listner+tnsnames_sqlnet files =$oracle_home/network/admin

process steps:

stop listner
stop dbconsole
stop isqlplusctl

uninstall oracle software using OUI.
drop directory=oraInventory,Oracle_Home,parameter $ dump destimation


next i will install oracle SE with OUI

what else i have to do

please.
Re: Database version change [message #442357 is a reply to message #442355] Sun, 07 February 2010 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Keep the directories containing parameter files.
Then after install, you just have to restart the database and run catalog.sql (and other optional Oracle scripts if you previously did).

Regards
Michel
Re: Database version change [message #442358 is a reply to message #442357] Sun, 07 February 2010 06:09 Go to previous message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Thanks Mr.Michel
Previous Topic: Error:No data to read from socket
Next Topic: Transaction of Specific date locked
Goto Forum:
  


Current Time: Fri Dec 02 14:31:37 CST 2016

Total time taken to generate the page: 0.15218 seconds