Problem
GENERAL ERROR: The user is unable to connect to the Oracle database using the NetBackup Java GUI. The user can see the Oracle databases, and when selected, gets a prompt for user account and password, however, the user receives an error stating NetBackup cannot connect to the database
Solution
Overview:
User unable to connect to Oracle databases through the NetBackup (tm) Java GUI.
Troubleshooting:
Review the oratab file on the Oracle server and search for lines containing an asterisk (*).
Resolution:
In the "oratab" file, there was not an entry for the database's System Identifier (SID). Additionally, there were several lines in the oratab file which have an asterisk (*) instead of the SID name. After changing one of these lines to correctly reflect the SID to use, the user was able to connect to the SID through the NetBackup GUI.
Example of an oratab file:
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
sample:/app/oracle/product/9.2.0.1:N
production:/app/oracle9i/product/9.0.1:Y
reporting:/app/oracle/product/9.2.0.1:Y
User unable to connect to Oracle databases through the NetBackup (tm) Java GUI.
Troubleshooting:
Review the oratab file on the Oracle server and search for lines containing an asterisk (*).
Resolution:
In the "oratab" file, there was not an entry for the database's System Identifier (SID). Additionally, there were several lines in the oratab file which have an asterisk (*) instead of the SID name. After changing one of these lines to correctly reflect the SID to use, the user was able to connect to the SID through the NetBackup GUI.
Example of an oratab file:
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
sample:/app/oracle/product/9.2.0.1:N
production:/app/oracle9i/product/9.0.1:Y
reporting:/app/oracle/product/9.2.0.1:Y