Re: Oracle 10g dedicated server how to change to shared mode

On 12 Jan 2005 19:12:39 -0800, evoradba_at_yahoo.ca (Maria) wrote:

>Hello
>
>I have installed Oracle 10g on solaris back in August then to test we
>decided to change to dedicaded mode. Now we can't connect from any
>other server, keep getting this error message
>SQL*Plus: Release 10.1.0.3.0 - Production on
>ERROR:
>ORA-12500: TNS:listener failed to start a dedicated server process
>
>The thing when I do a tnsping to this instance from any other server
>its fine?

I presume that was not meant as a question. ;-)

You need to understand that TNSPING only proves that you have basic network connectivity and that the listener recognizes the service you are TNSPINGing. You can put a reference to MYSID in the listener.ora file and succesfully TNSPING MYSID, without even having created a database MYSID. It's like calling the post office and asking if they would try to deliver a letter to 123 Elm St. If they say 'yes' it proves you can contact the post office and they think they know where 123 Elm St. is. It doesn't prove that there actually is such a location.

>Can someone please help me to change back to the shared mode
>Thanks
>Maria

Thanks.

• Ed Stevens

Cohn's Law: The more time you spend in reporting on what you are doing, the less time you have to do anything. Stability is achieved when you spend all your time doing nothing but reporting on the nothing you are doing. Received on Thu Jan 13 2005 - 07:27:13 CST