[prev in list] [next in list] [prev in thread] [next in thread]
List: suse-oracle
Subject: IFS - Install trouble
From: "Ferdinand Gassauer" <f.gassauer () aon ! at>
Date: 2001-06-07 7:21:21
[Download RAW message or body]
Hi!
I wanted to install IFS on ORACLE 8.1.7 using RAW IO on SuSE 7.0 kernel
2.2.19, latest LVM patch
I had to precreate the tablespaces on raw devices - I used a script similar
to this one, but my init extents were to small so I run out of extents :-(
I dropped the precreated tablespaces for ifs with the following script and
recreated them with larger initial values.
**************** Drop tablespaces **************************
drop tablespace IFS_MAIN INCLUDING CONTENTS;
drop tablespace IFS_LOB_N;
drop tablespace IFS_LOB_I;
drop tablespace IFS_CTX_I;
drop tablespace IFS_CTX_K;
drop tablespace IFS_CTX_X;
****************** create shell script ****************
#!/bin/sh
# this script precreates Tablespaces for IFS
# Please adapt ORACLE_HOME and ORACLE_SID
# and the /dev/raw[xx] entries to your needs
# the /dev/raw[xx] have to be precreated with LVM prior running this script
# Ferdinand Gassauer 6.june.2001
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$ORACLE_HOME/bin/svrmgrl << EOF
spool /$ORACLE_HOME/admin/$ORACLE_SID/create/IFS.log
connect internal
REM ********** TABLESPACE FOR IFS_MAIN **********
CREATE TABLESPACE IFS_MAIN DATAFILE '/dev/raw18' SIZE 50M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
gass@linux2:~ > cat *IFS*
#!/bin/sh
# this script precreates Tablespaces for IFS
# Please adapt ORACLE_HOME and ORACLE_SID
# and the /dev/raw[xx] entries to your needs
# the /dev/raw[xx] have to be precreated with LVM prior running this script
# Ferdinand Gassauer 6.june.2001
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$ORACLE_HOME/bin/svrmgrl << EOF
spool /$ORACLE_HOME/admin/$ORACLE_SID/create/IFS.log
connect internal
REM ********** TABLESPACE FOR IFS_MAIN **********
CREATE TABLESPACE IFS_MAIN DATAFILE '/dev/raw18' SIZE 50M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096
PCTINCREASE
0);
REM ********** TABLESPACE FOR IFS_LOB_N **********
CREATE TABLESPACE IFS_LOB_N DATAFILE '/dev/raw19' SIZE 150M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
REM ********** TABLESPACE FOR IFS_LOB_I **********
CREATE TABLESPACE IFS_LOB_I DATAFILE '/dev/raw20' SIZE 150M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
REM ********** TABLESPACE FOR IFS_CTX_I **********
CREATE TABLESPACE IFS_CTX_I DATAFILE '/dev/raw21' SIZE 10M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
REM ********** TABLESPACE FOR IFS_CTX_K **********
CREATE TABLESPACE IFS_CTX_K DATAFILE '/dev/raw22' SIZE 10M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
REM ********** TABLESPACE FOR IFS_CTX_X **********
CREATE TABLESPACE IFS_CTX_X DATAFILE '/dev/raw23' SIZE 10M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
disconnect
spool off
exit
EOF
Now the trouble started because one table is missing or not available.
unfortunately oracle error does NOT report which table is missing. so I run
out of ideas :-(
oracle@linux2:/tmp > cat I*log
------------------------------------------------------------------
Configuring Oracle Internet File System 1.1.5.0.0
configuration started on: Thu Jun 07 08:39:07 CEST 2001
saving user configuration settings to file:
saving:/opt/oracle/OraHome817/ifs1.1/settings/oracle/ifs/installer/propertie
s/
IfsConfig.properties
iFS service properties directory:
/opt/oracle/OraHome817/ifs1.1/settings/oracle/
ifs/server/properties
saving: NbServer.properties
saving: IfsDefault.properties
saving: ServerManager.properties
saving: CupServer.properties
saving: SmbServer.properties
saving: IfsDefault2.properties
saving: FtpServer.properties
saving: IfsTools.properties
saving: SmtpServer.properties
saving: HttpServer.properties
saving: ImapServer.properties
saving: WcpServer.properties
saving: IfsDefault1.properties
saving: IfsMinimum.properties
saving file:
/opt/oracle/OraHome817/ifs1.1/settings/oracle/ifs/protocols/dav/imp
l/properties/IfsDavServletParameters.properties
dropping user: IFS_Wien
dropping user: IFS_Wien$CM
tablespace IFS_MAIN already exists; using it.
tablespace IFS_LOB_N already exists; using it.
tablespace IFS_LOB_I already exists; using it.
tablespace IFS_CTX_I already exists; using it.
tablespace IFS_CTX_K already exists; using it.
tablespace IFS_CTX_X already exists; using it.
creating database user (schema): IFS_Wien
creating iFS credential manager schema...
creating database schema: IFS_Wien$CM
executing SQL script:
/opt/oracle/OraHome817/ifs1.1/admin/sql/CreateIfsCredent
ialManager2.sql
invoking loadjava...
executing external process:
/opt/oracle/OraHome817/ifs1.1/jre/bin/jre -classpath
/opt/oracle/OraHome817/
ifs1.1/jws/lib/servlet.jar:/opt/oracle/OraHome817/ifs1.1/jws/lib/jst.jar:/op
t/or
acle/OraHome817/jdbc/lib/classes111.zip::/opt/oracle/OraHome817/ifs1.1/custo
m_cl
asses:/opt/oracle/OraHome817/ifs1.1/jre/lib/rt.jar:/opt/oracle/OraHome817/if
s1.1
/jre/lib/i18n.jar::/opt/oracle/OraHome817/ifs1.1/custom_classes:/opt/oracle/
OraH
ome817/ifs1.1/settings:/opt/oracle/OraHome817/lib/xmlparserv2.jar:/opt/oracl
e/Or
aHome817/ifs1.1/lib/repos.jar:/opt/oracle/OraHome817/ifs1.1/lib/utils.jar:/o
pt/o
racle/OraHome817/ifs1.1/lib/adk.jar:/opt/oracle/OraHome817/ifs1.1/lib/releas
e.ja
r:/opt/oracle/OraHome817/ifs1.1/lib/installer.jar:/opt/oracle/OraHome817/ifs
1.1/
lib/email.jar:/opt/oracle/OraHome817/jlib/swingall-1_1_1.jar:/opt/oracle/Ora
Home
817/ifs1.1/lib/jewt-opt-4_1_1.zip:/opt/oracle/OraHome817/ifs1.1/lib/share-op
t-1_
1_7.zip:/opt/oracle/OraHome817/ifs1.1/lib/wcp.jar:/opt/oracle/OraHome817/ifs
1.1/
lib/clientlib.jar:/opt/oracle/OraHome817/ifs1.1/lib/cup.jar:/opt/oracle/OraH
ome8
17/ifs1.1/lib/smb.jar:/opt/oracle/OraHome817/ifs1.1/lib/email.jar:/opt/oracl
e/Or
aHome817/ifs1.1/lib/ftp.jar:/opt/oracle/OraHome817/jdbc/lib/classes111.zip:/
opt/
oracle/OraHome817/ifs1.1/lib/oemadmin.jar:/opt/oracle/OraHome817/lib/vbjorb.
jar:
/opt/oracle/OraHome817/classes:/opt/oracle/OraHome817/classes/classesFromIDL
Visi
:/opt/oracle/OraHome817/jlib/help-3_1_8.jar:/opt/oracle/OraHome817/jlib/ice-
4_06
_6.jar:/opt/oracle/OraHome817/jlib/ewt-3_3_6.jar:/opt/oracle/OraHome817/jlib
/ewt
compat-opt-3_3_6.zip:/opt/oracle/OraHome817/ifs1.1/lib/cmdlineutils.jar:/opt
/ora
cle/OraHome817/ifs1.1/lib/http.jar:/opt/oracle/OraHome817/ifs1.1/lib/webui.j
ar:/
opt/oracle/OraHome817/jsp/lib/ojsp.jar:/opt/oracle/OraHome817/jis/lib/servle
t.ja
r:/opt/oracle/OraHome817/javavm/lib/aurora.zip:/opt/oracle/OraHome817/sqlj/l
ib/t
ranslator.zip:/opt/oracle/OraHome817/lib/aurora_client.jar
oracle.aurora.server.
tools.loadjava.LoadJavaMain -u IFS_Wien$CM/IFS_Wien$CM@ -r -f
/opt/oracle/OraHo
me817/ifs1.1/admin/classes/oracle/ifs/server/Md4.class
/opt/oracle/OraHome817/if
s1.1/admin/classes/oracle/ifs/server/IfsCredentialManagerServer.class
Error while loading oracle/ifs/server/Md4
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/Md4
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while loading oracle/ifs/server/IfsCredentialManagerServer
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/IfsCredentialManagerServer
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while resolving class oracle/ifs/server/Md4
ORA-04043: Objekt oracle/ifs/server/Md4 existiert nicht
Error while resolving class oracle/ifs/server/IfsCredentialManagerServer
ORA-04043: Objekt /4d311df_IfsCredentialManagerS existiert nicht
loadjava: 6 errors
rolling back (dropping schema IFS_Wien$CM)
error rolling back:
java.sql.SQLException: ORA-01940: Ein Benutzer, der gerade mit der DB
verbunden
ist, kann nicht gelöscht werden
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.doExecuteWithTimeout(Compiled
Code
)
at oracle.jdbc.driver.OracleStatement.execute(Compiled Code)
at oracle.ifs.utils.sql.SQLCommands.dropUser(Compiled Code)
at
oracle.ifs.installer.CreateCredentialMgrSchemaAction.execute(Compiled
Code)
at oracle.ifs.utils.sql.JDBCAction.perform(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)
creating iFS security schema failed; the following error occurred:
oracle.ifs.utils.action.ActionFailedException: Error executing loadjava
process.
The output given was:
Error while loading oracle/ifs/server/Md4
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/Md4
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while loading oracle/ifs/server/IfsCredentialManagerServer
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/IfsCredentialManagerServer
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while resolving class oracle/ifs/server/Md4
ORA-04043: Objekt oracle/ifs/server/Md4 existiert nicht
Error while resolving class oracle/ifs/server/IfsCredentialManagerServer
ORA-04043: Objekt /4d311df_IfsCredentialManagerS existiert nicht
loadjava: 6 errors
at
oracle.ifs.installer.CreateCredentialMgrSchemaAction.loadJava(Compile
d Code)
at
oracle.ifs.installer.CreateCredentialMgrSchemaAction.execute(Compiled
Code)
at oracle.ifs.utils.sql.JDBCAction.perform(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)
oracle.ifs.utils.action.ActionFailedException:
oracle.ifs.utils.action.ActionFai
ledException: Error executing loadjava process. The output given was:
Error while loading oracle/ifs/server/Md4
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/Md4
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while loading oracle/ifs/server/IfsCredentialManagerServer
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/IfsCredentialManagerServer
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while resolving class oracle/ifs/server/Md4
ORA-04043: Objekt oracle/ifs/server/Md4 existiert nicht
Error while resolving class oracle/ifs/server/IfsCredentialManagerServer
ORA-04043: Objekt /4d311df_IfsCredentialManagerS existiert nicht
loadjava: 6 errors
at
oracle.ifs.installer.CreateCredentialMgrSchemaAction.execute(Compiled
Code)
at oracle.ifs.utils.sql.JDBCAction.perform(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)
oracle.ifs.utils.action.ActionFailedException:
oracle.ifs.utils.action.ActionFai
ledException: oracle.ifs.utils.action.ActionFailedException: Error executing
loa
djava process. The output given was:
Error while loading oracle/ifs/server/Md4
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/Md4
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while loading oracle/ifs/server/IfsCredentialManagerServer
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/IfsCredentialManagerServer
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while resolving class oracle/ifs/server/Md4
ORA-04043: Objekt oracle/ifs/server/Md4 existiert nicht
Error while resolving class oracle/ifs/server/IfsCredentialManagerServer
ORA-04043: Objekt /4d311df_IfsCredentialManagerS existiert nicht
loadjava: 6 errors
at oracle.ifs.utils.sql.JDBCAction.perform(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/oracle/OraHome817/ifs1.1/settings/oracle/ifs/installer/propertie
s/
IfsConfig.properties
iFS configuration failed; the following error occurred:
oracle.ifs.utils.action.ActionFailedException:
oracle.ifs.utils.action.ActionFai
ledException: oracle.ifs.utils.action.ActionFailedException:
oracle.ifs.utils.ac
tion.ActionFailedException: Error executing loadjava process. The output
given w
as:
Error while loading oracle/ifs/server/Md4
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/Md4
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while loading oracle/ifs/server/IfsCredentialManagerServer
ORA-00942: Tabelle oder View nicht vorhanden
Error while creating class oracle/ifs/server/IfsCredentialManagerServer
ORA-29506: Ungültige Abfrage von USING-Klausel abgeleitet
ORA-00942: Tabelle oder View nicht vorhanden
Error while resolving class oracle/ifs/server/Md4
ORA-04043: Objekt oracle/ifs/server/Md4 existiert nicht
Error while resolving class oracle/ifs/server/IfsCredentialManagerServer
ORA-04043: Objekt /4d311df_IfsCredentialManagerS existiert nicht
loadjava: 6 errors
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 Jun 07 08:39:18 CEST 2001
thanks in advance
ferdinand
BTW
netasst is a wonderful tool but a button "Apply" (saving the changes AND
[re]starting the listener) would increase the usability a lot.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic