Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
ORA-12560: TNS:protocol adapter error after successful installation of 18 xe
Hi,
I installed 18 XE on windows 10, but get this error when I try to login via cmd. I installed it via the installation wizard and left every setting on default. Already tried restarting, uninstalling and reinstalling.
After reading Receive ORA-12560 TNS:protocol adapter error with XE 18c / Windows I tried changing my windows environment settings but did not find any for Oracle, which is weird right?
Also, with Oracle 11xe i was used to having 4 windows services and now I only see two: a recovery service and listener. Is that normal?
thanks,
Sullivan
Best Answer
-
Guess we found it.
My home laptop is Win Home edition.
https://docs.oracle.com/en/database/oracle/oracle-database/18/ntdbi/oracle-database-software-requirements.html#GUID-CEF2… says that is not supported, only Pro, Enterprise, and Education editions so I'm out of luck.
Would be nice if the installer could check this as well.
Thanks for your help Christian.
Answers
-
That error is very generic that just means "things are really messed up!"
If you do not see OracleServiceXE, then you have your answer - the install failed.
Did you set ORACLE_HOME? Don't set that on Windows. You shouldn't have to set any environment variable after install.
Possibly the PATH did not get set to the new Oracle home.
-
Thanks for your reply Christian,
Yeah I figured something went wrong :-) , but I don't even know where to start looking. I didn't set any environment variables, but I was expecting to see it already set, which was not the case.
So we have services missing and an incorrect path set? Mind giving me some debugging tips? i have no idea what to check and can't really find anything.
-
If you do not see OracleServiceXE, there is no hope for it working in the current state. That is the Oracle database software.
When you installed it, did you use the user interface version of the install (as opposed to command line)? If so, did it show you a final screen with connection strings (similar to what is shown in chapter 5 of the documentation)?
Is there anything unusual about your Windows 10? Are the drives involved local drives? Is it an up to date version of windows 10?
If you are using a domain user, can you try creating a local administrator user and log in and install with that?
-
Do you mean this?
Then yes.
Local drive yes, I have only one, no partitions, if thats an issue too. Also up to date version of windows.
Tried with no differing results:
- creating another admin and installing with that one
- installing 11 xe, uninstalling that one and then reinstalling 18
- downloading 18xe again and installing that version.
Do you think installing from command line would make a difference?
-
That screenshot suggests it did install.
What user did you use for the install, Adminsistrator?
What user are you looged in as when you try and view Services?
...when you say "I installed 18 XE on windows 10, but get this error when I try to login via cmd." show how you tried to login via cmd.
-
Thanks Gaz, I do realize that the screenshot suggests it did install... It's the first line on screen after all.
Yes I installed it as an administrator, even tried making another admin as Christian suggested. When i view Services, I tried logging in as the administrators (both of them, only two users on my laptop).
logging in via cmd is done via the usual:
"sqlplus /nolog" and then conn sys as sysdba
or "sqlplus / as sysdba"
or all other ways of logging in I could find on google, but I sure can reinstall it and paste a screenshot.
-
Just to confirm again, you do NOT have OracleServiceXE in the services Window?
If not, the installation failed and we will need to find out why. I am talking to some of the engineers to see what the next step is.
-
yeah exactly, I do NOT have it.
Maybe this screenshot helps?
-
Ok, thanks for your patience. Stand by.. we will probably have to look at your log files to figure out what is going wrong. I will get back soon.
-
Thanks Christan. It's for personal tinkering at home and I can't really get to my laptop right now so no absolute hurry. Asked my DBA friend to take a whack at it after work too, hopefully he will get it working. If so, I will post update and solution ofcourse.
