6 Replies Latest reply on Oct 20, 2019 11:51 PM by Dude!

Oracle 18c Express Edition installation

dmneylon Oct 1, 2019 10:55 AM

I'm reaching out for some support with my Oracle 18c Express Edition installation. I have spent a full week or more on this now and can't get anywhere. I eventually managed to successfully install Oracle 18c through an elevated cmd prompt bypassing prerequisites for local admin. The next step is to open SQL Plus and login in to start creating a DB connection. When using the password I supplied at installation and username: system, I get the following error:

ORA-12560: TNS:protocol adapter error

Listener status:

Instance "CLRExtProc", status UNKNOWN

I can't get any straightforward explanation of my issue. It seems like there is some issue with the installation of all services. I have restarted PC, tried again, same issue, uninstalled Oracle 18c, reinstalled and then restarted several times but to no avail. When I search the errors they seem to be a common occurence but the resolution is unclear, if any resolution is given at all. It seems most likely I should be looking at listener.ora and tnsnames.ora files but what I have to edit I have no idea. I can't undestand how it is so difficult to install and setup this software and so many people are posting similar issues but no clear explanation in any Oracle installation documentation.

Can you support me?

1. Re: Oracle 18c Express Edition installation

Dude! Oct 1, 2019 12:39 PM (in response to dmneylon)

I suppose you are running MS Windows? What exactly. The error you are posting is generic and can have several reasons. It usually means the database isn't running.

Please check starting and stopping the database:
https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinw/installation-guide.html#GUID-C3C5B05A-3BEB-4373-96D0…
Like Show 0 Likes(0)

Actions
2. Re: Oracle 18c Express Edition installation

dmneylon Oct 1, 2019 2:46 PM (in response to Dude!)

Hi,

I'm running Windows 10 Enterprise. I have tried stopping and starting the database but still the same issue. I agree it looks like the database isn't running but that seems to be my problem that I can't start the database.

Contents of the installed folder. I am missing oradata/XE folder. Any idea why that is not installing?
Like Show 0 Likes(0)

Actions
3. Re: Oracle 18c Express Edition installation

dvohra21 Oct 6, 2019 11:36 PM (in response to dmneylon)

Database doesn't seem to be installed properly. What is the OS including version?
Like Show 0 Likes(0)

Actions
4. Re: Oracle 18c Express Edition installation

0a5c9b5e-4637-42b8-a683-ff30c6630d2b Oct 9, 2019 10:43 PM (in response to dmneylon)

I was receiving the same ORA-12560: TNS:protocol adapter error upon trying to enter my username and password the past couple weeks. A number of others in my class had the issue. I was able to resolve this by trying another installation, but this time right clicking on the "setup" application found within the OracleXE184_Win64 folder and selecting "Run as administrator". After conducting the installation, I was able to connect and have not seen the error since. I have heard that choosing "Run as adminstrator" is the key due to some recent Windows security patch. Hope this helps you and any others who are having difficulty with this. I was super frustrated too.
Like Show 0 Likes(0)

Actions
5. Re: Oracle 18c Express Edition installation

dvohra21 Oct 20, 2019 9:55 PM (in response to dmneylon)

Run as Administrator with right-click.
Like Show 0 Likes(0)

Actions
6. Re: Oracle 18c Express Edition installation

Dude! Oct 20, 2019 11:51 PM (in response to dmneylon)

The error means the database isn't started, hence not registered with the Listener. You probably have the Oracle Instant Manager in the Start menu which you can use to start/autostart the Oracle XE service.
Like Show 0 Likes(0)

Actions

Go to original post