Oracle 10.2 database not responding

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 ?
LVL 1
cobol60Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cobol60Author Commented:
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
mrjoltcolaCommented:
Check and disable any firewalls on your machine.
0
cobol60Author Commented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

cobol60Author Commented:
i tried on a notebook wich is not on the windows domain and could disabled the firewall. The same problem appears ...
0
mrjoltcolaCommented:
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
cobol60Author Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mrjoltcolaCommented:
>>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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.