Hello,

I have more than 1 oracle 10g instance on the same server (solaris). I created an instance and a database via a shell script and later deleted it, also via a script (just to test my scripts) - I deleted all the datafiles, redologs, controlfiles, parameter files and some other directories for this database...I thought that deleting the parameter files would delete the instance completely, but when i issue the command "ps -ef | grep testdb", i still see the background processes running. I think this is causing problems when i try to create an instance and database with the same SID again via my script.

So how can i manually (via a shell script, not via dbca) delete all the background processes of an instance?
Thanks.