Re: configuring a new database

Imran Rahim wrote:

> I have just installed a new Oracle 8.1.7 database on Linux and am
> having a few connection problems. Can anyone explain to me what the
> relationship should be between:
> a) the name(and the case used i.e. upper or lower) given to the
> database at creation time
> b) the entry in the listener file
> c) the ORACLE_SID setting when you set the environment on your machine
> before also setting ORACLE_HOME and invoking sqlplus
>
> its odd - I have v$parameter saying my database is called mig001, yest
> my listener states it as MIG001.world
>
> if I set ORACLE_SID = MIG001 then I cant log in , but if I set it to
> mig001 then I can.
>
> I just need to have a checklist of things to go through i.e. what case
> to use, where it is relevant and where it isnt; what Oracle looks at
> when starting up, whjat it refers to when you set ORACLE_SID etc
>
> any help much appreciated

Linux is case sensitive. Oracle is not ... except when performing string comparisons.

Daniel Morgan Received on Sat Apr 19 2003 - 20:40:11 CDT