reconfiguring apex after creating XE database
766377May 10 2010 — edited May 21 2010Hello every one!
my first post!
after a while searching for an answer on the net, time passed and I must admit I have difficulties making APEX worked.
I created a new database, dropped the factory XE one, because I need the same character set as my exported database file:
<h4>
alter database character set WE8ISO8859P1;
alter database character set WE8ISO8859P1
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
</h4>
I created the database:
<h4>
alter system enable restricted session;
drop database;
startup mount
</h4>
I recreated the database XE with the good charset parrameters
--------------------------------------------------------------------------------------------------------------------------------
Reconfiguring!
---------------------------------------------------------------------------------------------------------------------------------
/etc/init.d/oracle-xe configure
PROBLEM!:
<h4>
Specify a port that will be used for the database listener [1521]:
Port 1521 appears to be in use by another application. Please specify a different port.
Specify a port that will be used for the database listener [1521]:
</h4>
SO, I did
<h4>I stopped the listener:</h4> lsnrctl stop
<h4>I stopped the database:</h4> /etc/init.d/oracle-xe stop
<h4>I removed the configuration file:</h4> rm /etc/sysconfig/oracle-xe
<h4>I erased the semaphore using the commands:</h4> ipcs, sysresv and ipcrm
<h4>I ran:</h4> /etc/init.d/oracle-xe configure
configured default param.
connected as sysdba
<h4>ran:</h4>
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/admin/catalog.sql
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/admin/catproc.sql
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/admin/caths.sql
SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
now writing http://localhost:8080/apex/apex pops me up a login window
"Authentication required
the server localhost:8080 at XDB requires a username ans password"
<h4>So I did:</h4>
SQL> alter user anonymous account unlock;
User altered.
SQL> alter user XDB account unlock;
User altered.
Same problem... So I entered:
sys
********
and the page is an index page:
Index of /
public/
sys/
xdbconfig.xml
when I installed oracle XE from scratch, APEX was running well with login interface. I looked in the 2 DBA and Administrator books for reinstalling APEX, but I needed to create an xdb user, xdb tablespace, dowloading apex software, etc. These books are more intended to the standard version of 10g. When installing XE, all is done by magic in a black box, and when trying to change something, there is no documentation that really helps.
So does anyone has ever experienced the issue and could give me a hint? I am rather stucked
thanks
Rene