Skip to main content
A
aarasan-21-Visitor
1-Visitor
April 21, 2016
Solved

Windchill 10.2 M030 PSI aborts during Creating Oracle Configuration with Oracle 12c

  • April 21, 2016
  • 8 replies
  • 5785 views

Hi,

I'm trying to install Windchill 10.2 M030 using the PSI, configured to created the Database schema in an existing Oracle 12c R2 SE2 database software only installation instance.

I had keyed in correct values of the Oracle 12c Home user password as well during the configuration steps in PSI for installation. But the PSI aborts the Installation pre maturedly during the step of Creating Oracle configurations and the installation fails. The OCU logs that the installation failure message prompting to isn't clear to trouble shoot.

Had some one faced any similar issue? Below is the snapshot of the error screen when the PSI aborts. Attaching the logs pointed in the error screen as well.

Appreciate any help that would assist me overcoming this issue. Thanks in advance!

Error_1.jpg

Best answer by aarasan-2

Thanks for all your responses. I actually found the issue cause to be the Windows service user that is being created during Oracle 12c instllation. For some unknown reasons, the user that is being created as a part of the installation which is being used as the service account didn't get assigned to the DBA groups in the machine's local group. I tried creating a different user using the installer again and the user automatically got assigned to the DBA groups and voila the PSI completed the installation.

In a nut shell, 12c is something not correct and it is bugging unlike how it used to be a cake walk earlier..

8 replies

A
Anonymous
April 21, 2016

Hi It seems the error is related to oracle related issue. Does your oracle exists at some location? please check oracle related files existing in your machine .

B
bmills1-Visitor
1-Visitor
April 21, 2016

Arasan,

I have run into this issue. It's not a major issue, just a problem with the PSI seeing something that it thinks was a failure in installation. I've checked the logs and never found any issues that should about the install. This only happens during the initial run of the PSI for the Oracle install.

The answer I found was quite simple, just click OK to the error, then restart the PSI and run through all of the screens again, the installation will finish without any errors and complete the Oracle installation.

Bob

B
BineshKumar12-Explorer
2-Explorer
April 21, 2016

Reading the logs PSI failed in running DBCA to create database.

D:\app\Oracle12c\USBAL-Oraadmin\product\12.1.0\dbhome_1\bin\dbca -silent -createDatabase -templateName demo_template.dbt -gdbName wind -sid wind -datafileDestination D:\ptc\Windchill_10.2\ocu\oradata -characterSet AL32UTF8 -nationalCharacterSet UTF8 -listeners LISTENER -systemPassword manager -sysPassword change_on_install -serviceUserPassword zb%dUeA3Sy5@XKsg

I think additional information will be there in the log - D:\app\Oracle12c\USBAL-Oraadmin\cfgtoollogs\dbca\wind\wind.log

You can try running the above command and see whether it works. If it works, the next time you run PSI select option to connect to existing database,

Thank you

Binesh Kumar

A
aarasan-21-VisitorAuthor
1-Visitor
April 25, 2016

Binesh,

I tried running the command and stumped upon with the below warning

D:\app\Oracle12c\USBAL-Oraadmin\product\12.1.0\dbhome_1\BIN>dbca -silent -createDatabase -templateName demo_template.dbt -gdbName wind -sid wind -data

fileDestination D:\ptc\Windchill_10.2\ocu\oradata -characterSet AL32UTF8 -nationalCharacterSet UTF8 -listeners LISTENER -systemPassword manager -sysPa

ssword change_on_install -serviceUserPassword zb%dUeA3Sy5@XKsg

Template demo_template.dbt does not exist. Please specify an existing template for database creation.

D:\app\Oracle12c\USBAL-Oraadmin\product\12.1.0\dbhome_1\BIN>

B
BineshKumar12-Explorer
2-Explorer
April 25, 2016

Do you have access to Windchill installation folder,  the template is in <Windchill Install Location>\ocu\db_util\create_db\templates

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS36056

A
aarasan-21-VisitorAuthorAnswer
1-Visitor
April 28, 2016

Thanks for all your responses. I actually found the issue cause to be the Windows service user that is being created during Oracle 12c instllation. For some unknown reasons, the user that is being created as a part of the installation which is being used as the service account didn't get assigned to the DBA groups in the machine's local group. I tried creating a different user using the installer again and the user automatically got assigned to the DBA groups and voila the PSI completed the installation.

In a nut shell, 12c is something not correct and it is bugging unlike how it used to be a cake walk earlier..

    N
    NickD10-Marble
    10-Marble
    November 5, 2017

    I ran into the same error messages during testing of 10.2 M030 and Oracle 11c, when running the PSI on an existing Oracle server to create a new database and database user, after I had dropped the existing user and deleted the instance.  I thought that would give the PSI/OCU a nice clean run at it, but whilst it did make the database "wind" it did not made the user "pdmlink".

     

    Previously, the only error-free solution I could find was to completely remove Oracle (drop user, delete instance de-install, unregister in Windows, etc, etc....), reinstall Oracle 11.2.0.4 and then run the PSI /OCU before loading any Oracle updates or patches !

     

    So this time (during testing v11.0 M030 CPS03) I tried to find a better way.  Looking at the OCU_PtcInstall.log mentioned in the error message wasn't much help, but it mentioned another log file  C:\oracle\cfgtoollogs\dbca\wind\wind0.log, and at the end of that file it shows it did get 100% of the way through DBCA_PROGRESS, ending with the message 'Database creation complete', but inbetween 76% and 77% progress it listed an error: ORA-01435: user does not exist.

     

    Sure enough, checking in the file system and with SQLplus commands, the database files were created but the user "pdmlink" wasn't.  Looking at some other successful installations, it appears the PSI/OCU simply fails to make or run a suitable copy of the sql script "createSchema.sql", so having seen what little that script is meant to do, I just used another copy of the equivalent (and more familiar) sql script called "create_user.sql" that was already prep-populated to work, and this did made the user "pdmlink".

     

    The acid test is to run the PSI on the Windchill (Web Apps) server, and see if it is happy to connect to the Database server using the new instance and user (yes it is..), and load the base data - and at the time of writing this note the PSI is part way through... so I'll have to come back and update this message !

     

    UPDATE: yes, the PSI did run to completion !!

    So, the PSI has a bug that either prevents it from making the .sql files it needs, or prevents it from running them.  If it fails on any of the steps, you have to do them manually, ie. create empty database/instance (wind), create empty user (pdmlink), create schema (effectively the same as the user but not empty...), load base data.

    See CS229941, CS22893, CS36056, CS28194, etc for various clues and seach in PTC Knowledgebase again...

    Terms & ConditionsAccessibility statement