Solved

Oracle 10.2 database not responding

Posted on 2009-07-10
7
1,309 Views
Last Modified: 2013-12-19
Hi,

I have a 10.2 oracle database. The startup of this database works fine. Starting the listener works fine too (no errors).

When i run a Sqlplus session in local way (setting the ORACLE_SID env var before launching sqlplus) it works fine too.

But when i try "sqlplus system/password@SID" the server doesn't respond :
nothing ... no error codes.
When i try TOAD, it's the same thing ... no response
When i try Oracle Enterprise Manager the doesn't respond too.

Notice that Oracle is not "installed" on this dev machine but "copied-pasted" from another where everything works fine. I also export the registry entries for oracle from the working machine to the dev machine, but it does'nt work anymore.

any suggestions ?
0
Comment
Question by:cobol60
  • 4
  • 3
7 Comments
 
LVL 1

Author Comment

by:cobol60
ID: 24822323
I tried some things ... among them, i tried to shut the instance down and to connect to it with the clients : a normal error message appears saying that an error ORA-12518 occured
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24823473
Check and disable any firewalls on your machine.
0
 
LVL 1

Author Comment

by:cobol60
ID: 24823798
The problem is that i can't disable the firewall on the machine because of windows domain restriction ... i just can add exceptions ... do you know wich programs i must add to the exception ? I addes oracle.exe, tnslsnr.exe, sqlplus.exe, i also authorized the 1521 port wich is the port of my database ...
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

by:cobol60
ID: 24824406
i tried on a notebook wich is not on the windows domain and could disabled the firewall. The same problem appears ...
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24824511
You said you cut-n-pasted from another server. This is unusual for Windows, I only do this on UNIX platforms. You should really install properly before bringing a database over, due to registry requirements.

Also, consider backing up all .ora files in $ORACLE_HOME\network\admin and rerunning netca to configure the listener and tnsnames.

If you did not actually install Oracle, this may not work either. You have installed it incorrectly, and I can tell you, on Windows, the Oracle listener is very picky about configuration. Even on a proper install, to re-create a listener requires deleting the service, removing a registry entry, rebooting, then rerunning the listener config / netca.

0
 
LVL 1

Accepted Solution

by:
cobol60 earned 0 total points
ID: 24824777
thank's mrjoltcola ... But it now works properly.

I didn't install oracle only a copy/paste from our network.

The problem was that the listener seems to only cummunicate with a windows' service. So you must install your db as a service with the tool oradim (oradim -new -sid SID) and that's all.

I have also some scripts because the dev machine will host potentially 50 db instances ... so we must shutdown instances properly.

thank's to this forum ... ;)
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24824925
>>the expert didn't find a solution for me ... saying no solution was available

I did not say that. I clearly said you should install properly. Please don't misquote me.


Yes, you ran oradim, this is what happens when you do the install normally or by running DBCA through the usual way. And as a side effect, it creates a listener for you. Note I said:

"Even on a proper install, to re-create a listener requires deleting the service, removing a registry entry, rebooting, then rerunning the listener config / netca."


Anyway thanks for the post back on your solution. I might have suggested you checking the services and rerunning oradim as well, but I don't agree with this method of installing Oracle, so I recommended the supported way.

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ORA-06504: PL/SQL: Return types of Result Set variables or query do not match 4 100
Queries 15 38
SQL Query 34 98
Can't Access My Database 57 63
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question