iFS configuration problem.

3004

I am using Oracle 8.1.6. I try to configure the iFS, I met an exception and configuration failed. Next is content of the log file:

Configuring Oracle internet File System 1.0.8.0.0
configuration started on: Thu May 11 16:00:01 EDT 2000

saving user configuration settings to file:
saving:/opt/app/oracle/product/8.1.6/ifs/settings/oracle/ifs/installer/propert
ies/IfsConfig.properties
iFS service properties directory: /opt/app/oracle/product/8.1.6/ifs/settings/ora
cle/ifs/server/properties
saving: CupServer.properties
saving: FtpServer.properties
saving: HttpServer.properties
saving: ImapServer.properties
saving: IfsDefault.properties
saving: IfsMinimum.properties
saving: IfsTools.properties
saving: SmtpServer.properties
saving: WcpServer.properties
saving: ServerManager.properties
saving: NbServer.properties
saving: SmbServer.properties
saving: IfsDefault1.properties
saving: IfsDefault2.properties
saving file: /opt/app/oracle/product/8.1.6/ifs/settings/oracle/ifs/protocols/htt
p/properties/IfsHttpServletParameters.properties
saving file: /opt/app/oracle/product/8.1.6/ifs/jws/properties/server/javawebserv
er/webpageservice/endpoint.properties
saving file: /opt/app/oracle/product/8.1.6/ifs/jws/properties/server/javawebserv
er/webpageservice/servlets.properties
changing IFSSYS password to the new one
dropping user: ifssys
tablespace IFS already exists; using it.
tablespace IFSLOB already exists; using it.
tablespace IFSINDEX already exists; using it.
tablespace IFSIMINDEX already exists; using it.
tablespace IFSKEYMAP already exists; using it.
tablespace IFSIMDATA already exists; using it.
creating user ifssys
java.sql.SQLException: ORA-04042: procedure, function, package, or package body
does not exist

at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(Compiled Code)
at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(Compiled Code)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecute(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Compiled Code
)
at oracle.jdbc.driver.OracleStatement.execute(Compiled Code)
at oracle.ifs.utils.sql.SQLCommands.grantPriviledgeToUser(Compiled Code)
at oracle.ifs.installer.IfsConfiguration$CreateSchemaAction.createIfsUse
r(Compiled Code)
at oracle.ifs.installer.IfsConfiguration$CreateSchemaAction.perform(Comp
iled Code)
at oracle.ifs.utils.action.ActionQueue.performActions(Compiled Code)
at oracle.ifs.utils.action.ActionQueue.run(Compiled Code)
at java.lang.Thread.run(Compiled Code)
recording that configuration failed
saving:/opt/app/oracle/product/8.1.6/ifs/settings/oracle/ifs/installer/propert
ies/IfsConfig.properties
iFS configuration failed; the following error occurred:

oracle.ifs.utils.action.ActionFailedException: java.sql.SQLException: ORA-04042:
procedure, function, package, or package body does not exist

at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at oracle.ifs.utils.action.ActionFailedException.<init>(Compiled Code)
at oracle.ifs.installer.IfsConfiguration$CreateSchemaAction.perform(Comp
iled Code)
at oracle.ifs.utils.action.ActionQueue.performActions(Compiled Code)
at oracle.ifs.utils.action.ActionQueue.run(Compiled Code)
at java.lang.Thread.run(Compiled Code)

configuration failed on Thu May 11 16:00:10 EDT 2000.


Thanks in advance!


null

3004

It seems that your database doesn't have the DBMS_OBFUSCATION_PACKAGE, which is required for iFS authentication. This is strange, because the configuration assistant should have checked for this and complained.

Try the following test...this is exactly what the configuration is trying to do at the point where it failed:

$> sqlplus sys
SQL> create user TEST identified by TEST;
SQL> grant EXECUTE ON DBMS_OBFUSCATION_TOOLKIT to TEST;
SQL> drop user TEST cascade;

I'll bet you get the same error (ORA-04042). If so, do the following:

$> cd $ORACLE_HOME/rdbms/admin
$> sqlplus sys
SQL> @catobtk.sql
SQL> GRANT EXECUTE ON DBMS_OBFUSCATION_TOOLKIT TO PUBLIC;

The last grant isn't absolutely necessary, but hey, just for grins.

3004

Thanks. Fix it!!