ORA-31112: fail to unregister for HTTP port using xdb configurationis caused by a port conflict, i. e. another service is already using port 8080 (or whatever non-default value you may have chosen in your install). Because of that error I'm not sure the database homepage you see is the one that belongs to the XE instance we are talking about. Are you really sure it's up?
Can someone let me know if the default Oracle XE Database install uses oracle database for the authentication? I doubt it tries to use OS authentication, by default.Actually, it uses both for default on Linux systems: You can login as sysdba without providing a username or password using
to the database your local enviroment points at. If you get "insufficient privileges", this usually means the dba-group isn't set properly or you've disabled OS-based authentication.
sqlplus / as sysdba
(note that you don't need to add the service name XE unless you want to connect using a certain TNS Listener)
sqlplus /nolog connect sys/password as sysdba
If this doesn't work, could you take a look at the non-binary part of the following file:
source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh sqlplus / as sysdba
My company does have Oracle support, is there some place/person I could contact at Oracle for additional help?Sorry, you won't get official support for XE. If you encounter such problem for your regular supported database products, you'll probably first be pointed at some general documents that basically encourage you to do the things we have requested to do as well. But you can search the knowledge base and try to find additional ressources on how to troubleshoot ORAs 01017 and 01031...
Hope that helps.
C:\>type C:\oracle\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\sqlnet.ora # This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT. #SQLNET.AUTHENTICATION_SERVICES = (nts) C:\>sqlplus / as sysdba SQL*Plus: Release 18.104.22.168.0 Production on To Jan 24 20:12:18 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges Enter user-name: ^C C:\>REM now remove comment in sqlnet.ora to enable authentication_services parameter set to NTS C:\>sqlplus / as sysdba SQL*Plus: Release 22.214.171.124.0 Production on To Jan 24 20:13:29 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SQL> ^C