Re: TNS adapter error...just advice, ok?

3
'Databases' in Sqlserver/Sybase equate to 'schemas' in Oracle. You are mixing up 'database' and 'instance' and you seem to be going to create a 'new database' where it looks like you want to create a 'new instance'.
I'm not sure whether you want to create a new instance, as an instance is a set of memory and processes/threads managing a database, and your system may not permit (ie creating a new instance will definitely take much more virtual memory than having a new schema in an existing database). That's for you to decide.
To create a new instance you need the oradim utility/database create assistant and you don't have to bother about registry keys. The instance name (which is what the SID is) definitely *can't* be ORCL, as the instance name is supposed to be unique on one server. That said, the 12560 is a net8 error message. Normally when you are on the same system where the database is, you have ORACLE_SID set, and this means you don't use net8 at all, but interprocess communication instead. Once you have multiple databases, you can connect *directly* to one database at a time, for your other database you need to configure net8 which you need to do anyway. So in the GUI sqlplus you can connect to the default database without specifying a service name, for other databases you need to have a service name, listener.ora configured on the server, and tnsnames.ora configured on the client.
As I do not intend to provide a complete crash course 'setting up a second instance' as I don't know whether you should *really* need a second instance and I don't know your exact situation, and it will also take me too much time, I will leave it at this currently.

Regards,

Sybrand Bakker
Senior Oracle DBA

"vg" <vgalan_at_personal.ro> wrote in message news:54e5e6b4.0110212248.2c63a3df_at_posting.google.com...
> 1. I apologize for my previous posting but I got a little frustrated
> because of this situation.
> 2. YES, it's the notorious 12560 error. I read so many postings about
> this error I assumed everybody knows it.
> 3. You may be right. I do have an ORACLE_SID registry key but only for
> my first database. My question is to what exactly should point this
> ORACLE_SID key in order to be able to create a new DB? And where
> should this key be added? ( ...\ORACLE\ALL_HOMES ? ) And of course,
> what value this key should have? ORCL?
>
> Thank you again for your time and patience...
>
> VG.
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:<tt0p0sh65knv10_at_corp.supernews.com>...
> > "vg" <vgalan_at_personal.ro> wrote in message
> > news:54e5e6b4.0110190629.5c32c023_at_posting.google.com...
> > > I&#8217;ll be very brief:
> > >
> > > 1. TNS adapter error when I connect as internal/oracle via svrmgrl.
> > > 2. No problem connecting to other db.
> > > 3. I&#8217;m using 8.1.6 on W2k
> > >
> > > May guess is that somehow I deleted some default settings for
> > > ORCL&#8230;How can I fix it?
> > > In my listener.ora there are only my listeners&#8230;
> > >
> > > Thank you for your time!
> > >
> > > VG
> >
> > Which error? Please always post error numbers and messages.
> > If it is 12560, you don't have an environment var/registry key
ORACLE_SID
> >
> > Hth,
> > Sybrand Bakker
> > Senior Oracle DBA
Received on Mon Oct 22 2001 - 02:24:10 CDT