Re: TNSNAMES, LISTENER, ORA-12154, Create New DB problems

<argosy22_at_my-deja.com> wrote in message news:8brp3l$f6h$1_at_nnrp1.deja.com...
> HI again,
>
> Ok, I got it to work. It was the nesting of the
> brackets in the LISTENER.ORA file. No meaningful
> error messages. Just didn't work.
>
> So now, I the database is started.
> From Windows NT, I can connect to either database.
> Either by entering the username, password, ORACLE_SID
> names one by one, or all at once:
> username/password_at_the_sid
>
> On the Unix side, I can log into either database with:
>
> change ORACLE_SID
>
> sqlplus
> - username
> - password
>
>
> This will work for the original database
> username/password_at_the_sid
>
> but will not work for the new one. ???
>
>
> I did changed the TNSNAMES.ORA on file on Unix.
> I copied from both the original unix, and also
> from NT, but, no dice.
>
> Also tnsping works for the old database,
> but not the new one.
>
> Another > 12 hour day for me. Any suggestions?
>
> Thanks,
>
> Argosy
>
>
>
>
>
>
>
>
>
>
> In article <8brjlk$9bb$1_at_nnrp1.deja.com>,
> argosy22_at_my-deja.com wrote:
> >
> >
> > HI all,
> >
> > We are running Oracle 7.3.4 on Sun 5.6.
> >
> > I have
> > - created a new database,
> > - and ran the scripts
> > catalog
> > catproc
> > pupbld.sql
> >
> > I modified the TNSNAMES.ORA and LISTENER.ORA files
> > to include the new ORACLE_SID.
> >
> > I stopped and restarted the database.
> > The batch script includes starting the listener.
> >
> > ltfd1 - new database
> > ntst1 - old database
> >
> > Now, on the Unix side, if I do:
> >
> > export ORACLE_SID=the_sid
> >
> > and
> >
> > sqlplus
> > - enter username and password
> >
> > things works fine.
> >
> > However, if I try to run everything as one string
> > with either SID:
> >
> > sqlplus username/password_at_some_SID
> >
>
>
> Sent via Deja.com http://www.deja.com/

I don't know how your listener.ora looks like now, but from your previous post it is incorrect

It should be
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ntst1)
    )
    (SID_DESC =
      (SID_NAME = ltfd1)
    )
  )

And you are lacking the line ORACLE_HOME = <directory name> in both cases.
Exporting the ORACLE_SID on Unix bypasses sqlnet, so that's why that method work.

I'm getting a bit sad about a day of > 12 hr. Did you ever consult documentation and/or use the network manager (instead of net easy config). Your problems most likely would have been resolved long ago. It is not THAT difficult. Don't want to be harsh on you, don't get me wrong. In the past I usually started with the 'trial and error' method instead of reading documentation, and my employer usually didn't want to pay $$ for courses. However, most likely they will pay themselves back instanteanously.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Mar 28 2000 - 23:33:33 CST