Teamcenter 12.2 两层客户端安装图文教程MS SQL数据库

admin · 发表于 2019-12-4 13:57:58

请使用QQ关联注册PLM之家，学习更多关于内容，更多精彩原创视频供你学习！

您需要登录才可以下载或查看，没有账号？注册

x

Teamcenter 12.2 两层客户端安装图文教程MS SQL数据库
需要下载和安装的软件版本要求如下，具体的可以参考西门子的要求。

图文教程，

（1）下载后的安装包文件如下：

Screen Shot 2019-12-14 at 15.27.09.png

这里主要是TC的安装包，Java去下载最新的，1.8.20以后的都可以支持，另外就是license server下载最新的

（2）Java安装，数据库安装
Java安装很简单，这里不啰嗦，数据库这里使用的是mssql 2016，安装过程官方的具体说明如下：
已经非常详细了，这里截图关键步骤，主要是数据库的名称不要和原始的重复，修改下，混合模式，添加本地管理员

Screen Shot 2019-12-13 at 21.52.14.png

Log on to an account with system administrator privileges.
Launch the Microsoft SQL Server Installation Center application (setup.exe).
In the SQL Server Installation Center dialog box, click Installation in the navigation pane on the left side.
Click New SQL Server stand-alone installation or add features to an existing installation.
The SQL Server Installation Center launches the SQL Server Setup wizard.
Proceed throUGh the pre-installation tests and other initial setup panes to the Install Setup Files pane. Click Install to install SQL Server setup support files.
After setup support files are installed, the wizard displays the Install Rules pane. Click Next.
In the Feature Selection pane, select Instance Features→Database Engine Services and any other features you want to include.
Click Next.

In the Instance Configuration pane, select an instance type. Teamcenter supports both Default Instance and Named Instance.[url=]NOTE[/url]

Note

A default instance in a Microsoft SQL Server installation uses the name MSSQLSERVER. Teamcenter's persistent object manager (POM) utilities cannot connect to an instance with this name. If you use a default instance, make sure you connect to the instance using a port connection rather than the name.

If you use a named instance, make sure the instance has a unique name other than MSSQLSERVER.

Enter remaining instance configuration values, and then click Next,
Proceed to the Server Configuration pane.

1 V, ^& t) m, y$ [; p ^) q
- Click the Service Accounts tab.
- Enter account information for starting SQL Server services.
  Note
  The SQL Server Setup wizard validates user accounts for SQL Server services. Make sure the accounts you enter exist on the host.
- Click the Collation tab.
- On the Collation tab, click Customize.
  The wizard displays a customization dialog box for database engine collation.
- Select Windows Collation designator and sort order.
- In the Collation designator box, select Latin1_General and then select Binary.
- Click OK.
- In the Server Configuration pane, click Next.
  
  1 c1 j' l$ C2 E p1 C
Proceed to the Database Engine Configuration pane.
3 t) B+ Z& c! I+ j4 e. U) d9 j
- Click the Server Configuration tab.
- Under Authentication Mode, select Mixed Mode and define a password for the SQL Server sa logon account.
- Specify at least one SQL Server administrator account.
- Click Next.
  2 i8 K: a8 ^6 }! z" ?0 I
Proceed to the Ready to Install pane and click Install to install.

; [4 z c, Y2 U( [' B. @3 R% H

Teamcenter requires TCP/IP protocol to be enabled, but this protocol is disabled by default when you install Microsoft SQL Server. Before you install Teamcenter, make sure you enable TCP/IP protocol.

For more information about enabling TCP/IP protocol in Microsoft SQL Server, see the Microsoft online help resources on the Internet.

（3）License 安装
配置好license，一步步安装完成即可，license会自动启动，注意计算机名不要有特殊的符号
Screen Shot 2019-12-13 at 21.27.10.png

（4）数据库模版修改和创建

这里还是仿照官方的说明，非常详细，修改相关配置信息，创建数据库实例。

这里自己下载个MSSM，然后执行下修改后的sql

Screen Shot 2019-12-14 at 09.19.56.png

Make sure you have access to the Teamcenter software kit.
Launch Microsoft SQL Server Management Studio:
Start→Programs→Microsoft SQL Server→SQL Server Management Studio
6 W. a. \) a& |1 L

Alternatively, search the start menu for SQL Server Management Studio.
In the SQL Connect to Server dialog box, log on using the system administrator (sa) logon name and password.
Choose File→Open→File or press Control+O.
Browse to the tc\db_scripts\mssql directory in the Teamcenter 12 software kit.
Select the create_database.sql.template file and click Open.
If SQL Server Management Studio prompts you to log on, enter the system administrator (sa) logon name and password.

Edit the database template (create_database.sql.template) to replace the necessary values.

The following table describes the database parameters to replace in the template. Within the template file, there are also comments on values that must be replaced.

[td]

Parameter	Example value	Description
@DB_NAME@	TC	Name of the database to create.
@DATA_PATH@	D:\MSSQL_DATA	Path to the directory in which to place the data file.
@USER_NAME@	infodba	Database logon name for the Teamcenter database.
@PASSWORD@	infodba	Password for the database logon name.
@COLLATION@	Latin1_General_BIN	Collation sequence you want the Teamcenter database to use. Choose the appropriate collation for your locale. The collation value must end with _BIN.[url=]NOTE[/url]. Collation defines the alphabet or language whose rules are applied when data is sorted or compared. The collation value determines the character set used by the database server.
@LANGUAGE@	us_english	Database language.

Save the newly modified file as filename.sql, removing the _template extension.
Open the new file in Microsoft SQL Server Management Studio.
In the SQL Editor toolbar, click Execute (or choose Query→Execute to begin creating the database.
When creation of the MS SQL database instance is complete, verify the newly created database. In the Object Explorer pane, under the MS SQL Server host name, expand the Databases tree. Verify the new database name is included in the list of databases.

, F t" C0 U# f

（5）Teamcenter 两层安装
到了软件安装过程了，确保连个压缩包都解压，集中放在第一个里面。
注意jre64_home的环境变量设置正确，我个人通常就是启动cmd命令，直接set下即可，确保tem.bat 界面启动，简单起见，我们这里将 corporate server，volume server，相关服务装在这一台机器上，一次性安装完毕两层。

Screen Shot 2019-12-14 at 10.07.39.png