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

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/
Before you buy. Received on Tue Mar 28 2000 - 20:17:37 CST