All geek questions in one place

Oracle 10g express home page not suitable

My Oracle 10g Express Edition, I can log in to SQL Plus, but I can’t log in to oracle through the SQL developer, and I can’t view the home page at http://127.0.0.1:8080/apex . This worked until yesterday.

I checked through (WINDOWS) netstat -ab and no other application uses port 8080.

The only thing I did today is that I changed my edition of SQL Server 2005 Developer from Windows authentication to mixed mode authentication.

Can anyone let me know how to make the webpage of Oracle and SQL Developer work.

I would appreciate it.

Thanks!

Adnan A.

+3
source share
3 answers

OK! I understood that

All this time, I thought my listener was working, but when I used the command

'lsnrctl status'

I noticed that lisnter was not working and was failing because my hostname was correct.

I remember when I activated the mixed mode configuration for SQL Server 2005, I had to provide my SQL server with a host name and was different from the WIndows XP shared host name.

So, I edited my TNSNAMES.ORA and LISTENER.ORA file, searched the windows for them, and then fixed the hostnames.

Reloads Oracle XE services and the web page is now running, as well as SQL DeVELOPER.

I thought I should share a tool with you.

Thanks for the help and efforts. You were great.

+3
source

Oracle? , Oracle.

, ( Windows AV )

+1

, , , XE , . ( !) GenericXPWorkstation VMORACLE , Listener.ora tnsnames.ora , NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

SQLNET.ORA, XE.

Windows HOSTS.

+1

Source: https://habr.com/ru/post/1720631/

More articles:


All Articles