hi all,
I have installed redhat Enterprise linux 3.0 and Oracle 9.2.0.4 on a server.2 databases have been created on the same server. while connecting to these databases through an OS authenticated user thru Oracle it connects to an idle instance.prior installations with the same configurations have no problem.we are using exactly the same (as those for the working ones)bash_profile and enviornment variables for this as well. Following is the message on the server----------- Under ideal condition :
sqlplus "sys as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 18 17:42:18 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to: Oracle9i Release 9.2.0.4.0 - Production JServer Release 9.2.0.4.0 - Production SQL>
Under problem condition :
sqlplus "sys as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 18 17:31:23 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password: Connected to an idle instance. SQL>
the only way I can connect to the database is by giving the full connect string to connect which is actually not required for OS authenticated users.
Is this an issue relate dto Linux or Oracle ? I am unable to resolve this issue.any suggestions on this issue will be highly appreciated.