Re: Oracle 10g on solaris

  • From: ææçé <kuon@xxxxxxxxxx>
  • To: onkarnath.tiwary@xxxxxxxxx
  • Date: Tue, 22 Nov 2005 18:38:27 +0100

Onkar N Tiwary wrote:

Hi all,
I have a Sun server Enterprise 4500 with solaris8 on it. I installed oracle 10g AS successfully on this but while creating database it gave an error "*Out of memory" *error and the configuration aborted. I guess the problem was because of some of the memory paramters(SEM*) then i searched for those and re-configured according to the documentation. Now I don know how to invoke the entire configuration wizard all together , I know NETCA & DBCA for network and database configuration but i want to know if there is some executable which invokes the entire configuration wizard and gave us the screen like one we get after binary installation which configures everything simultaneously without our intervention.

Oracle 10g install on Solaris 10, tips:

Working /etc/system parameters (I prefer them over prctl for simplicity reasons, if you want to use prtcl, check this post:
http://forum.sun.com/thread.jspa?messageID=98732
)


set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100

Then, the dbca do all the database creation for you, the installer run netca and dbca for you, I don't thinkhe do anything else. Except asm creation, but you can also do it from dbca.

Anyway, I did it this way:

./runInstaller
-> software install.
dbca for asm
dbca for database
netca for LISTENER

tuning dbstart and dbshut and creating a svc entry for it.


If you want to uninstall oracle, you can do it the hard way:

kill -KILL all oracle process
kill -KILL css process

find /etc -name "*t.cssd" -exec rm -fr {} \;
( I assume you know what those are doing )

rm -fr /var/opt/oracle
rm -fr /usr/local/bin/coraenv /usr/local/bin/dbhome /usr/local/bin/oraenv
rm -fr /oracle/home

This should do it, also remove all dumb db files.

Then begin again from scratch.

Hope this help, serv as a reference for anybody.

Regards

Kuon

Other related posts: