Re: listener.ora, tnsnames.ora

Ivan, you got a perfectly good answer from someone who knows what they are talking about, specific to the question you asked, and that's more than a lot of people here ever get.

If you don't like Oracle, you can always have fun with SYBASE, or Informix or DB/2 (both owned by IBM now), or whatever you please.

You asked, you were answered; don't go dumping on Oracle because it turns out the answer isn't a quick, instant easy thing, nor the person that offered honest help to you who has nothing to gain from it.

Try building an "Installshield" (tm) script for a TOTAL IS/ATHENA database on CDC NOS and then complain.

The only thing that ticks me off more than people making of others who know less than they, are people who bite the hand that feeds them when the owner of said hand is only trying to help.

No wonder USENET is still a pain.

Have a nice day and good luck.

RSH. "Ivan Andonov" <iandonov_at_netscape.net> wrote in message news:55f9b64.0203040619.2c0ed82c_at_posting.google.com... > "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a5vfmb$780$1_at_lust.ihug.co.nz>...
> > What's wrong with notepad? All you do is find your existing
listener.ora
> > and tnsnames.ora in ORACLE_HOME\network\admin, and open them up in
notepad
> > and start typing.
> >
> > Regards
> > HJR
> > --
> > ----------------------------------------------
> > Resources for Oracle: http://www.hjrdba.com
> > ===============================
> >
> >
> > "Ivan Andonov" <iandonov_at_netscape.net> wrote in message
> > news:55f9b64.0203040138.73e54d0b_at_posting.google.com...
> > > How can I add entries for new database in listener.ora and tnsname.ora
> > > with command line tool??
> > >
> > > I am building Installshield setup for database for Oracle 9.
> > > I can create instance with .bat file using ORADIM, and I can create
> > > the database with SQLPLUS scripts, but I cannot add entries in
> > > LISTENER.ORA and TNSNAMES.ORA
> > >
> > > Please HELP!!
> > >
> > > Thanks
> > > Ivan Andonov

>
>
> You do not understand the situation:
>
> I am building Setup for an Oracle database.
> I call ORADIM and SQLPLUS from InstallShield script - I have templates
> for .bat files and .slq scripts and when I want to add
> programmatically entries for my database in LISTENER.ORA and
> TNSNAMES.ORA, I cannot do it.
>
> I must ask 'end user' to open this files and write in it.
> This is not good.
> This is absurd!
> And this is only Oracle!
>
> Thanks
> Ivan Andonov