Previous Lecture Complete and continue  

  Creation of Oracle Database

In this video we demonstrate how to create an Oracle database, PSHRDMO, which will be used to create a PeopleSoft HRMS Demo database.

Make sure you run dbca as admin because the database creation may fail otherwise.

Adding TNS Entries

You can check if you're able to connect to database by running 'tnsping' command. Go to command prompt and type

tnsping database_name

e.g. tnsping PSHRDMO

If tnsping is unsuccessful, check the oracle path being used during tnsping and navigate to ORACLE_HOME/network/admin and manual add tns entries for your database to tnsnames.ora file. If tnsnames.ora doesn't exist, you can create a new one Below is the example of tns entry.

Tns entry format:

<database_name> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <db_host_name>)(PORT = <db_port_no>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database_name>)
)
)

Example:

PSHRDMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PSHRDMO) )
)


2 comments