| Database version change [message #442328] |
Sat, 06 February 2010 23:56  |
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 #442334 is a reply to message #442329] |
Sun, 07 February 2010 00:33  |
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 #442340 is a reply to message #442335] |
Sun, 07 February 2010 01:18 |
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 |
 |
Michel Cadot
Messages: 68665
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 |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
