Forum Stats

  • 3,769,241 Users
  • 2,252,938 Discussions
  • 7,874,958 Comments

Discussions

iFS configuration problem.

3004
3004 Member Posts: 204,171
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

Comments

  • 3004
    3004 Member Posts: 204,171
    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
    3004 Member Posts: 204,171
    Thanks. Fix it!!
This discussion has been closed.