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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Default SID

Re: Default SID

From: Matt Griffiths <nospammy_itsystems_at_dial.pipex.com>
Date: Sun, 07 Jun 1998 08:40:04 GMT
Message-ID: <357a516a.2564086@47.96.2.87>


You might want to look at through the Oracle manuals - i think there is an environmental setting like

set oracle_sid = yoursid

that you can put in your client autoexec.bat

good luck

Matt

On Sun, 07 Jun 1998 01:43:35 +0200, Gorm Larsen <1relax_at_image.dk> wrote:

>Hi,
>
>I have a small problem with Oracle 7.3.4 on the NT-platform. I chose NOT
>to install the starter-database, but instead create my own SID and
>database. Everything works fine, except that no users can log on without
>the @MYSID extension. I.e. Connect internal/manager doesn't work, but
>Connect internal/manager_at_mysid works. I have changed all the instances
>of ORCL to MYSID in TNSNAMES, LISTENER and REGISTRY, but i still have to
>use the extension.
>Is it possible to GRANT CONNECT USER TO TABLESPACE DEFAULT 'MYSID' or
>something like that.
>
>--
>Gorm Larsen
>1relax_at_image.dk og gla_at_syspart.dk
>
Received on Sun Jun 07 1998 - 03:40:04 CDT

Original text of this message

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