Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 395 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
ora-12560: tns:protocol adapter error
Hello, This is my first time on here and first time working with oracle database. So my problem is that after i installed 18c XE and check the service on my computer there is no OracleServiceORCL. So its like i lost connection to the server completely, i used to have 11c and i manually uninstalled it for the 18 which i followed online and end up deleting the server in service on my computer. How do i get that back so i do not have this error.
Thank you for any replay
Answers
-
The Oracle 18 XE installation creates a windows service called OracleServiceXE.
I'm not sure of what your problem is, I understand that you had 11g installed (XE or SE or EE?) and you uninstalled it to install 18c XE (that is OK if the 11g was also a XE edition, you can only have one XE installed on the same machine).
Did the 18c XE installation finished OK? If not, do you want to fix the 18c installation or do you want to reinstall the 11g?
Please explain with more details what you have done, the problems you have and include the exact syntax and errors. Use some screen capture (if you are using a GUI tool) or directly copy/paste if you are using command line.
And also please follow this guideline when posting new questions, that will help you get answers quicker:
-
Hello L.Fernigrini
They are both XE and i want the 18c XE but i noticed that for the server i can get the 11g version fine, even though it doesn't run for some reason, while on the 18c XE I don even have the server. When i only have 18c XE installed there is no server, and i get "ORA-12560: TNS:protocol adapter error". I get this error when i go to SQL plus and sign in with username: system, password: Password. Furthermore when i go into Oracle Instance Manager, it doesn't even have anything in the file. Also, yes, I am sure the installation went fine, but after that everything is not working correctly. Thank you for any help you can give.
-
Let's start from the beggining
1) Check the SERVICES app and verify that you have both the OracleServiceXE and the Listener installed and Running :
2) Go to a command windows, execute the following to check if the database is registered with the Listener
lsnrctl status
lsnrctl services
3) Try connecting using SQL*Plus and local connection
SET ORACLE_SID=XE
sqlplus / as sysdba
Show us the results so we can check what the problem is...
-
Hello, here is the results from the first thing to the last.
-
1) You do not have an OracleServiceXE, that means that something on the 18c XE installation went wrong.
2) You have 2 listeners (11g and 18c). That should not be a problem, unless they try to run on the same port. From the screenshot, the 18c listener seems to run on the 1522 port so that seems to be OK (default 1521 port must be in use by 11g listener). Both of them are down, that's why you do not see results on the lsnrctl commands. The 11g listener seems to be on a "Client" home, that is weird AFAIK...
3) If the service does not exists (problem #1) it is imposible to connect to the DB, so it is obvious that sqlplus will fail.
I would suggest you to uninstall everything (both failed 18c XE and existing 11g components) and run the 18c XE installation again. Please follow the instructions with all the details. Make sure that ORACLE_HOME and any other environment settings are configured before starting the installation.
-
I will, also the picture from the service was after i uninstalled 11g. When i uninstall the program it still keeps the stuff in service. Could this be a problem?
-
i did what you said and i also went and tried sqlplus / as sysdba. this is the outcome.
-
If you do not have OracleServiceXE as a service, and started, that means you do not have the XE database created.
The initial post seemed to be pointing to a connection error (you mentioned that XE installation was OK) but the absence of the service means the installation did not end OK. Maybe someone from Oracle in the forum can guide you to complete the installation, you can search other questions in this space where there are detailed explanation on how to make a complete uninstall and a new install of OracleXE.
Check the O.S version and edition, the required privileges, etc etc etc.
-
okay, thank you but i know nothing wrong or no errors occurred when i went to install it again.
-
How to Fix this error
