Hello,
First off, I am sorry, I did a search and saw numerous posts on this issue, but about all of them either ended their replies after a user asked "Did you do this or that ?" or they just stopped posting... at most I saw some topics where it magically worked later on, but no real step-by-step instructions.
So, the problem: I installed XE 11g, no apparent problems during install (no warnings so I assume everything is OK), tried the GET STARTED link, but it said it can't connect.
System: Win XP PRO SP3, 2 gb ram using Firefox 7.0.1
DB: Oracle 11g Express Edition
Antivirus: avast 6 (firewall included), but disabled during testing...
lsnrctl:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 05-OCT-2011 02:36:42
Uptime 0 days 0 hr. 21 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File E:\Database\Oracle\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File E:\Database\Oracle\app\oracle\diag\tnslsnr\EASTFRONTIERS03\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EASTFRONTIERS03)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
tns:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
listener:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Database\oracle\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\Database\oracle\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
Services:
OracleJobSchedulerXE
OracleMTSRecoveryService
OracleServiceXE (started)
OracleXEClrAgent
OracleXETNSListener (started)
sqlplus:
SQL> connect
Enter user-name: SYS
Enter password:
ERROR:
ORA-01089: immediate shutdown in progress - no operations are permitted
Process ID: 0
Session ID: 0 Serial number: 0
alert_xe:
Wed Oct 05 02:37:35 2011
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
Using parameter settings in client-side pfile E:\DATABASE\ORACLE\APP\ORACLE\PRODUCT\11.2.0\SERVER\CONFIG\SCRIPTS\INIT.ORA on machine EASTFRONTIERS03
System parameters with non-default values:
sessions = 172
memory_target = 760M
control_files = "E:\DATABASE\ORACLE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
compatible = "11.2.0.0.0"
db_recovery_file_dest = "E:\Database\Oracle\app\oracle\fast_recovery_area"
db_recovery_file_dest_size= 10G
undo_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
shared_servers = 4
job_queue_processes = 4
audit_file_dest = "E:\DATABASE\ORACLE\APP\ORACLE\ADMIN\XE\ADUMP"
db_name = "XE"
open_cursors = 300
diagnostic_dest = "E:\DATABASE\ORACLE\APP\ORACLE"
Wed Oct 05 02:37:53 2011
PMON started with pid=2, OS id=2308
Wed Oct 05 02:37:53 2011
PSP0 started with pid=3, OS id=1168
Wed Oct 05 02:37:54 2011
VKTM started with pid=4, OS id=1920 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Wed Oct 05 02:37:54 2011
GEN0 started with pid=5, OS id=372
Wed Oct 05 02:37:54 2011
DIAG started with pid=6, OS id=1580
Wed Oct 05 02:37:54 2011
DBRM started with pid=7, OS id=1552
Wed Oct 05 02:37:54 2011
DIA0 started with pid=8, OS id=2668
Wed Oct 05 02:37:54 2011
MMAN started with pid=9, OS id=2132
Wed Oct 05 02:37:54 2011
DBW0 started with pid=10, OS id=3716
Wed Oct 05 02:37:54 2011
LGWR started with pid=11, OS id=3952
Wed Oct 05 02:37:54 2011
CKPT started with pid=12, OS id=2992
Wed Oct 05 02:37:54 2011
SMON started with pid=13, OS id=2616
Wed Oct 05 02:37:54 2011
RECO started with pid=14, OS id=1764
Wed Oct 05 02:37:54 2011
MMON started with pid=15, OS id=4012
Wed Oct 05 02:37:54 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
ORACLE_BASE from environment = E:\Database\Oracle\app\oracle
Wed Oct 05 02:37:55 2011
AUD: OS Error = 1717 encountered while writing audit record
Wed Oct 05 02:37:54 2011
MMNL started with pid=16, OS id=1516
Wed Oct 05 02:37:57 2011
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
AUD: OS Error = 1717 encountered while writing audit record
Starting ORACLE instance (normal)
Wed Oct 05 02:38:02 2011
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
Wed Oct 05 02:38:03 2011
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
Wed Oct 05 02:38:03 2011
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
Wed Oct 05 02:38:03 2011
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
From what I could gather from other posts here (and on other sites) the problem is I don't have anything listening on 8080. Other than that, all seems OK (I think).
So, can anyone tell me\help me on why that one isn't starting ? I reinstalled this 6 times and still can't figure out the problem... (as you saw, I even replaced the tns hostname with 127.0.0.1 out of paranoia). It's seriously driving me mad. Every topic I searched for (from the problem itself to even a step-by-step for dummies) shows an install, then the interface working... I see some questions regarding "I can't connect to..." but most are unanswered :(
Thanks in advance!
P.S. let me know if I forgot to mention anything relevant