Oracle FAQ Your Portal to the Oracle Knowledge Grid
 HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: TNS-12500: TNS:listener failed to start a dedicated server process

# Re: TNS-12500: TNS:listener failed to start a dedicated server process

Date: 31 Jan 2007 06:44:26 -0800

On 31 Jan, 11:13, kennymcet..._at_googlemail.com wrote:
> On 31 Jan, 10:22, "sybrandb" <sybra..._at_gmail.com> wrote:
>
>
>
>
>
> > On Jan 31, 11:09 am, kennymcet..._at_googlemail.com wrote:
>
> > > On 31 Jan, 09:56, "sybrandb" <sybra..._at_gmail.com> wrote:
>
> > > > On Jan 31, 10:40 am, kennymcet..._at_googlemail.com wrote:
>
> > > > > Hi,
>
> > > > > I've just tried to re-install Oracle 9.2.0.1.0 on my dev server. I
> > > > > uninstalled Oracle, then went through the normal install process, and
> > > > > patched it to 9.2.0.7. During the main install, Oracle was unable to
> > > > > install 'Cluster Queries' (due to a media failure, I presume), but the
> > > > > rest of the install seemed to go OK. The main install finished with an
> > > > > "Installation Unsuccessful" message, but I presumed this was because
> > > > > of the "Cluster Queries" problem.
>
> > > > > Here's the error stack from listener.log when I try to connect:
>
> > > > > 31-JAN-2007 09:25:21 * (CONNECT_DATA=(SERVICE_NAME=ORADEV2)
> > > > > (CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)(HOST=BGL-DEV2)
> > > > > (USER=kmce4272))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.100.92)
> > > > > (PORT=1488)) * establish * ORADEV2 * 12500
> > > > > TNS-12500: TNS:listener failed to start a dedicated server process
> > > > > TNS-12560: TNS:protocol adapter error
> > > > > TNS-00530: Protocol adapter error
> > > > > 32-bit Windows Error: 126: Unknown error
>
> > > > > Can anyone advise?
>
> > > > > Thanks in advance,
>
> > > > > Kenny McEwan.
>
> > > > Did you check the status of the database? Is it running?
> > > > Can you (in a DOS box) connect using
> > > > set oracle_sid = <yoursid>
> > > > sqlplus /nolog
> > > > connect / as sysdba
>
> > > > One of the main reasons for TNS-12500 is the database is down.
>
> > > > --
> > > > Sybrand Bakker
> > > > Senior Oracle DBA- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > Hi Sybrand,
>
> > > When I do this, I get ORA-12560: TNS:protocol adapter error.
>
> > > Thanks,
> > > Kenny.- Hide quoted text -
>
> > > - Show quoted text -
>
> > Hi Kenny,
>
> > Time to check
> > - whether OracleService<SID> is running
>
> > 12560 will occur because Oracle tries the default SID ORCL if the
> > designated database is not available.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -
>
> > - Show quoted text -
>
> Hi Sybrand,
> OracleService<SID> is running.
> There's nothing in oradim.log since I reinstalled Oracle (only
> message in there dates from just prior to my re-install.
>
> Just for info, they are:
>
> Tue Jan 30 12:45:20 2007
> Restarting dead background process QMN0
> QMN0 started with pid=9
>
> Tue Jan 30 12:02:20 2007
> ORA-12705: invalid or unknown NLS parameter value specified
>
> The message in oradim.log is the reason I decided to re-install Oracle
> in the first place.
>
> In any case, it seems as though the re-install didn't work out too
> well!
>
> Many thanks for your help,
> Kenny.- Hide quoted text -
>
> - Show quoted text -

anymore for anymore? I'm struggling here!

thanks,
Kenny. Received on Wed Jan 31 2007 - 08:44:26 CST

Original text of this message

 HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
{"extraction_info": {"found_math": false, "script_math_tex": 0, "script_math_asciimath": 0, "math_annotations": 0, "math_alttext": 0, "mathml": 0, "mathjax_tag": 0, "mathjax_inline_tex": 0, "mathjax_display_tex": 0, "mathjax_asciimath": 0, "img_math": 0, "codecogs_latex": 0, "wp_latex": 0, "mimetex.cgi": 0, "/images/math/codecogs": 0, "mathtex.cgi": 0, "katex": 0, "math-container": 0, "wp-katex-eq": 0, "align": 0, "equation": 0, "x-ck12": 0, "texerror": 0, "math_score": 0.9029490351676941, "perplexity": 13889.74728202451}, "config": {"markdown_headings": true, "markdown_code": true, "boilerplate_config": {"ratio_threshold": 0.18, "absolute_threshold": 10, "end_threshold": 15, "enable": true}, "remove_buttons": true, "remove_image_figures": true, "remove_link_clusters": true, "table_config": {"min_rows": 2, "min_cols": 3, "format": "plain"}, "remove_chinese": true, "remove_edit_buttons": true, "extract_latex": true}, "warc_path": "s3://commoncrawl/crawl-data/CC-MAIN-2014-10/segments/1393999678302/warc/CC-MAIN-20140305060758-00090-ip-10-183-142-35.ec2.internal.warc.gz"}