Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connecting to oracle database

Re: connecting to oracle database

From: Robert <malikian_at_malikian.homechoice.co.uk>
Date: Sat, 6 Oct 2001 16:23:52 +0100
Message-ID: <3bbf233e@news1.homechoice.co.uk>


Search for a file called tnsnames.ora in there you will see the name of your database.
Below is an extract from a tnsname.ora file; TESTDB.MSHOME.NET =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = master)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = TESTDB)
    )
  )
in this case the database name is TESTDB

UserName: system
Password: manager
Database: TESTDB

Robert

"DukeNM" <akshaysalkar_at_joymail.com> wrote in message news:f987cd53.0110042139.52c364ac_at_posting.google.com...
> [For Developer2000]
> UserName: scott
> Password: tiger
> Database:

>

> [For Oracle8i SQLPlus]
> UserName:
> Password:
> HostString:
>

> My question is that i have installed both oracle8i and developer2000
> in different locations.
> ie. Oracle8i in d:\Oracle
> and Dev2000 in d:\Dev2000
>

> Now it is not connecting from developer to the database...what should
> i do?
>

> What to put in the Oracle.ini file???
>

> Also how to know what the name of my default database is?
>

> sorry but i m a newbie.. :)
>

> I have Personal Oracle8i for Win98
> and Dev2000 Rel2.1
Received on Sat Oct 06 2001 - 10:23:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US