Conflict between XE and 10g
Recently I'd installed the Oracle Express and it works very well, but after I'd install the Oracle 10g, now when I try to start my Sql*Plus there are errors referred to the listener. I read about and I decide to unistall the OraXE, but the errors are the same: SQL> conn sys as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error How can I solve it???
Hi, you must verify the correct ORACLE_HOME, ORACLE_SID and verify if OracleSidService was started. Regards.
What's the OS? Like suggested, make sure ORACLE_HOME are setup correctly.
It is important to define which OS you are working with. I could try to guess it is a Windows environment as this is a frequent error on Windows platforms. You should have your OracleXE Service started, and when trying to access it check your ORACLE_SID environment is properly pointing to your XE SID. In order for you to check it is properly working, once you have ensured your DB is up and running, ensure your listener is up and running too, it is important to have your database registered against your listener, otherwise the Oracle DAV won't be able to start the http, and ftp services. ~ Madrid
When you install any Oracle product, it gets installed in an Oracle Home. The Oracle Home is used to - keep the relevant binaries (software); - keep the supporting files (error message and language translations) - keep configuration files (tnsnames.ora, sysman/targets.xml and others) Regardless of operating system, when you invoke an Oracle product (sqlplus, rman, whatever) is uses the Oracle Home as a reference point. The product will look up ALL relevant information from that reference point unless explicitly told to use something else. In *nix, this reference is established by setting the ORACLE_HOME variable. This is done relatively easily using the /usr/local/bin/oraenv routine (which looks up the ORACLE_HOME based on the 'system identifier' passed to it). A number of other variables, including PATH, are set up based on the ORACLE_HOME as well. In the Windows, the reference is set up either as an environment vaariable, in the registry ... or it is implied by the directory of the executable (which is in ORACLE_HOME/bin) All this blather is to tell you that you have a TNSNAMES.ORA and a LISTENER.ORA in each of your ORACLE_HOMEs. These are not sync'd, do not know about the other database, and are causing part of your problem - imply because you are using the wrong ORACLE_HOME.
Thanks to all of you, I solve this problem simply unistalling all my Oracle versions, deleting all the file folders and registry entries and installing again the 10g. Now I'm working fine with all Oracle tools. Thanks again!
This is known as the 'Microsux method' In Oracle it won't bring you very far, especially if you don't read any manuals. In fact following the Microsux method will take you way more time than reading manuals and starting to do things properly. -- Sybrand Bakker Senior Oracle DBA
I'd like to ask you what is a microsux method? Where is it documented? ~ Madrid
I'd like to ask you what is a microsux method? Where is it documented? It isn't ... and that's the point. Instead of reading the manuals and/or learning how to to it right, one simply a) reboots; or b) re-installs For many 'IT' people, this method has supplanted the method Sybrand, you and I learned many years ago. It avoids difficulties like 'thinking', 'reading' and 'learning' and has the advantage of demonstrating activity to those who pay.
Well, this microsux method works fine for me, is not the correct way, but works... and Hans, nobody is paying me for doing this, I do this "Oracle things" because I'm very interested, that's all. I appreciate your help, you do that because you want to do, nobody is paying you for that, and that's great, but following the Sybrand Bakker comments is not the right way to help beginners like me, in fact people like him makes that people like me affraid to ask "silly" questions, questions I'm sure you have had when you starts your Oracle carreers long time ago. Thanks again.
Pancho, In fact the one who originally made the comment was not Hans, but the other guy, Sybrand. If you take the time to follow his postings you may find patience for beginners is not an attribute in him. He tries to evangelize everyone here with his learning way, however the method he uses is not very polite. The Microsux method wouldn't be a good practice for someone like him who is supposed to be a self-qualified 'Senior Oracle DBA'. But it is sometimes the only way for people who is facing an immediate troubleshooting situation with tons of manual pages to read and understand. There is a bunch of fellows who disagree with Sybrand's way to say things (not with the manual reading phylosophy). I think it is valid to proactively read manuals, from time to time troubleshoot by Microsuxing, and ask 'silly' questions, as these are some of the ways to gain experience. I have seen people who started with easy, pretty basic questions, and as time goes by, their devotion and dedication have made them grow, by now the same people who are still around, now ask more focused and challenging questions. If I were you I would ignore the way Sybrand say things but I would follow his advice, read the manual, additionally keep on participating on the forum, asking whatever you want to, and practice. ~ Madrid
Thanks Madrid, I know the one who post this comment was Sybrand, not Hans, but Hans follow and expand the comment, and he's not like Sybrand, I know that too. I know that the microsux method is not the correct way for many things, but the operating system with I'm doing my job is Windows, maybe that's the reason why I'm still have practices like that. I'm ignoring comments from people like Sybrand, In fact I think the only silly question is that question you never ask. I'm keep interested in Oracle, I will keep my participation in this forum, I learn a lot, and of course I'm reading the manuals and other posts.
You asked where the method is documented. I answered that question, together with an explanation of the method. Now you tell me "following the Sybrand Bakker comments is not the right way to help beginners ..." I am not quite sure what your response is trying to tell me.
In fact I didn't ask for the 'microsux method documentation', there was not me. And "following the Sybrand Bakker comments is not the right way to help beginners ...", is this, if you ask the questions like Sybrand, with his "original polite manners" you will be like him and he, you know, doesn't help the beginners, that's what I'm tryin to say. Now, I know you only answered the question, that I didn't ask, but I feel you were answer in the same way that Sybrand used to... "For many 'IT' people, this method has supplanted the method Sybrand, you and I learned many years ago. It avoids difficulties like 'thinking', 'reading' and 'learning' and has the advantage of demonstrating activity to those who pay.", you see my point now?
Now, I know you only answered the question, that I didn't ask, but I feel you were answer in the same Apologies. I should have said "I answered the question", rather than "I answered your question" way that Sybrand used to... "For many 'IT' people, this method has supplanted the method Sybrand, you and I learned many years ago. It avoids difficulties like 'thinking', 'reading' and 'learning' and has the advantage of demonstrating activity to those who pay.", you see my point now? I think see I now. I believe you are politely telling me that it would be better for me not to say what I have observed to be a growing trend in the industry. Message was edited by: Hans Forbrich