Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't connect internal using service name

Re: Can't connect internal using service name

From: Antoine Brunel <antoinebrunel_at_yahoo.fr>
Date: Fri, 21 May 1999 09:57:04 +0200
Message-ID: <7i369g$dt3$1@minus.oleane.net> 





> I need to 'setenv ORACLE_SID orcl2_service' everytime in order to


> connect to internal/oracle.  Anyone has ideas?





>>set a password for internal with the orapwd utility.



Negative: setting password won't help. You cannot use dblink to connect as
sysdba or sysoper. As you said, you must set ORACLE_SID environnement
variable to the sid you want to connect. Under NT, you can permanently set a
variable to a value, and I'm sure you can do the same under unix.


Received on Fri May 21 1999 - 02:57:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US