cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

How to install PDMLink with Oracle on AWS-RDS?

shin1h
13-Aquamarine

How to install PDMLink with Oracle on AWS-RDS?

Dear all,

 

Thank you for your cooperation in advance.

We want to install PDMLink with EC2(app server) and Oracle on AWS-RDS.
But we don't know what values should we input on 'ORACLE_HOME install directory' and 'DNS host name'.

We tried sometime, but PSI showed error messages.
How should we proceed to install?
Please give us some advise.

1 ACCEPTED SOLUTION

Accepted Solutions
shin1h
13-Aquamarine
(To:jdiianni)

HI jdiianni,

We installed windchill with following steps, and windchill is working well without problem.
I hope this is helpful for you.

 

1.Create tablespace on RDS
refer to below article.
https://www.ptc.com/en/support/article?n=CS28194
In case of RDS we cannot use path of datafile, so execute following SQL.


CREATE TABLESPACE "BLOBS"
DATAFILE
SIZE 1G
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE "INDX"
DATAFILE
SIZE 1G AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE "WCAUDIT"
DATAFILE SIZE 1G
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

 

2. Create user for windchill.
create user <USER> identified by <PASSWORD> default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
grant connect, resource, create sequence, create view, query rewrite, unlimited tablespace, select any dictionary to <USER>;

 

3. Install windchill by PSI.
Install windchill by PSI without creating database schema option.

 

4. CREATE_DDL
Execute DDL SQL by user for windchill(created in step 2) with SQLPLLUS.
DDL SQL = $WT_HOME/db/sql3/create_ddl_wt.sql

 

5. import basedata of windchill
Execute import basedata with following windchill command with windchill shell.
windchill wt.load.WindchillLoader -All -Unattended

When windchill and database is installed separetely, need to check amount of attribute columns.
https://www.ptc.com/en/support/article?n=CS55464

 

View solution in original post

3 REPLIES 3

Did you ever get an answer to this or nail down how to get past this step?

 

Thanks!

shin1h
13-Aquamarine
(To:jdiianni)

HI jdiianni,

We installed windchill with following steps, and windchill is working well without problem.
I hope this is helpful for you.

 

1.Create tablespace on RDS
refer to below article.
https://www.ptc.com/en/support/article?n=CS28194
In case of RDS we cannot use path of datafile, so execute following SQL.


CREATE TABLESPACE "BLOBS"
DATAFILE
SIZE 1G
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE "INDX"
DATAFILE
SIZE 1G AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE "WCAUDIT"
DATAFILE SIZE 1G
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

 

2. Create user for windchill.
create user <USER> identified by <PASSWORD> default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
grant connect, resource, create sequence, create view, query rewrite, unlimited tablespace, select any dictionary to <USER>;

 

3. Install windchill by PSI.
Install windchill by PSI without creating database schema option.

 

4. CREATE_DDL
Execute DDL SQL by user for windchill(created in step 2) with SQLPLLUS.
DDL SQL = $WT_HOME/db/sql3/create_ddl_wt.sql

 

5. import basedata of windchill
Execute import basedata with following windchill command with windchill shell.
windchill wt.load.WindchillLoader -All -Unattended

When windchill and database is installed separetely, need to check amount of attribute columns.
https://www.ptc.com/en/support/article?n=CS55464

 

BryanK
14-Alexandrite
(To:shin1h)

Hi,

 

Thanks for this article, we have followed it but are still running into issues. 

once running the script it fails with the following error. 

 


BEGIN WTPK.createSequence('bacPackageNumber_seq',1,1); END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "WINCHILL.WTPK", line 31
ORA-06512: at line 1

 

and at the end of the file it says.

 

*
ERROR at line 1:
ORA-20100: Schema "WINCHILL" has 5 invalid objects.
ORA-06512: at line 14

 

 

It seems that we have missed something.

 

Do you have any suggestions?

 

Thanks in advance.

Bryan

Top Tags