Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbee: tnsping don't find database (TNS-03505)
If the database is on the same machine, then you do not need to type the
Service ID. Try only entering username and password in SQLPLUS login
"Tom Albrecht" <mr.shadow_at_gmx.net> wrote in message
news:397da64a.0111151359.10123a2d_at_posting.google.com...
> Hi there,
>
> Preface: I am a newbee. I have no idea of administration an oracle
> database server. But I have to use SQL Plus to call a sql-script
> because it is a constraint-fix for my application.
>
> I am using the Oracle database server 8.1.6.0.0 on an winNT 4-machine.
> It is a local installation and i can connect to it with an
> application.
>
> I opened SQL Plus and after entering the user-id, password and
> database name. sql plus prints out "ORA-12154: TNS:Der Servicename
> konnte nicht aufgelöst werden."
>
> Then I tried a tnsping to the database, but the result is a
> TNS-03505-error.
>
> On my machine are three tnsname.ora-files. All files are like this:
>
> income.world =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp_comm.world)
> (PROTOCOL = TCP)
> (Host = 10.100.9.126)
> (Port = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = income)
> (GLOBAL_NAME = income.world)
> )
> )
> )
>
> I use an application to connect to the database and it still works. I
> only need SQL Plus.
>
> Please, help me!
Received on Thu Nov 15 2001 - 16:23:44 CST