Re: Oracle 10g on solaris

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

--
http://www.freelists.org/webpage/oracle-l