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

Dear Sir,

It's obviously that I'm new to Oracle and yes, I worked a lot with MS SQLServer. But, I also want to learn Oracle, so you maybe could clear some things for me:

First, I know for sure that I want a new full database. (new data files, logs and everything).

On my server, I have recently installed Oracle 8i (Professional Edition) 8.1.6, with NO sample database. So, at this moment, I have no databases installed on my machine (W2000).

So:

1. I have installed Oracle 8i server (8.1.6) on W2k.
2. At this moment, I have NO db-s on the machine.
3. I want to create a new DB by scripts.

Please explain to me how Oracle achieves this goal for me? I know that the process of creating a new db consists in:

1. create the new db via "oradim -NEW ..."
2. set ORACLE_SID=XXX
3. connect via svrmgrl as internal/oracle
4. call create database statement (usually from a larger script where you put all the necessary settings for the new database)
5. create listeners&Co to allow clients to connect to it.

At this very moment (remember, I have NO db-s yet) if I call svrmgrl as internal/oracle I always get TNS adapter error. These days I've been experiencing a lot with this problem and I fears that even if I choose to create the new DB autonomously using "DB Configuration Assistant" I will get the same error.

So, do you think that I should try to create the db and no error will occur?
Anyway, could you please confirm if my assessments are correct or not (maybe incomplete)

Thank you for your time and patience.

Regards,
Virgil Galan

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tt7nvp6s8ch644_at_corp.supernews.com>...
> 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 Tue Oct 23 2001 - 09:50:50 CDT