Hi !

I have a strange error with Oracle 10g R2.

I run it on a Solaris 10 computer (Ultra 60 450MHz 1024 MB RAM).
When I start all the services as usual as the user oracle I do like this:

Database startup:
sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
SQL> exit

Listener startup:
lsnrctl start

iSQL*Plus startup:
isqlplusctl start

Then there is a strange behavior of the iSQL*Plus service, when I close the shell
window that is started the services from the iSQL*Plus servers shutdown. I assume
it does since I can no longer reach it. But the other serices continue to run as usual.

I should mention that when I first installed oracle everyting was started up as a part
of the installtion, but after some use the iSQL*Plus service got disabled so I reinstalled
the whole pakage. But when I booted the system before the reinstalltion
I got some IP port error message at boot the first time, next time there was no error message.

Could it be that there is another service running at the same port and there is some kind
of conflict.

Please let me know if anyone have had the same problem.

A also wonder if there is a solaris
command to see which services are running at which ports.

/Alex

This post has been edited by miCRoSCoPiC^eaRthLinG: Dec 31 2005, 04:26 AM

I tried Oracle 10.2 on AIX, and I had no problem.
Have a look at the $ORACLE_HOME/something directory, where the isqlctl settings are, the port is written explicitly.
Then have a look at /etc/services, to see if the port is in use. Also try netstat, you should see this port busy or listening.
Regards
Yordan

I asked my mother since she's a really Oracle guru. She says that it hasn't anything with oracle so maybe you should try it on something else instead of Solaris maybe?

About your last question: she doesn't know on Solaris but on Unix this should do it:



hope this helps,

-=jeroen=-

Holy COW birdie - you got an oracle whiz as your mom !! Boy, what a mom to have Oooohhh.. I'd have sailed through all Oracle Cetifications blindfolded.

Unfortunately, isqlplus services crashing is not an Oracle. It's a Sun-Os problem, I don't have it with my AIX installations. Moreover, it's probably a problem with an application on the sun system, using the same service port as the oracle isqpluplus service.
So, even an Oracle certified guy would be of no help here, you need a Sun-os debugger guy.

Hehe, thanks M^e, I'll tell her Anywayz, you didn't met the rest of my family yet then. My dad for example is a IBM mainframe engineer, I've got an uncle who's a official(!) Microsoft engineer and a MySQL pro and my cousin is a high-rated webdesigner. Just to mention a few. Yeah, we've got quite some knowledge in here

-=jeroen=-