Results 1 to 13 of 13
  1. #1
    Join Date
    Jan 2005
    Posts
    8

    Unanswered: ORA-12500 TNS:listener failed to start a dedicated server process?

    I am receiving this message when I try and connect to a new database:

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

    This is my listener.ora file.

    # LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = poweredge2300)(PORT = 1521))
    )
    )
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\ora92)
    (PROGRAM = extproc)
    )

    (SID_DESC =
    (GLOBAL_DBNAME = test.noble.com)
    (ORACLE_HOME = C:\oracle\ora92)
    (SID_NAME = test)
    )

    (SID_DESC =
    (GLOBAL_DBNAME = again_poweredge2300.noble.com)
    (ORACLE_HOME = C:\oracle\ora92)
    (SID_NAME = again)
    )
    )

    and this is my tnsnames.ora file. The database Im trying to connect to is the 6 one down, AGAIN_POWEREDGE2300. All the other except the TEST database have been deleted.


    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ACLL_POWEREDGE2300 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = poweredge2300)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = ACLL)
    (SERVER = DEDICATED)
    )
    )

    ACCT_POWEREDGE2300 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = POWEREDGE2300)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = ACCT)
    (SERVER = DEDICATED)
    )
    )

    ACCT_BEDROCK =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = BEDROCK)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = Acct)
    (SERVER = DEDICATED)
    )
    )

    TEST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = poweredge2300)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = test.noble.com)
    )
    )

    THIS_POWEREDGE2300 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = POWEREDGE2300)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = THIS)
    (SERVER = DEDICATED)
    )
    )

    AGAIN_POWEREDGE2300 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = POWEREDGE2300)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = AGAIN)
    (SERVER = DEDICATED)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = poweredge2300)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    HELP!

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Start the listener service as same domain user like the database.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jan 2005
    Posts
    8
    Im not sure what you mean. Can you please clarify what you mean.

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713
    Is the ORA-12500 the only error you get? If not, post all errors.

    1) You may have started the listener as local user and not as administrator (DBA) user. Run ORADIM Utility to remove and recreate the OracleService<SID> for the instance.
    Warning: Running the ORADIM Utility will remove the Oracle Service. To prevent loss of data, ensure full database backups are available.

    2) Also, the above error combined with a Windows Error: 8: 'Exec format error', indicates the inability of the listener to spawn a shadow server process for the client that requests a dedicated connection. This is purely a resource issue, and indicates the shortage of memory for the oracle.exe process to grow larger in size, and has reached its maximum possible size in physical memory (RAM).

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Jan 2005
    Posts
    8
    Yes, ORA-12500 is the only error I am getting. But what is puzzling to me is I can connect with no problem to the database I created when I installed Oracle. Im only having this problem with regards to any new databases I create.

    Is this the proper way of doing it:

    C:\oracle9i\bin\oradim -shutdown -sid AGAIN –usrpwd <dbapassword>
    -shutttype SRVC,INST –shutmode A


    C:\oracle9i\bin\oradim -startup -sid AGAIN –usrpwd <dbapassword>
    -starttype SRVC,INST -pfile C:\oracle9i\admin\ORCL92\pfile\init.ora

    When I put in the DBA password does that assure that Im starting the listerner as an admin and not a local user?

    When I run oradim you said it will remove the Oracle Service. Will it only effect the database Im stopping and starting or all databases? Will I have to recreate the database before I start it again?

    Thanks

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs up

    Yes, commands are correct, you also could only specify the service (SRVC) without the sid (INST).

    1) Make sure you logon with same username as the oracle service (check with the windows task manager).
    2) Issue the shutdown.
    3) Logoff and logon with correct username (SYSTEM or whatever started the databases).
    4) Issue the startup.

    Good Luck!

    PS: Are you sure you have enough memory (RAM)?

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  7. #7
    Join Date
    Jan 2005
    Posts
    8
    In the task manager the username for oracle.exe is SYSTEM. When you say make sure Im logged on with same username as the oracle service do you mean logged onto Windows? If so Im already logged onto Windows as the Administrator. If not can you clarify what you mean by make sure Im logon with same username as the oracle service. Is being logged on as the Admin the same as the SYSTEM username?

    I believe I have enough memeory. This system has 1GB of memory. In the task manager for oracle.exe memory usage is 98,384K. Is this enough?

  8. #8
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs up

    Yes memory seems ok and logon to windows ok ...
    Hope this works because the ORA-12500 error has many causes and normally it would be accompanied with several TNS-xxxxx errors and/or OS errors.

    You may want to try executing sqlplus from batch (cmd) window to see if all error messages display:

    START>RUN>cmd

    C:\>sqlplus SYSTEM/dbapasswd@AGAIN


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  9. #9
    Join Date
    Jan 2005
    Posts
    8
    I tried if from cmd and got these errors:

    ORA-12154: TNS:could not resolve service name

    and two of these errors:

    ORA-12560: TNS: protocol adaptor error

    After the 3rd try it kicked me out of SQLPLUS. And ideas whats going wrong?

  10. #10
    Join Date
    Jan 2005
    Posts
    8
    I cant log into the database I initially set up when using cmd but I can log into it fine when using the GUI sqlplus. I can also log into my initial database via Enterprise Manager ok also. I cant log into any new databases using cmd/sqlplus or EM.

  11. #11
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    When you created the new databases did you stop/re-start the listener?

    While in cmd did you execute sqlplus with the 'uid/pw@MYDB' format?
    Last edited by LKBrwn_DBA; 01-20-05 at 18:48.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  12. #12
    Join Date
    Jan 2005
    Posts
    8
    No, I didnt stop/start the listener when I created the new database. Should I do this when ever I create a new database?

    Yes, used that format in cmd.

  13. #13
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Exclamation

    YES!!!!!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •