-
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
-
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.
-
yes my database name is TC
-
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.
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|