Installing OracleText-schema (CTXSYS)

Trying to install APEX 4.0 on a 10gR2-DB I was stopped with this message:

"Application Express installation requires the Oracle Text database component"

The manual says it is needed for the online-help or so. Anyway I need it to do the install.
Checking the server-install I found the OracleText component already installed on my server. After some googling I knew that the OracleText is stored in the schema CTXSYS. Remembering that schema from some other DBs I checked their install-scripts and found a context.sql. This site confirmed me and so I got to SQL+ and run:

@$ORACLE_HOME/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK;

connected as CTXSYS and run:

@$ORACLE_HOME/ctx/admin/defaults/dr0defin.sql "AMERICAN";

to set the default country,

and had the desired OracleText in my DB. Going to install APEX 4.0….


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: