I just installed Oracle Database Express 11g. I have bunch of problems.
1)GetStarted does't work (Error: Unable to connect. Firefox can't establish a connection to the server at 127.0.0.1:8080)
2) I have problems with listeners(It seems I fixed them)
3) sqlplus connect without problems(Oracle SQL Developer also connect without problem i guess), but when I try to execute an query. Error appears.(ORA-1219 Database not open)
When i met these problems I reinstalled DB, It doesn't help.
My OS is Windows XP(SP3). I decide to change MySQL to Oracle. Possible problem in that....
When i try:
SQL> select * from customer;
select * from customer
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> alter database open
2 alter database mount
3 select * from cutomer;
alter database mount
*
ERROR at line 2:
ORA-02288l: Invalid OPEN mode