Setting Environment Variables

Several environment variables should be set so that the database instance runs properly:

  • ORACLE_SID specifies the default instance to connect to. Set this to JSTP.

  • ORACLE_HOME specifies the full pathname of the Oracle system home directory. Set this to the directory in which the Oracle software is installed. This is a mandatory configuration parameter and is used by many Oracle executables to locate shared code, configuration files, and so on.

  • PATH specifies the search path and should include the ORACLE_HOME directory.

  • ORA_NLS specifies the location of the language object files. If the database is started with languages and character sets other than the database defaults, and ORA_NLS isn't set properly, they won't be ...

Get e-Commerce Applications Using Oracle8i and Java from Scratch now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial