Hi, I am installing Intralink Version 3.4 F001 (licensed copy) on my Win 2000 system along with Oracle 9ir2 (9.2.0.1) downloaded from Oracle OTN download site. We've had the license for 2 yrs and never installed/utilized it. I am trying to install for the first time.
Anyways, in the installation guide, it asked for Oracle 9.2.0.4 patchset. Since I did not have metalink access. I asked a friend of mine to get that for me. He gave me few *.dll files - listed below, which I copied onto oracle loadpoint\bin.
The following files are provided with this patchset:
OraOLEDB.dll
OraOLEDB.tlb
OraOLEDBgmr.dll
OraOLEDBpus.dll
OraOLEDBrfc.dll
OraOLEDBrmc.dll
OraOLEDBrst.dll
OraOLEDBus.dll
OraOLEDButl.dll
During install I applied all parameters and environments , as described in the install guide & tips from other forums.
But dataserver install still fails.
The install log file looks like this.....
10/19/06 16:13:13 ###########################################################
10/19/06 16:13:14 Pro/INTRALINK Data Server installation
10/19/06 16:13:14 Started: 10/19/06 16:13:14
10/19/06 16:13:15 DebugLevel = "0"
10/19/06 16:13:15 Installation parameters:
10/19/06 16:13:15 Installation type = "ALL"
10/19/06 16:13:16 ORACLE_SID&n bsp; = ilnk
10/19/06 16:13:16 Database size = MEDIUM
10/19/06 16:13:17 Data files directory = d:\ptc\dataserver\intralink\dbs
10/19/06 16:13:17 Character set = UTF8
10/19/06 16:13:17 Language&nbs p; = ENGLISH
10/19/06 16:13:18 SQL*Net service name = INTRALINK
10/19/06 16:13:18 File server host = mech1
10/19/06 16:13:19 File server port = 7777
10/19/06 16:13:19 File server path = d:\ptc\filevault
10/19/06 16:13:20
###########################################################
10/19/06 16:13:20 Variable OraHomePath is set to "d:/oracle/ora92"
10/19/06 16:13:21
Checking installed Oracle Software
10/19/06 16:13:21 Oracle Software installation is verified.10/19/06 16:13:22 Proceeding to the next step.
10/19/06 16:13:22
Starting ORACLE database installation:
10/19/06 16:13:24 Redo Log Group number 1 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_redolog_g01_m01.dbf)
10/19/06 16:13:25 Redo Log Group number 2 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_redolog_g02_m01.dbf)
10/19/06 16:13:25 Redo Log Group number 3 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_redolog_g03_m01.dbf)
10/19/06 16:13:25 Control File number 1 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_controlfile_01.ctl)
10/19/06 16:13:26 Control File number 2 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_controlfile_02.ctl)
10/19/06 16:13:26 Control File number 3 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_controlfile_03.ctl)
10/19/06 16:13:27 Template Tablespace registered: NAME SYSTEM
10/19/06 16:13:27 Data file added to template: FULL_NAME d:/ptc/dataserver/intralink/dbs/system_01.dbf SIZE 275 TS SYSTEM
10/19/06 16:13:28 Template Tablespace registered: NAME TEMP
10/19/06 16:13:29 Data file added to template: FULL_NAME d:/ptc/dataserver/intralink/dbs/temp_01.dbf SIZE 100 TS TEMP
10/19/06 16:13:30 Template Tablespace registered: NAME UNDOTBS1
10/19/06 16:13:31 Data file added to template: FULL_NAME d:/ptc/dataserver/intralink/dbs/undotbs1_01.dbf SIZE 200 TS UNDOTBS1
10/19/06 16:13:32 Tablespace registered: NAME SYSTEM
10/19/06 16:13:32 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_system_01.dbf SIZE 300 TS SYSTEM
10/19/06 16:13:33 Tablespace registered: NAME TEMP
10/19/06 16:13:34 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_temp_01.dbf SIZE 400 TS TEMP
10/19/06 16:13:34 Tablespace registered: NAME UNDOTBS1
10/19/06 16:13:36 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_undotbs1_01.dbf SIZE 400 TS UNDOTBS1
10/19/06 16:13:36 Tablespace registered: NAME DEVELOPMENT
10/19/06 16:13:37 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_development_1.dbf SIZE 50 TS DEVELOPMENT
10/19/06 16:13:38 Tablespace registered: NAME PDM_INDEX
10/19/06 16:13:39 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_pdm_index_1.dbf SIZE 800 TS PDM_INDEX
10/19/06 16:13:39 Tablespace registered: NAME PDM_TABLE
10/19/06 16:13:40 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_pdm_table_1.dbf SIZE 500 TS PDM_TABLE
10/19/06 16:13:42 Configuring Net Service Name "INTRALINK" ... 10/19/06 16:13:43 Running NETCA with parameters:
10/19/06 16:13:45 /silent /responseFile d:\Temp/ilnk_netca.rsp
10/19/06 16:14:02 errorCode=NONE
10/19/06 16:14:03 OK
10/19/06 16:14:04 Generating file location variable file ... 10/19/06 16:14:05
Contents of dbca variable file:
10/19/06 16:14:06 CTRLFILE_1_FILE=ilnk_controlfile_01.ctl
10/19/06 16:14:07 CTRLFILE_1_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:08 CTRLFILE_2_FILE=ilnk_controlfile_02.ctl
10/19/06 16:14:10 CTRLFILE_2_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:11 CTRLFILE_3_FILE=ilnk_controlfile_03.ctl
10/19/06 16:14:11 CTRLFILE_3_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:12 DATA_SYSTEM_FILE=ilnk_system_01.dbf
10/19/06 16:14:13 DATA_SYSTEM_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:14 DATA_TEMP_FILE=ilnk_temp_01.dbf
10/19/06 16:14:15 DATA_TEMP_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:16 DATA_UNDOTBS1_FILE=ilnk_undotbs1_01.dbf
10/19/06 16:14:17 DATA_UNDOTBS1_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:18 ORACLE_ADMIN=d:\\oracle\\ora92\\admin
10/19/06 16:14:19 ORACLE_SCRIPT=d:\\ptc\\dataserver\\intralink\\dbs\\create_db \\ilnk_PostCreate.sql
10/19/06 16:14:20 PATH_SEP=\\
10/19/06 16:14:21 REDOLOG_1_FILE=ilnk_redolog_g01_m01.dbf
10/19/06 16:14:22 REDOLOG_1_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:22 REDOLOG_2_FILE=ilnk_redolog_g02_m01.dbf
10/19/06 16:14:23 REDOLOG_2_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:23 REDOLOG_3_FILE=ilnk_redolog_g03_m01.dbf
10/19/06 16:14:24 REDOLOG_3_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:25 OK
10/19/06 16:14:25 Generating post creation SQL script ... 10/19/06 16:14:26 OK
10/19/06 16:14:27 Running Oracle Data Base Configuration Assistant (DBCA) ... 10/19/06 16:14:27
=============================================
10/19/06 16:14:28 Varaiables of namespace ":
roIDBCAHelper::" ...
10/19/06 16:14:29 :
roIDBCAHelper:
BCAShowMode= "-silent"
10/19/06 16:14:30 :
roIDBCAHelper:
BParametersList= "db_files 96 _b_tree_bitmap_plans false cursor_sharing EXACT db_cache_size 200M db_file_multiblock_read_count 16 undo_retention 10800 job_queue_processes 3 large_pool_size 0 log_checkpoint_timeout 1800 open_cursors 400 shared_pool_size 300M log_buffer 1048576 pga_aggregate_target 700M log_checkpoint_interval 204800 java_pool_size 20M processes 200 optimizer_mode CHOOSE"
10/19/06 16:14:31 :
roIDBCAHelper:
BTemplateDataJarFile= ""
10/19/06 16:14:32 :
roIDBCAHelper:
BTemplateFile= ""
10/19/06 16:14:33 :
roIDBCAHelper::OraHomePath= "d:/oracle/ora92"
10/19/06 16:14:33 :
roIDBCAHelper:
ackageRoot= "d:/ptc/dataserver/intralink/dbs/Tcl/proidbcahelper1.0"
10/19/06 16:14:34 :
roIDBCAHelper:
ostCreateScriptList= "{d:/ptc/dataserver/intralink\dbs/create_schema/PDMuserspriv s.sql PDM}"
10/19/06 16:14:36 :
roIDBCAHelper::ShowPwdWindow= "false"
10/19/06 16:14:37
Arrays of namespace ":
roIDBCAHelper::" ...
10/19/06 16:14:39
Array ":
roIDBCAHelper:
BPropertiesArr"
10/19/06 16:14:40 :
roIDBCAHelper:
BPropertiesArr(TEMPLATE_DATA_FILE,1)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/system_01.dbf SIZE 275 TS SYSTEM"
10/19/06 16:14:41 :
roIDBCAHelper:
BPropertiesArr(CONTROLFILE_NUMBER)= "3"
10/19/06 16:14:43 :
roIDBCAHelper:
BPropertiesArr(TEMPLATE_DATA_FILE,2)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/temp_01.dbf SIZE 100 TS TEMP"
10/19/06 16:14:44 :
roIDBCAHelper:
BPropertiesArr(TEMPLATE_DATA_FILE,3)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/undotbs1_01.dbf SIZE 200 TS UNDOTBS1"
10/19/06 16:14:45 :
roIDBCAHelper:
BPropertiesArr(TS,1)= "NAME SYSTEM"
10/19/06 16:14:46 :
roIDBCAHelper:
BPropertiesArr(REDOLOG_NAME_1)= "ilnk_redolog_g01_m01.dbf"
10/19/06 16:14:47 :
roIDBCAHelper:
BPropertiesArr(TS,2)= "NAME TEMP"
10/19/06 16:14:48 :
roIDBCAHelper:
BPropertiesArr(REDOLOG_NAME_2)= "ilnk_redolog_g02_m01.dbf"
10/19/06 16:14:49 :
roIDBCAHelper:
BPropertiesArr(ORACLE_SID)= "ilnk"
10/19/06 16:14:50 :
roIDBCAHelper:
BPropertiesArr(TS,3)= "NAME UNDOTBS1"
10/19/06 16:14:51 :
roIDBCAHelper:
BPropertiesArr(DATA_FILE,1)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_system_01.dbf SIZE 300 TS SYSTEM"
10/19/06 16:14:52 :
roIDBCAHelper:
BPropertiesArr(REDOLOG_NAME_3)= "ilnk_redolog_g03_m01.dbf"
10/19/06 16:14:53 :
roIDBCAHelper:
BPropertiesArr(NLSCHAR_SET)= "UTF8"
10/19/06 16:14:53 :
roIDBCAHelper:
BPropertiesArr(DB_GLOBAL_NAME)= "ilnk"
10/19/06 16:14:55 :
roIDBCAHelper:
BPropertiesArr(LOGFILES_DIRS)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:14:56 :
roIDBCAHelper:
BPropertiesArr(TS,4)= "NAME DEVELOPMENT"
10/19/06 16:14:57 :
roIDBCAHelper:
BPropertiesArr(DATA_FILE,2)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_temp_01.dbf SIZE 400 TS TEMP"
10/19/06 16:14:57 :
roIDBCAHelper:
BPropertiesArr(TEMPLATE_TS,1)= "NAME SYSTEM"
10/19/06 16:14:58 :
roIDBCAHelper:
BPropertiesArr(CONTROLFILE_DIR_1)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:14:59 :
roIDBCAHelper:
BPropertiesArr(GENERATED_FILES_DIR)= "d:/ptc/dataserver/intralink\dbs\create_db"
10/19/06 16:15:00 :
roIDBCAHelper:
BPropertiesArr(TS,5)= "NAME PDM_INDEX"
10/19/06 16:15:01 :
roIDBCAHelper:
BPropertiesArr(DATA_FILE,3)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_undotbs1_01.dbf SIZE 400 TS UNDOTBS1"
10/19/06 16:15:02 :
roIDBCAHelper:
BPropertiesArr(TEMPLATE_TS,2)= "NAME TEMP"
10/19/06 16:15:03 :
roIDBCAHelper:
BPropertiesArr(CONTROLFILE_DIR_2)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:15:04 :
roIDBCAHelper:
BPropertiesArr(TS,6)= "NAME PDM_TABLE"
10/19/06 16:15:04 :
roIDBCAHelper:
BPropertiesArr(DATA_FILE,4)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_development_1.dbf SIZE 50 TS DEVELOPMENT"
10/19/06 16:15:06 :
roIDBCAHelper:
BPropertiesArr(TEMPLATE_TS,3)= "NAME UNDOTBS1"
10/19/06 16:15:06 :
roIDBCAHelper:
BPropertiesArr(CONTROLFILE_DIR_3)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:15:07 :
roIDBCAHelper:
BPropertiesArr(CTRLFILES_DIRS)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:15:08 :
roIDBCAHelper:
BPropertiesArr(CONTROLFILE_NAME_1)= "ilnk_controlfile_01.ctl"
10/19/06 16:15:08 :
roIDBCAHelper:
BPropertiesArr(CHAR_SET)= "UTF8"
10/19/06 16:15:09 :
roIDBCAHelper:
BPropertiesArr(DATA_FILE,5)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_pdm_index_1.dbf SIZE 800 TS PDM_INDEX"
10/19/06 16:15:09 :
roIDBCAHelper:
BPropertiesArr(CONTROLFILE_NAME_2)= "ilnk_controlfile_02.ctl"
10/19/06 16:15:10 :
roIDBCAHelper:
BPropertiesArr(NET_SVC_NAME)= "INTRALINK"
10/19/06 16:15:11 :
roIDBCAHelper:
BPropertiesArr(REDOLOG_DIR_1)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:15:11 :
roIDBCAHelper:
BPropertiesArr(DATA_FILE,6)= "FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_pdm_table_1.dbf SIZE 500 TS PDM_TABLE"
10/19/06 16:15:12 :
roIDBCAHelper:
BPropertiesArr(CONTROLFILE_NAME_3)= "ilnk_controlfile_03.ctl"
10/19/06 16:15:13 :
roIDBCAHelper:
BPropertiesArr(REDOLOG_DIR_2)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:15:13 :
roIDBCAHelper:
BPropertiesArr(REDOLOG_DIR_3)= "d:/ptc/dataserver/intralink/dbs"
10/19/06 16:15:14 :
roIDBCAHelper:
BPropertiesArr(REDOLOG_NUMBER)= "3"
10/19/06 16:15:15 :
roIDBCAHelper:
BPropertiesArr(DB_FILES_DIR)= "d:/ptc/dataserver/intralink/dbs/"
10/19/06 16:15:15 =============================================
10/19/06 16:15:16 ORACLE_SID = ilnk
10/19/06 16:15:17 Global DB Name = ilnk
10/19/06 16:15:18 CharSset = UTF8
10/19/06 16:15:18 National CharSet = UTF8
10/19/06 16:15:19 DBCA mode = -silent
10/19/06 16:15:21 ShowPwdWindow = false
10/19/06 16:15:21
Running dbca command:
10/19/06 16:15:23 exec d:/oracle/ora92/bin/dbca.bat -silent -passwordDialog false -createDatabase -templateName UTF8_DBDataTempl.dbc -datafileJarLocation d:/ptc/dataserver/intralink/dbs/Tcl/proidbcahelper1.0/templa tes/windows/UTF8_DBDataTempl.dfj -sid ilnk -gdbname ilnk -characterSet UTF8 -nationalCharacterSet UTF8 -variablesFile {d:\ptc\dataserver\intralink\dbs\create_db\ilnk_dbca_vars.tx t}
10/19/06 16:15:38 errorCode=NONE
10/19/06 16:15:39 DBCA error message was:
10/19/06 16:15:40 =======
10/19/06 16:15:41 invalid command name "Look at the log file "D:\oracle\ora92\assistants\dbca\logs\ilnk5.log" for further details."
10/19/06 16:15:42 =======
10/19/06 16:15:44 Trying to find out name of log file 10/19/06 16:15:45 (if it was in the message):
10/19/06 16:15:46 Can not identify the log file.
10/19/06 16:15:48 OK
10/19/06 16:15:49 Synchronizing Database File Names ... 10/19/06 16:16:33 Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
10/19/06 16:16:34 Performing file type check up. Issuing command:
set feedback off
set head off
set pages 0
select case
when
upper('d:\ptc\dataserver\intralink\dbs\system_01.dbf') in (select upper(name) from v$tempfile)
then
upper('temp')
else
upper('data_undo') end Type
from dual;
exit 0
10/19/06 16:16:53 File d:\ptc\dataserver\intralink\dbs\system_01.dbf appears to be of type: DATA_UNDO
10/19/06 16:16:53 Renaming file d:\ptc\dataserver\intralink\dbs\system_01.dbf to d:\ptc\dataserver\intralink\dbs\ilnk_system_01.dbf
10/19/06 16:16:54 File has been renamed successfully.
10/19/06 16:16:55 Performing file type check up. Issuing command:
set feedback off
set head off
set pages 0
select case
when
upper('d:\ptc\dataserver\intralink\dbs\temp_01.dbf') in (select upper(name) from v$tempfile)
then
upper('temp')
else
upper('data_undo') end Type
from dual;
exit 0
10/19/06 16:17:11 File d:\ptc\dataserver\intralink\dbs\temp_01.dbf appears to be of type: DATA_UNDO
10/19/06 16:17:12 Renaming file d:\ptc\dataserver\intralink\dbs\temp_01.dbf to d:\ptc\dataserver\intralink\dbs\ilnk_temp_01.dbf
10/19/06 16:17:13 File has been renamed successfully.
10/19/06 16:17:14 Performing file type check up. Issuing command:
set feedback off
set head off
set pages 0
select case
when
upper('d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf') in (select upper(name) from v$tempfile)
then
upper('temp')
else
upper('data_undo') end Type
from dual;
exit 0
10/19/06 16:17:31 File d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf appears to be of type: DATA_UNDO
10/19/06 16:17:32 Renaming file d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf to d:\ptc\dataserver\intralink\dbs\ilnk_undotbs1_01.dbf
10/19/06 16:17:34 File has been renamed successfully.
10/19/06 16:18:31
Database altered.
10/19/06 16:18:32 Performing tempfile type check up. Issuing command:
set feedback off
set head off
set pages 0
select bytes/1024/1024||'M' from v$tempfile
where name='d:\ptc\dataserver\intralink\dbs\system_01.dbf'
or name=upper('d:\ptc\dataserver\intralink\dbs\system_01.dbf');
exit 0
10/19/06 16:18:51 Performing tempfile type check up. Issuing command:
set feedback off
set head off
set pages 0
select bytes/1024/1024||'M' from v$tempfile
where name='d:\ptc\dataserver\intralink\dbs\temp_01.dbf'
or name=upper('d:\ptc\dataserver\intralink\dbs\temp_01.dbf');
exit 0
10/19/06 16:19:10 Performing tempfile type check up. Issuing command:
set feedback off
set head off
set pages 0
select bytes/1024/1024||'M' from v$tempfile
where name='d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf'
or name=upper('d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf' );
exit 0
10/19/06 16:19:27 OK
10/19/06 16:19:28 Initializing package for database SID = ilnk
10/19/06 16:19:29 Starting database ilnk
10/19/06 16:19:30 Retrieving status for database ilnk
10/19/06 16:19:30 Retrieving status of Oracle Service OracleServiceILNK
10/19/06 16:19:46 Instance is running and database is open
10/19/06 16:19:47 Changing password for user SYSTEM ... 10/19/06 16:20:09
Error during changing SYSTEM's password:
List of error messages:
ORA-00959: tablespace 'PDM_TABLE' does not exist
ORA-06512: at line 94
Errors description:
ptc_oerr: data for ORA-00959: was not found.
ptc_oerr: data for ORA-06512: was not found.
------------------------------------------------------------ -----------------
The installation terminates with these errors.
It seems like it cannot change user system password & fails to create PDM_table.
Any solutions? Whats wrong? Is patchset files right?
Please help!!!!!!!!!!!!!!!!!!!!!!!!!!!1
I cannot pass by this error. Very frustrating. Tried asking PTC support, but no help avilable since our AMC had expired couple years ago.
Thanks.
Anyways, in the installation guide, it asked for Oracle 9.2.0.4 patchset. Since I did not have metalink access. I asked a friend of mine to get that for me. He gave me few *.dll files - listed below, which I copied onto oracle loadpoint\bin.
The following files are provided with this patchset:
OraOLEDB.dll
OraOLEDB.tlb
OraOLEDBgmr.dll
OraOLEDBpus.dll
OraOLEDBrfc.dll
OraOLEDBrmc.dll
OraOLEDBrst.dll
OraOLEDBus.dll
OraOLEDButl.dll
During install I applied all parameters and environments , as described in the install guide & tips from other forums.
But dataserver install still fails.
The install log file looks like this.....
10/19/06 16:13:13 ###########################################################
10/19/06 16:13:14 Pro/INTRALINK Data Server installation
10/19/06 16:13:14 Started: 10/19/06 16:13:14
10/19/06 16:13:15 DebugLevel = "0"
10/19/06 16:13:15 Installation parameters:
10/19/06 16:13:15 Installation type = "ALL"
10/19/06 16:13:16 ORACLE_SID&n bsp; = ilnk
10/19/06 16:13:16 Database size = MEDIUM
10/19/06 16:13:17 Data files directory = d:\ptc\dataserver\intralink\dbs
10/19/06 16:13:17 Character set = UTF8
10/19/06 16:13:17 Language&nbs p; = ENGLISH
10/19/06 16:13:18 SQL*Net service name = INTRALINK
10/19/06 16:13:18 File server host = mech1
10/19/06 16:13:19 File server port = 7777
10/19/06 16:13:19 File server path = d:\ptc\filevault
10/19/06 16:13:20
###########################################################
10/19/06 16:13:20 Variable OraHomePath is set to "d:/oracle/ora92"
10/19/06 16:13:21
Checking installed Oracle Software
10/19/06 16:13:21 Oracle Software installation is verified.10/19/06 16:13:22 Proceeding to the next step.
10/19/06 16:13:22
Starting ORACLE database installation:
10/19/06 16:13:24 Redo Log Group number 1 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_redolog_g01_m01.dbf)
10/19/06 16:13:25 Redo Log Group number 2 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_redolog_g02_m01.dbf)
10/19/06 16:13:25 Redo Log Group number 3 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_redolog_g03_m01.dbf)
10/19/06 16:13:25 Control File number 1 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_controlfile_01.ctl)
10/19/06 16:13:26 Control File number 2 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_controlfile_02.ctl)
10/19/06 16:13:26 Control File number 3 added (file: d:/ptc/dataserver/intralink/dbs/ilnk_controlfile_03.ctl)
10/19/06 16:13:27 Template Tablespace registered: NAME SYSTEM
10/19/06 16:13:27 Data file added to template: FULL_NAME d:/ptc/dataserver/intralink/dbs/system_01.dbf SIZE 275 TS SYSTEM
10/19/06 16:13:28 Template Tablespace registered: NAME TEMP
10/19/06 16:13:29 Data file added to template: FULL_NAME d:/ptc/dataserver/intralink/dbs/temp_01.dbf SIZE 100 TS TEMP
10/19/06 16:13:30 Template Tablespace registered: NAME UNDOTBS1
10/19/06 16:13:31 Data file added to template: FULL_NAME d:/ptc/dataserver/intralink/dbs/undotbs1_01.dbf SIZE 200 TS UNDOTBS1
10/19/06 16:13:32 Tablespace registered: NAME SYSTEM
10/19/06 16:13:32 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_system_01.dbf SIZE 300 TS SYSTEM
10/19/06 16:13:33 Tablespace registered: NAME TEMP
10/19/06 16:13:34 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_temp_01.dbf SIZE 400 TS TEMP
10/19/06 16:13:34 Tablespace registered: NAME UNDOTBS1
10/19/06 16:13:36 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_undotbs1_01.dbf SIZE 400 TS UNDOTBS1
10/19/06 16:13:36 Tablespace registered: NAME DEVELOPMENT
10/19/06 16:13:37 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_development_1.dbf SIZE 50 TS DEVELOPMENT
10/19/06 16:13:38 Tablespace registered: NAME PDM_INDEX
10/19/06 16:13:39 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_pdm_index_1.dbf SIZE 800 TS PDM_INDEX
10/19/06 16:13:39 Tablespace registered: NAME PDM_TABLE
10/19/06 16:13:40 Data file added: FULL_NAME d:/ptc/dataserver/intralink/dbs/ilnk_pdm_table_1.dbf SIZE 500 TS PDM_TABLE
10/19/06 16:13:42 Configuring Net Service Name "INTRALINK" ... 10/19/06 16:13:43 Running NETCA with parameters:
10/19/06 16:13:45 /silent /responseFile d:\Temp/ilnk_netca.rsp
10/19/06 16:14:02 errorCode=NONE
10/19/06 16:14:03 OK
10/19/06 16:14:04 Generating file location variable file ... 10/19/06 16:14:05
Contents of dbca variable file:
10/19/06 16:14:06 CTRLFILE_1_FILE=ilnk_controlfile_01.ctl
10/19/06 16:14:07 CTRLFILE_1_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:08 CTRLFILE_2_FILE=ilnk_controlfile_02.ctl
10/19/06 16:14:10 CTRLFILE_2_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:11 CTRLFILE_3_FILE=ilnk_controlfile_03.ctl
10/19/06 16:14:11 CTRLFILE_3_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:12 DATA_SYSTEM_FILE=ilnk_system_01.dbf
10/19/06 16:14:13 DATA_SYSTEM_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:14 DATA_TEMP_FILE=ilnk_temp_01.dbf
10/19/06 16:14:15 DATA_TEMP_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:16 DATA_UNDOTBS1_FILE=ilnk_undotbs1_01.dbf
10/19/06 16:14:17 DATA_UNDOTBS1_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:18 ORACLE_ADMIN=d:\\oracle\\ora92\\admin
10/19/06 16:14:19 ORACLE_SCRIPT=d:\\ptc\\dataserver\\intralink\\dbs\\create_db \\ilnk_PostCreate.sql
10/19/06 16:14:20 PATH_SEP=\\
10/19/06 16:14:21 REDOLOG_1_FILE=ilnk_redolog_g01_m01.dbf
10/19/06 16:14:22 REDOLOG_1_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:22 REDOLOG_2_FILE=ilnk_redolog_g02_m01.dbf
10/19/06 16:14:23 REDOLOG_2_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:23 REDOLOG_3_FILE=ilnk_redolog_g03_m01.dbf
10/19/06 16:14:24 REDOLOG_3_FOLDER=d:\\ptc\\dataserver\\intralink\\dbs\\
10/19/06 16:14:25 OK
10/19/06 16:14:25 Generating post creation SQL script ... 10/19/06 16:14:26 OK
10/19/06 16:14:27 Running Oracle Data Base Configuration Assistant (DBCA) ... 10/19/06 16:14:27
=============================================
10/19/06 16:14:28 Varaiables of namespace ":
10/19/06 16:14:29 :
10/19/06 16:14:30 :
10/19/06 16:14:31 :
10/19/06 16:14:32 :
10/19/06 16:14:33 :
10/19/06 16:14:33 :
10/19/06 16:14:34 :
10/19/06 16:14:36 :
10/19/06 16:14:37
Arrays of namespace ":
10/19/06 16:14:39
Array ":
10/19/06 16:14:40 :
10/19/06 16:14:41 :
10/19/06 16:14:43 :
10/19/06 16:14:44 :
10/19/06 16:14:45 :
10/19/06 16:14:46 :
10/19/06 16:14:47 :
10/19/06 16:14:48 :
10/19/06 16:14:49 :
10/19/06 16:14:50 :
10/19/06 16:14:51 :
10/19/06 16:14:52 :
10/19/06 16:14:53 :
10/19/06 16:14:53 :
10/19/06 16:14:55 :
10/19/06 16:14:56 :
10/19/06 16:14:57 :
10/19/06 16:14:57 :
10/19/06 16:14:58 :
10/19/06 16:14:59 :
10/19/06 16:15:00 :
10/19/06 16:15:01 :
10/19/06 16:15:02 :
10/19/06 16:15:03 :
10/19/06 16:15:04 :
10/19/06 16:15:04 :
10/19/06 16:15:06 :
10/19/06 16:15:06 :
10/19/06 16:15:07 :
10/19/06 16:15:08 :
10/19/06 16:15:08 :
10/19/06 16:15:09 :
10/19/06 16:15:09 :
10/19/06 16:15:10 :
10/19/06 16:15:11 :
10/19/06 16:15:11 :
10/19/06 16:15:12 :
10/19/06 16:15:13 :
10/19/06 16:15:13 :
10/19/06 16:15:14 :
10/19/06 16:15:15 :
10/19/06 16:15:15 =============================================
10/19/06 16:15:16 ORACLE_SID = ilnk
10/19/06 16:15:17 Global DB Name = ilnk
10/19/06 16:15:18 CharSset = UTF8
10/19/06 16:15:18 National CharSet = UTF8
10/19/06 16:15:19 DBCA mode = -silent
10/19/06 16:15:21 ShowPwdWindow = false
10/19/06 16:15:21
Running dbca command:
10/19/06 16:15:23 exec d:/oracle/ora92/bin/dbca.bat -silent -passwordDialog false -createDatabase -templateName UTF8_DBDataTempl.dbc -datafileJarLocation d:/ptc/dataserver/intralink/dbs/Tcl/proidbcahelper1.0/templa tes/windows/UTF8_DBDataTempl.dfj -sid ilnk -gdbname ilnk -characterSet UTF8 -nationalCharacterSet UTF8 -variablesFile {d:\ptc\dataserver\intralink\dbs\create_db\ilnk_dbca_vars.tx t}
10/19/06 16:15:38 errorCode=NONE
10/19/06 16:15:39 DBCA error message was:
10/19/06 16:15:40 =======
10/19/06 16:15:41 invalid command name "Look at the log file "D:\oracle\ora92\assistants\dbca\logs\ilnk5.log" for further details."
10/19/06 16:15:42 =======
10/19/06 16:15:44 Trying to find out name of log file 10/19/06 16:15:45 (if it was in the message):
10/19/06 16:15:46 Can not identify the log file.
10/19/06 16:15:48 OK
10/19/06 16:15:49 Synchronizing Database File Names ... 10/19/06 16:16:33 Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
10/19/06 16:16:34 Performing file type check up. Issuing command:
set feedback off
set head off
set pages 0
select case
when
upper('d:\ptc\dataserver\intralink\dbs\system_01.dbf') in (select upper(name) from v$tempfile)
then
upper('temp')
else
upper('data_undo') end Type
from dual;
exit 0
10/19/06 16:16:53 File d:\ptc\dataserver\intralink\dbs\system_01.dbf appears to be of type: DATA_UNDO
10/19/06 16:16:53 Renaming file d:\ptc\dataserver\intralink\dbs\system_01.dbf to d:\ptc\dataserver\intralink\dbs\ilnk_system_01.dbf
10/19/06 16:16:54 File has been renamed successfully.
10/19/06 16:16:55 Performing file type check up. Issuing command:
set feedback off
set head off
set pages 0
select case
when
upper('d:\ptc\dataserver\intralink\dbs\temp_01.dbf') in (select upper(name) from v$tempfile)
then
upper('temp')
else
upper('data_undo') end Type
from dual;
exit 0
10/19/06 16:17:11 File d:\ptc\dataserver\intralink\dbs\temp_01.dbf appears to be of type: DATA_UNDO
10/19/06 16:17:12 Renaming file d:\ptc\dataserver\intralink\dbs\temp_01.dbf to d:\ptc\dataserver\intralink\dbs\ilnk_temp_01.dbf
10/19/06 16:17:13 File has been renamed successfully.
10/19/06 16:17:14 Performing file type check up. Issuing command:
set feedback off
set head off
set pages 0
select case
when
upper('d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf') in (select upper(name) from v$tempfile)
then
upper('temp')
else
upper('data_undo') end Type
from dual;
exit 0
10/19/06 16:17:31 File d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf appears to be of type: DATA_UNDO
10/19/06 16:17:32 Renaming file d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf to d:\ptc\dataserver\intralink\dbs\ilnk_undotbs1_01.dbf
10/19/06 16:17:34 File has been renamed successfully.
10/19/06 16:18:31
Database altered.
10/19/06 16:18:32 Performing tempfile type check up. Issuing command:
set feedback off
set head off
set pages 0
select bytes/1024/1024||'M' from v$tempfile
where name='d:\ptc\dataserver\intralink\dbs\system_01.dbf'
or name=upper('d:\ptc\dataserver\intralink\dbs\system_01.dbf');
exit 0
10/19/06 16:18:51 Performing tempfile type check up. Issuing command:
set feedback off
set head off
set pages 0
select bytes/1024/1024||'M' from v$tempfile
where name='d:\ptc\dataserver\intralink\dbs\temp_01.dbf'
or name=upper('d:\ptc\dataserver\intralink\dbs\temp_01.dbf');
exit 0
10/19/06 16:19:10 Performing tempfile type check up. Issuing command:
set feedback off
set head off
set pages 0
select bytes/1024/1024||'M' from v$tempfile
where name='d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf'
or name=upper('d:\ptc\dataserver\intralink\dbs\undotbs1_01.dbf' );
exit 0
10/19/06 16:19:27 OK
10/19/06 16:19:28 Initializing package for database SID = ilnk
10/19/06 16:19:29 Starting database ilnk
10/19/06 16:19:30 Retrieving status for database ilnk
10/19/06 16:19:30 Retrieving status of Oracle Service OracleServiceILNK
10/19/06 16:19:46 Instance is running and database is open
10/19/06 16:19:47 Changing password for user SYSTEM ... 10/19/06 16:20:09
Error during changing SYSTEM's password:
List of error messages:
ORA-00959: tablespace 'PDM_TABLE' does not exist
ORA-06512: at line 94
Errors description:
ptc_oerr: data for ORA-00959: was not found.
ptc_oerr: data for ORA-06512: was not found.
------------------------------------------------------------ -----------------
The installation terminates with these errors.
It seems like it cannot change user system password & fails to create PDM_table.
Any solutions? Whats wrong? Is patchset files right?
Please help!!!!!!!!!!!!!!!!!!!!!!!!!!!1
I cannot pass by this error. Very frustrating. Tried asking PTC support, but no help avilable since our AMC had expired couple years ago.
Thanks.