I started to receive this error while I`m using C# with Oracle 10g.
ORA-12560 and I really need to solve it as I`m running out of time on my grad project.
views:
129answers:
3
A:
Make sure your listener is running. If it is, try restarting it and re-registering your database with it (through sqlplus as sysdba, type the command alter system register;). Also, make sure that if you run a local firewall you have allowed the port 1521 for incoming traffic (or your custom port if you have changed this).
In Windows the listener is a service, prefixed with the oracle home name + TNSListener. In Linux, set your oracle home environment and type:
lsnrctl stop
lsnrctl start
REW
2010-06-27 18:26:27
alter database register; didn`t work ... ORA-01900: LOGFILE keyword expected.
sikas
2010-06-27 19:06:27
Sorry, `alter system register;` is the correct command to reregister the instance with the listener.
REW
2010-06-27 23:21:24
@REW: didn`t solve the problem
sikas
2010-06-28 13:37:19
@REW: I`ve been able to solve the error, well I don`t know exactly how did I solve it ...
sikas
2010-06-29 11:43:28
A:
ORA-12560 is a configuration issue. This makes it difficult to diagnose remotely. I have answered a similar question on SO before. my advice is general enough that it should help you too. Find out more.
If it doesn't you'll need to post more details of your listener.ora, tnsnames.ora and perhaps your hosts files.
edit
"All the files are hosted here:"
Hmmmm. Both listener.ora andtnsnames.ora reference HOST = SIKAS-TOSH but server is not included in the hosts file.
edit 2
"the Oracle 10g Express Edition is installed on my PC"
If your database is on your PC then the files on some web-server are irrelevant. It is the listener.ora andtnsnames.ora on your PC which matter. Those versions of the file need to reference HOST = localhost or else your hosts needs to include SIKAS-TOSH as an alias for 127.0.0.1.
APC
2010-06-27 19:47:45
All the files are hosted here: http://members.multimania.co.uk/sikas/ORACLE/
sikas
2010-06-27 19:57:25
@sikas - You are the one with the deadline to meet, not us. So if you want help from us you need to give us *all* the relevant info.
APC
2010-06-27 20:44:13
@APC: all the files exists on my PC in the Oracle directory. I`ve just uploaded them for you to examine them for me. SIKAS-TOSH is my computer name, I`ve added it to the hosts file 127.0.0.1 SIKAS-TOSH, but still the same problem.
sikas
2010-06-27 21:42:58
@APC: I have changed the host in both listener.ora and tnsnames.ora, but still no success...
sikas
2010-06-27 21:46:40
@APC: I`ve been able to solve the error, well I don`t know exactly how did I solve it ...
sikas
2010-06-29 11:43:58
A:
I have unintalled and re-installed the oracle 10g many times as well as the ODAC112011beta, last time I didn`t install the ODAC112011beta, instead, I used the Oracle.DataAccess.Client file found in the C:\oraclexe\app\oracle\product\10.2.0\server\BIN\Oracle.DataAccess.dll ... then I started the service from START->All Programs->Oracle Database 10g Express Edition->Start Database as administrator ... now I can connect to the Oracle through C# ... I hope I face no more problems
sikas
2010-06-29 12:19:41