Re: NEWBIE DBA studio: couldn't resolve service name

How are you *exactly* connecting, and what are the contents of your sqlnet.ora (if you have one)
Apparently you are using <username/password>@testor2 while the official syntax is <username/password>@service.domain and as from Oracle 8i there is no default domain anymore. So either
a) you are lacking a sqlnet.ora with names.default_domain = std.com (and names.default_zone = std.com)
or
b) your db_domain init.ora parameter is blank, and your global database name incorrect
or
c) both.

Hth,

Sybrand Bakker, Oracle DBA

<frank_luo_at_sabre.com> wrote in message news:8r5tj0$k5g$1_at_nnrp1.deja.com...
> I just installed Oracle8i, created a dababase "testor2" during
> installation. Then I try to open testor2 in DBA studio but failed with
> message " Ora-12154:TNS:could not resolve service name." Can anyone
> help please.
>
> I pasted TNSNAMES.ORA and Listener.ora file here.
>
> My machine name is frankl, Domain sdt.com. I am running everything from
> this machine.
>
> # TNSNAMES.ORA Network Configuration File: f:\Oracle\Ora81
> \network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> EXTPROC_CONNECTION_DATA.SDT.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> TESTOR2.SDT.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = frankl)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = testor2)
> )
> )
>
>
> # LISTENER.ORA Network Configuration File: f:\Oracle\Ora81
> \network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = frankl)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = frankl)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = f:\Oracle\Ora81)
> (PROGRAM = extproc)
> )
>
> (SID_DESC =
> (GLOBAL_DBNAME = testor2.SDT.COM)
> (ORACLE_HOME = f:\Oracle\Ora81)
> (SID_NAME = testor2)
> )
> )
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 01 2000 - 02:31:34 CDT