Why VISION DEMO Appliance slash auth SQLPLUS / as SYSDBA is not working

This post could also be entitled “Setting up the linux user (oracle and applmgr) environments for full functionality at the commandn prompt”.

There are multiple .env files located around on the server on this appliance, and only one set of circumstances allows you to authenticate as system or sys or “internal” (/ as sysdba) from the server.

To make sure this works do the following:

  1. make sure the oracle user is in the dba group.  if not use the unix groups utility to add it to the dba group.
  2. for ease of use, set up the oracle user to use the correct autoconfig environment file..

An easy command to find all the applicable .env files is:

find . -name "*.env" -print 2> /dev/null | grep -vE 'admin\/out|appsutil\/out|appsutil\/out|appsutil\/template|admin\/template'

Also, the results of this list will differ depending on if you are working in a 12.1.3 appliance or a 12.2.4 appliance:

List of ENV files found around the server in R12.1.3:

ENV file Listing on VISION DEMO

The key ones are:

/u01/install/APPS/apps/apps_st/appl/APPSEBSDB_ebs.env
/u01/install/APPS/apps/apps_st/appl/EBSDB_ebs.env
/u01/install/APPS/apps/apps_st/appl/customEBSDB_ebs.env

(the APPS one should be added to the APPLMGR user .bash_profile as it will run the other two)  This sets up the $APPL_TOP and all the associated applications variables.

/u01/install/VISION/db/tech_st/11.2.0/EBSDB_ebs.env

This one should be added to the oracle users’s .bash_profile.  It is this file that will enable sqlplus properly and set the environment properly so that SYSDBA connections work.

 

When working in R12.2.4:

R12.2.4 *.env file listing

In this case, the env file that will set up sqlplus properly is the one at:

./install/VISION/11.2.0/EBSDB_ebs.env

This one should be added to the oracle users’s .bash_profile.  It is this file that will enable sqlplus properly and set the environment properly so that SYSDBA connections work.

 

1 thought on “Why VISION DEMO Appliance slash auth SQLPLUS / as SYSDBA is not working”

Leave a Reply