Hi David,
You will have to create 3 table spaces manually BLOBS, INDX and WCAUDIT on
the DB server, drop the existing user and then then execute the create_user
SQL script which will crate the new user (same as the previous deleted
one)to give the Windchill DB user enough permissions on the TEMP and USERS
table spaces.
*Regards**,*
*Rohan Kalbhor*
*Delivery Module Lead - PLM Practice*
*MhpasiS an HP company
*
*Mobile : +91 9011759898 *
*** rohan.kalbhor@eds.com | -*
*3B076, Tower 4, Cybercity | Magarpatta City | Pune | India 411013*
On Wed, Jan 5, 2011 at 9:11 PM, Patrick S Williams <
-> wrote:
> All,
> I am installing PDMLink 9.1 M040 on an HPUX 11iV2 server with Oracle
> 10.2.0.4.0 on another server that is managed by our dba group. They created
> a database and user for me to use. There is a default and temp tablespace
> created. The dba group will not allow the PSI to run on the Oracle server
> so I have to choose "Configure to an existing user on an existing database"
> in the PSI. Well the installation was going great (for 4 hours) when it got
> to the database schema creation part where it failed. There were errors
> about tablespaces that didn't exist and insufficient privileges. My
> question is, should I have the dba create some tablespaces that the PSI is
> expecting? What is the proper way to accomplish this type of installation
> where the PSI is not allowed to run on the database server? Here are some
> of the errors from the PTCSOLNINSTALLER_PtcInstall.log:
>
> 1/4/11 4:37:38 PM: DDL Manager - configure DDL for Oracle
> 1/4/11 4:37:38 PM: ************ Found Schema to Load ************
> 1/4/11 4:37:38 PM: **** Running: su ptcadmin -c
> /opt/ptc/Windchill_9.1/Windchill/bin/windchill
> --java=/opt/ptc/Windchill_9.1/Java/bin/java
> "--javaargs=-Dwt.tools.sql.warningOutputFileName=STDERR
> -Dwt.tools.sql.errorOutputFileName=STDERR" wt.tools.sql.SQLCommandTool
> create_ddl_wt.sql /opt/ptc/Windchill_9.1/Windchill/db/sql
> errors:2871
> warnings:11
> 1/4/11 4:39:36 PM: Installation is Aborting.
> 1/4/11 4:39:36 PM: The following log contains information that may be
> useful for diagnosing installation problems.
> 1/4/11 4:39:36 PM: Please include it in your support requests.
> 1/4/11 4:39:36 PM:
> /opt/ptc/Windchill_9.1/Windchill/installer/logs/WindchillDDL.log
> Installation is Aborting.
> The following log contains information that may be useful for diagnosing
> installation problems.
> Please include it in your support requests.
> /opt/ptc/Windchill_9.1/Windchill/installer/logs/WindchillDDL.log
> 1/4/11 4:41:13 PM: Aborting installation.
> 1/4/11 4:41:13 PM:
> 1/4/11 4:41:13 PM:
> 1/4/11 4:41:13 PM: -- Reason --
> 1/4/11 4:41:13 PM: Installation is Aborting.
> 1/4/11 4:41:13 PM: The following log contains information that may be
> useful for diagnosing installation problems.
> 1/4/11 4:41:13 PM: Please include it in your support requests.
> 1/4/11 4:41:13 PM:
> /opt/ptc/Windchill_9.1/Windchill/installer/logs/WindchillDDL.log
> 1/4/11 4:41:13 PM:
> 1/4/11 4:41:13 PM:
> 1/4/11 4:41:13 PM: -- Details --
> 1/4/11 4:41:13 PM: Problems running schema load.
> 1/4/11 4:41:13 PM: --- Summary of WindchillDDL.log ---
> 1/4/11 4:41:13 PM: - Exceptions -
> 1/4/11 4:41:13 PM: /* QA observed error: java.sql.SQLException: ORA-00902:
> invalid datatype */
> 1/4/11 4:41:13 PM:
> 1/4/11 4:41:13 PM:
> 1/4/11 4:41:13 PM: - Messages -
> 1/4/11 4:41:13 PM: SQL ERROR in 'create_versioning_tables':
> message=ORA-00959: tablespace 'INDX' does not exist
> 1/4/11 4:41:13 PM: SQL ERROR in 'create_versioning_tables':
> message=ORA-00942: table or view does not exist
> 1/4/11 4:41:13 PM: SQL ERROR in
> 'pdml/DDLBasic/com/ptc/wpcfg/doc/rule/create_variantspecid_seq_Sequence.sql':
> message=ORA-01031: insufficient privileges
> 1/4/11 4:41:13 PM: SQL ERROR in
> 'wnc/WorkPackage/com/ptc/windchill/wp/baseline/create_WPBaselineSequence_Sequence.sql':
> message=ORA-01031: insufficient privileges
>
> *PATRICK S WILLIAMS*
> Information Technology
> Mechanical Engr Solutions
> Missile Systems*
> Raytheon Company*
>
> +1 520.545.6995 (office)
> +1 520.446.0244 (pager)
> +1 520.545.6399 (fax)*
> -* <->
>
> 6221 S Palo Verde Rd
> Tucson, AZ 85706-5093 USA*
> **
www.raytheon.com* [image: YouTube]<
">http://www.youtube.com/user/raytheoncompany>> [image: Facebook] <
">http://www.facebook.com/Raytheon> [image: LinkedIn]<
">http://www.linkedin.com/companies/raytheon>> [image: Dual Band podcasts] <
">http://www.raytheon.com/newsroom/podcasts>>
> [image: Raytheon Sustainability]
> *
> This message contains information that may be confidential and privileged.
> Unless you are the addressee (or authorized to receive mail for the
> addressee), you should not use, copy or disclose to anyone this message or
> any information contained in this message. If you have received this message
> in error, please so advise the sender by reply e-mail and delete this
> message. Thank you for your cooperation.*