Sap Sourcing 9.0(installation) Oracle Text Search installation error

[Former Member]

Hello Experts,

I am trying to install  SAP sourcing 9.0 on NW 7.3 Java. As per the installation guide oracle text search should be installed before preparing a basine database via DBIMPORT tool.

Here I am facing some issue.I am trying to run the catctx.sql script which required parameters, but the same is throwing error

ERROR at line 1:

ORA-39705: component 'CONTEXT' not found in registry

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

ORA-06512: at "SYS.DBMS_REGISTRY", line 580

ORA-06512: at line 1

BEGIN sys.validate_context; END;

          *

ERROR at line 1:

ORA-06550: line 1, column 11:

PLS-00905: object SYS.VALIDATE_CONTEXT is invalid

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

The ctxsys user is not being created at all.

Oracle version--11.2.0.3

N.B-I am using the same database of NW 7.3 java for oracle text search installation and will try to create a baseline database for sourcing using DBIMPORT.

Please suggest and let me know if I am missing anything here.

Thanks,

Debaditya

[former_member89217]

If the database is installed by Netweaver during Netweaver install. It will not have text search setup. This will need to be done separately using Oracle documentation.  A standalone Oracle installation typically would have text search setup by default.

Gary

[Former Member]

Yes the database is created during NW installation.As per the sourcing installation guide I am trying to setup text search.But the same is throwing error.

Best Regards,

Debaditya

[former_member89217]

Could you provide the sequence of command lines you used for steps 1-5?

Gary

[Former Member]

1.cd app/administrator/product/11.2.0/dbhome_1/ctx/admin

2.sqlplus /nolog

3/4.conn /as sysdba

5.@catctx.sql passw5ord SYSAUX TEMP NOLOCK

Best Regards,

Debaditya

[former_member89217]

Looks OK to me. I assume you did login as system user.  You may have to bring this to an Oracle forum or file a support incident against the database.  After google check on the errors there really wasn't a specific cause that I could determine.

Gary