Configure oracle software

 https://tccustomization.blogspot.com/

Configure oracle software

Configure oracle net

1. Teamcenter uses Oracle Net protocols to communicate with an Oracle database.
2. These protocols require that you run a listener process (OracleTNSListener) on the Oracle server to listen for remote connect requests and that all clients can translate the service alias identifying the server and database.

Configure oracle listener

1. Start oracle net manager.
2. Start→All Programs→Oracle -instance-name→Configuration and Migration Tools→Net Manager.
3. Or search for Net Manager.

Create a listener.ora file

• Expand Local icon.
• select Listener folder and choose Edit→Create.
• Accept the default listener name (LISTENER) and click OK.
• Click the Add Address button.
• Specify the port number.
• In the Local tree, click Profile.
• In the Naming list (to the right of the Oracle Net Configuration tree), choose General.
• Click the Advanced tab.
• In the TNS Time Out Value box, type 10.
• Save the listener information, choose File→Save Network Configuration.

Oracle Net Manager saves the listener information and creates the network\admin\listener.ora and network\admin\sqlnet.ora files in the Oracle home directory.

Exit Oracle Net Manager, choose File→Exit.

In a command prompt, create and start the listener service:

cd ORACLE_HOME\bin lsnrctl start LISTENER

Replace ORACLE_HOME with the path to the directory where you installed the Oracle server, for example, d:\app\infodba\product\12.1.0\dbhome_1. This command creates and starts the service if it does not exist. If the service exists, the command starts it.

Do you Know :

⏩For the first listener, Siemens PLM Software recommends accepting the default port number (1521).

⏩Record the number of the port used by the Oracle database server listener for an entry during corporate server installation. Teamcenter Environment Manager requires this port number.

⏩This step sets the Oracle server-side SQLNET.EXPIRE_TIME parameter. This value determines how often the Oracle server checks for aborted client connections. Teamcenter requires that this parameter be set to a nonzero value and the recommended value is 10 (10 minutes).

Read More

Upgrade an oracle server and database

https://tccustomization.blogspot.com/

Upgrade an oracle server and database

• Log on to the oracle server with an administrator account.
• Export the contents of your Teamcenter Oracle database to the dump file using the following command in SQL plus.

ORACLE_HOME\bin\expdp db-user/password full=y dumpfile=file-name.dmp logfile=export.log

replace db-user = teamcenter database usernae e.g: infodba

replace password = teamcenter database password e.g.infodba 

• Store a dump file.
• If you have multiple databases repeated a process for each database.

Terminate oracle session

• Log in on the operating system as the user having the administrative privilege.
• an open Service dialog box in the windows control panel.
• Select the Oracle TNS listener services (Oraclerelease-IDTNSListener) and click Stop.

shutdown oracle database

Using the window control panel

• Log in on the operating system as the user having the administrative privilege.
• Open the Services dialog box in the Windows Control Panel
• Select the OracleServiceSID service Replace SID with the system identifier of the database instance.
• Click stop.

Using SQL*plus

• Log in on the operating system as the user having the administrative privilege.
• start a SQL utility.
• replace password with a password for sys account.
• Oracle starts the Oracle SQL*Plus utility

sqlplus sys/password@Oracle—SID as sysdba

• Shut down the database instance by typing the following command.
• shutdown
• Exit SQL*Plus:
• exit

Backup of oracle installation

1. Before upgrading a new version of oracle backup an existing version of the oracle.
2. Back up the following :
1. The Oracle home directory on each installed workstation.
2. The directories containing database files for each configured database.
3. The Oracle Net listener.ora and tnsnames.ora configuration files.

Upgrading oracle :

there are two ways to upgrade the oracle server and database:

1. Oracle installer.
2. Uninstalling/reinstalling Oracle.

Using oracle installer :

1. Launch oracle installer.
2. When the Oracle installer prompts you to upgrade existing databases, enter the required information about the databases you want to upgrade.

Using  uninstalling and reinstalling

1. Remove existing Oracle databases.
2. Uninstall all existing Oracle server software.
3. Install oracle server then Configure oracle and create an Oracle database.
4. After completing the installation, import your Teamcenter database from the oracle dump file into a new oracle database.

ORACLE_HOME\bin\imp db-user/password fromuser=db-user touser=db-user file=file-name.dmp log=import.log

 

replace a user and password with your system administrator password.

Do you Know :

The sys user must be in the Oracle sysdba group for the Oracle system identifier (SID) used by Teamcenter. To connect as internal (without a password), the account must be part of the ORA_DBA local group in Windows.

Read More

Oracle installation For Teamcenter

Oracle Installation 

Teamcenter requires a supported RDBMS for string a Teamcenter data.

Before installing a Teamcenter we must have to install one of the supported database.

• Oracle
• Microsoft SQL Server

Teamcenter's high resource demands, Siemens PLM Software recommends a dedicated database server.

we should provide a dedicated database instance for Teamcenter.

Oracle installation

1. check Oracle database server must be a version certified for use with Teamcenter.
2. we can check it on GTAC hardware and software certifications.

Preparation and configuration of oracle server 

1. Choose a name for the Teamcenter user account. 
2. Teamcenter uses this account as the owner of all Teamcenter-created tables This account is used by the database administrator to perform tasks required by Teamcenter.
3. If you don't have a certified version of oracle a server installed you can upgrade your version.
4. Teamcenter uses Oracle Net protocols to communicate with an Oracle database.
5. These protocols require that you run a listener process (OracleTNSListener) on the Oracle server to listen for remote connect requests and that all clients can translate the service alias identifying the server and database.

Installation :

1. Log on to the server host as a member of the Administrators group.
2. If you are installing on a primary domain controller (PDC) or a backup domain controller (BDC), log on as a member of the Domain Administrator group.
3. Record the name of the Oracle database server host. Teamcenter Environment Manager (TEM) requires this name during a corporate server installation.
4. launch the setup program.
5. In the Configure Security Updates dialog box, specify whether and how you want to be informed about security updates from Oracle, and then click Next.
6. In the Download Software Updates dialog box, specify whether and how you want to download software updates for Oracle software, and then click Next. 
7. In the Select Installation Options dialog box, select Install database software only and then click Next.
8. In the Grid Installation Options dialog box, select Single instance database installation, and then click Next.
9. In the Select Product Languages dialog box, select the languages you want the Oracle instance to support and then click Next.
10. In the Select Database Edition dialog box, select the database edition to install, and then click Next.
11. In the Specify Oracle Home User dialog box, specify the system account you use to install Oracle. This can be an existing system account or a new system account.
12. In the Specify Installation Location dialog box, specify:
1. Oracle Base: Specifies the path in which to install all Oracle software and configuration files.
2. Software Location: Specifies the path in which to install Oracle software files. This is the Oracle home directory
13. In the Summary dialog box, review the information to ensure you have sufficient disk space, and then click Install.
14. In the Install Product dialog box, monitor the success of the installation stages.
15. When the Finish dialog box displays The installation of Oracle Database was a successful message, Click Close to complete the installation.

Upgrade oracle installation

Do you know

⏩The operating system user account under which you install the Oracle database server

⏩must have system administrator privileges. Siemens recommends you create a system user account named oracle to use during Oracle installation. When you use the oracle account to install Oracle, this account is automatically added to the Windows ORA_DBA local group, giving it SYSDBA privileges.

⏩Do not install a later version of Oracle into an existing Oracle home directory that contains an earlier version.

Read More

Teamcenter Library

 Most used Abbreviation in Teamcenter 

1.     Uniform Resource Identifier (URI)

2.     User interface (UI)

3.     Integration Toolkit (ITK)

4.     Java archive (JAR)

5.     Eclipse rich client platform (RCP)

6.     Uniform Resource Identifier (URI)

7.     Standard Widget Toolkit (SWT)

8.     Abstract Window Toolkit (AWT)

9.     Over-the-Web Installer (OTW)

10.   Installable component descriptor (ICD)

11.   Commercial off-the-shelf (COTS)

12.   Business Modeler Integrated Development Environment (BMIDE).

13.   Source Control Management System (SCM)

14.   Teamcenter client communication system (TCCS)

15.   Source control management (SCM)

16.   Repeatable Digital Validation (RDV)

17.   Operational data store(ODS)

18.   Relational database management system (RDBMS)

 

Read More

How we can Specifying password restrictions in teamcenter?

How we can Specify password restrictions?

Teamcenter enables companies to specify restrictions for passwords when creating user accounts.
These password restrictions are controlled through preference settings and take effect upon password creation. Existing passwords are not affected.

Companies can set the following restrictions:

• Minimum length required (PASSWORD_minimum_characters)
• Mixed case required (PASSWORD_mixed_case_required)
• Minimum number of alpha or numeric characters required (PASSWORD_minimum_alpha and PASSWORD_minimum_digits)
• Special characters

  Alert    

• Never deploy Teamcenter with default passwords. Default passwords are too well known; for example, infodba is the default password for an infodba user.
• Use high-entropy (strong) passwords for all accounts, especially for db2 admin, db2 user, infodba, dcsproxy, operating system user values used for installation, and the DB_CONNECT_STRING value. For example, oiunr0i%%$$9dE is stronger than mypassword.
• The password must not be empty or contain any white space characters, such as space, tab, newline, carriage return, form feed, or vertical tab.
• In addition, the password must not contain any of the following characters:   ! @ $ % = & ' " : ; . < > ( ) { }
• Protect all files containing passwords with OS permissions. Encrypted or not, the "read access" to these files must be guarded because a hacker cannot break the encryption if he can't read the contents.

Read More

What is a person?

What is a person?

Persons are individuals who work at your site. A person has properties such as Name, Address, and Employee Number.

You must define a person for each Teamcenter user. As a user with DBA or group administrator

privileges, you use the Organization application to:

• Create person definitions.
• Modify person definitions.
• Delete person definitions.

How to Create a person?

Person definitions contain real-world information about individual Teamcenter users.

Person definitions can be created:

• Simultaneously with the user definition when using the Organization User wizard.
• Manually using the Organization List tree and corresponding pane.

What is a user?

    A user is a person with an account known to the Teamcenter system. One person can have several user accounts in Teamcenter. The Teamcenter implementation of the user is completely separate from any operating system user account.

A user is assigned to a default group and takes on a role in the group. 

As a user with DBA privileges, you use the Organization application to:

• Create, modify, and delete user accounts.
• Maintain user password restrictions.
• Deactivate or activate user accounts.
• Assign group administrator privileges.
• Assign intellectual property and government clearances to data stored in Teamcenter for user accounts, along with defining multiple citizenships.
• Assign a license bundle to a user.

How to create users in Teamcenter?

Read More

What is teamcenter Administrator account ?

What is the Teamcenter Administrator account?

Administrative privileges are required to manage Teamcenter administrative data like organization, access rules, and workflows. Administration accounts have powerful access to data and must be controlled and managed with caution.

Important Points :

• The infodba account has all the Teamcenter system-level privileges.
• The Bypass administrative setting supersedes other privileges.
• Members of the dba group with the DBA role have a complete system privileges.

For each group :

• Create at least one member who acts as the administrator for that group. Group administrators can assign other group administrators in their group.
• Create a DBA role to manage roles for that group and assign the group administrator. The DBA role for a user in a non-dba group has no additional privileges over any other group member.

What are the Characteristics of the infodba account?

The infodba account has all the Teamcenter system-level privileges, including a bypass switch to override access protections. The infodba account has special access permissions applied to the data they create.

Read More

What is a group?

What is a group?

A group represents a project in Teamcenter. Groups contain members (users) who take on a role or multiple roles in the group. Groups represent data ownership and therefore control data access. Two groups are provided with Teamcenter: dba and system.

• Groups are defined along project lines, not functional lines, but can define third-party organizations such as suppliers.

• A group member can be a member of many groups. For example, Robert Green can belong to the high_performance and standards groups.

Groups make up the core of your organization structure. As a user with DBA privileges, you use the Organization application to:

• Create, modify, and delete groups.

• Manage subgroups within the Organization tree.

• Assign default volumes to a group.

• Assign authorized data access privileges to a group.

What is a subgroup?

A subgroup is a group with another group designated as its parent. A subgroup can also be designated as a parent group itself. The position of subgroups within the Organization hierarchy can be managed by parenting and reparenting groups.

• Subgroups are an excellent way to organize your users.

• Subgroups inherit access permissions, volumes, and preferences from their parent.

What is the default group?

When a user belongs to more than one group, one of them is designated as the default group. A default group must be designated for each user so that Teamcenter can store project files in a central location (for example, in the group volume).

The user's default group is used at logon unless another group is specified.

When Teamcenter Security Services is installed and the TC_SSO_SERVICE the environment variable is set in the tc_profilevars file, logon uses the default Teamcenter group.

What is the parent group?

A parent group is used to organize a configuration of related subgroups.

What is the System administration group?

A Teamcenter administrator also referred to as database administrator (DBA) or user with DBA privileges is any member of a special system administration group and is the primary person responsible for maintaining the Teamcenter software, data volumes, and user accounts. Teamcenter creates one system administration

group (dba) during installation. You can create others as needed.

What is the system group?

Teamcenter provides a special system group that is used for performing specialized tasks in an overall system administration strategy. Currently, members of the system group are primarily responsible for archiving and restoring objects. 

                        Although any Teamcenter user can mark an object for archive or restore, only members of the system group can perform the actual object archive and restore operations. This restriction also applies to members of a system administration group; they cannot perform archive and restore operations either.

Although a user could belong to both the system group and a system administration group, members of the system group do not inherently have the privileges required to perform all Teamcenter administrative tasks.

What is a group administrator?

A group administrator is a group member who can add, modify, or remove group members.

Group administrators must be members of the group they are administering and these privileges are only valid within that group.

What are Group names?

A group is identified uniquely by the combination of its name and its parent. Two groups with different parents may have the same name, but two groups with the same parent may not.

What are Group hierarchies?

what is a process of Moving groups within the hierarchy and volume access?

How to create a group in Teamcenter?

As a user with DBA privileges, you create project-oriented groups to organize clusters of users.

Read More

What is a role?

What is the role?

a role is an object that model the type of work user is expected to perform in the group

important points :

1. A role can be assigned to multiple groups
2. Role added another layer of data access control.
   
3. Roles are created along function line 
4. You create roles to reflect the skills and responsibilities of the users.
5. 
   

Activity user can perform with DBA Role :

1. Create, modify, and delete role definition.
2. Add existing roles to the Organization tree.
3. Add new roles to the Organization tree.
4. Assign a default rule within a group.

How to create a role in Teamcenter?

1. Select the top-level Roles node from the Organization List tree.
2. type a role in Role box and write a description.
3. Click Create.

Read More

What is Volume ?

What is the volume?

A volume is a location where files are stored. A volume equates to a directory on the operating system. Files stored in volumes are created by CAD applications or other third-party applications.

Key Point:

• Teamcenter retains the volume location (directory) and the file name.

• Users should always access files in volumes through Teamcenter.

• Volumes are assigned to groups and users

• define file locations for your organization structure. 

Which role is needed for use Teamcenter organization?

The only user with DBA privilege can use a Teamcenter organization to create and modify

• Create and delete volumes.

• Modify volume location and properties.

        Alert         

Because of limitations and restrictions in NTFS file systems, Siemens PLM Software recommends creating the volume on the machine where the disk physically resides. It is important to choose a location that is constantly accessible to all users.

How to create a volume in Teamcenter?

1. Select Volumes node from the Organization List tree.
2. Type a unique descriptive character string in the Volume Name box.
3. Type the name of the network node that physically contains the new volume in the Node Name box.
4. Select the machine type on which the volume will reside: Unix or Windows.
5. Depending on the machine type, type the full UNIX or Windows path of the new volume in either the UNIX Path Name box or the Windows Path Name box.
6. Select the ID type (FSC, Filestore Group, Load Balancer) to indicate the element in the FMS master configuration to which the new volume element is to be added and type the ID in the ID box.
7. The value you enter into the ID box varies depending upon where the new volume is to be added in the FMS master configuration. That location in the configuration is determined by the ID type selection.
8. The following are examples of each ID type:

      FSC:                              Filestore Group:                    Load Balancer:

1. When the new volume is created, you must specify where in the FMS master configuration the definition of this volume should be placed: the FSC element section, the filestore group section, or the load balancer section.

• Reload

            Makes an FMS configuration the current and active configuration. This is useful for updating the configuration with any manual changes that are made.

• Report

            Displays the master and slave FSCs currently configured and the status of each.

• Display

            Displays the contents of the FMS master configuration file. It can be useful for determining what to add to a volume, for example, an FSC ID or filestore group.

1. Grant users or groups access to the volume, as described in Grant volume access.
2. Click Create.

How to control volume access in Teamcenter?

How to grant volume access in Teamcenter?

How to remove access to Teamcenter volume?

Read More

What is Site in Teamcenter organization?

What is the site?

A site describes an individual installation of Teamcenter and comprises a single database. all users accessing that database any additional non-Teamcenter resources such as hardware, networking capabilities, and third-party software applications (tools) required to implement Teamcenter at the site.

Important Points :

1. Site definitions are consist of an ID and name.
2. Both the site name and ID must be unique.
3. while exporting Teamcenter objects are exported the site ID is used internally by each Teamcenter site to identify itself to other sites.
4. The site name is also used internally and is stored in the database as a user-defined character string.
5. To share data among sites, each Teamcenter database must store a definition of all of the sites in your enterprise.
6. Site names are generated automatically at the time of installation but it can be modified

   Alert :     

Never change the site ID of a database after it is established. The site ID is used to generate internal identifiers for Teamcenter objects that must be unique throughout your enterprise. Never reuse a site ID when creating a new database. For this reason, never use the database's import and export functions to replicate a database; always use Teamcenter import and export capabilities.

How to create a site in Teamcenter?

1. Select the top-level Sites node from the Organization List tree.
2. Type a descriptive name for the site in the Site Name box.
3. Type a unique site ID in the Site ID box. The unique site ID must be an integer.
4. (Optional) Type the site node identifier in the Site Node/URL box. If you are using Multi-Site Collaboration, and this site is configured to provide object directory services (ODS), select the Provide Object Directory Services checkbox. Otherwise, select the Is A Hub checkbox.
5. (Optional) Type the service-oriented architecture (SOA) URL in the SOA URL box. This URL is used for SOA calls to this site. The URL is used for HTTP-based Multi-Site Collaboration.
6. (Optional) Type the Platform Extensibility Configuration URL in the TcGS URL box.
7. (Optional) Type the geographical location of the site in the Geography box.
8. Click Create.

Read More

Teamcenter Organization

What is Organization?

                    The Organization application enables you to create and maintain your company’s organization within Teamcenter by organizing user accounts and their respective permissions and user groups. 

organization Helps You :

•  Track changes to objects.

•  Control access and privileges.

•  Manage default object ownership.

What Acces Needed to use an organization in Teamcenter? 

For use of an organization, You must be a member of the dba group or be granted authorization by a user with system administration privileges in order to make modifications within the Organization. 

This application is read-only to non-dba group users.

The basic process of creating a virtual organization includes the following stages:

1. Establish Teamcenter sites.

2. Define the structure of your organization.

    a. Create volumes.

    b. Enable File Management System (FMS) control of new volumes.

    c. Create roles.

    d. Create groups and subgroups.

    e. Add roles to groups.

3. Create users and persons.

    a. Create person definitions.

    b. Create user accounts.

Using the following ways we can create a Teamcenter Organization:

 1. Setup Wizard

 2. Organization tree

 3. Organization list tree

 4. Using a Batch Script

Read More

JAVA Interview Question

Q: What is the use of property files in JAVA?

Ans: In most applications, the properties file is loaded during the application startup and is cached for future references. Whenever we need to get a property value by its key, we will refer to the properties cache and get the value from it.

The properties cache is usually a singleton static instance so that the application does not require to read the property file multiple times; because the IO cost of reading the file again is very high for any time-critical application.

Q: Why we may want to generate the hash for a file?

Ans: Any serious file provider provides a mechanism to have a checksum on their downloadable files. A checksum is a form of mechanism to ensure that the file we downloaded is properly downloaded.

Checksum acts like a proof of the validity of a file so if a file gets corrupted this checksum will change and thus let us know that this file is not the same file or the file has been corrupted between the transfer for any reason.

We can also create the checksum of the file to detect any possible change in the file by third party e.g. license files. We provide licenses to clients which they may upload to their server. We can cross verify the checksum of the file to verify that the license file has not been modified after the creation

Read More