database server is not responding
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: database server is not responding

Hybrid View

  1. #1
    Join Date
    Oct 2007
    Posts
    7

    database server is not responding

    hi
    I installed oracle 10g in linux installation is successful
    On of my application try to access the oracle database
    I got this message

    Database server for oracle database on localhost does not responding
    Possible causes for this problem includes:
    1 the database user ID or password is in correct,
    2 the database server is not installed in specified location or
    3 the database server is not running

    I donít know how to run the database server

    Thanks in advance

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    As per your post you have installed Oracle software.

    Have you created a database?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Oct 2007
    Posts
    7
    yes my database name is TC

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    In the box hosting your database please do and post...
    ps -ef | grep smon
    Last edited by PAVB; 10-10-2007 at 06:14 AM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Oct 2007
    Posts
    7
    thanks PAVB
    i did what you asked to do
    but i don't know how to setup tnsnames.ora and listener.ora

    bash-3.2$ cd /opt/oracle/
    bash-3.2$ cd 10g/bin/
    bash-3.2$ sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 10 17:53:51 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn sys as sysdba
    Enter password:
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 2550136832 bytes
    Fixed Size 1995856 bytes
    Variable Size 587205552 bytes
    Database Buffers 1946157056 bytes
    Redo Buffers 14778368 bytes
    Database mounted.
    Database opened.
    SQL> exit

    bash-3.2$ ps -ef | grep smon
    root 1611 1 0 11:34:23 ? 0:00 /etc/opt/resmon/lbin/emsagent
    root 1540 968 0 11:34:19 ? 0:00 /etc/opt/resmon/lbin/registrar
    root 1880 1 0 11:34:34 ? 0:00 /etc/opt/resmon/lbin/p_client
    oracle 3434 1 0 17:55:14 ? 0:01 ora_smon_TC

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I'm glad it worked out.

    Go to ${ORACLE_HOME}/network/admin

    There you will find template tnsnames.ora and listener.ora files, save the originals and play with the other two.

    Listener is needed for remote connections. Clients looking to connect to the database have to have a copy of your tnsnames.ora entry in the client machine alongside with Oracle client software.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Oct 2007
    Posts
    7
    thanks PAVB
    problem is solved

Posting Permissions

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



Click Here to Expand Forum to Full Width