Date: Tue, 3 Mar 2009 19:10:37 -0800 (PST)
On Mar 3, 7:43 pm, Ming$BGl(B <l..._at_tech-trans.com> wrote:
> My Windows base Oracle server has 2 Oracle instances. However, when
> I connect to one of instance by sqlplus, Ora-12514 occurs! How can I
> do? I have tried the following methods
> 1. set oracle_sid=XXXX
> 2. sqlplus /nolog | connect sys_at_XXX as sysdba
> 3. add names.directory_path = (ONAMES, TNSNAMES, HOSTNAME) in
Why would you set the environment variable "ORACLE_SID" if you're
going to connect through the listener?
If you are going to connect locally (bequeath), line #2 should read
sqlplus / as sysdba
in which case sqlnet.ora should read:
and names.directory_path matters not.
On the localhost, bypass the listener entirely.
-bdbafh Received on Tue Mar 03 2009 - 21:10:37 CST