ora-12560 in oracle 10g client macine

I recently installed oracle 10g 10.2.0.1.0 client I have
ora-12560 in oracle 10g client..
in services.msc is there any option to start...
when I try to connect sys / as sysdba
it is asking for password
Actually what is wrong...
dbaseekAsked:
Who is Participating?
 
TolomirAdministratorCommented:
you need either the IP or a fully qualified name in the tnsnames.ora

FQN can work with oracle.mysite.com in the hosts file or in the DND server

ORACLE =
 (DESCRIPTION =
   (ADDRESS_LIST =     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.mysite.com)(PORT = 1521))
  )
   (CONNECT_DATA =
 (SERVICE_NAME = oracle)
 )
 )

or IP based should always work - like this

oracle=
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.128) (PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle)
    )
  )

In both cases you can use oracle as database name! (oracle = ...)
0
 
fluglashCommented:
>when I try to connect sys / as sysdba
conn /@your_sid as sysdba
0
 
TolomirAdministratorCommented:
Well actually you can only use

sqlplus / as sysdba

on the server when you are the proper user (oracle) on a proper setup server system.
In that case a local password file is used to login to your database.

On the client machine there is no such password helping file and you always have to use proper
connect sys/sys_password_here@database_sid_here as sysdba;
to get into it.

The oracle error says it cannot find the database you want to connect to. With a proper setup tnsnames.ora file
database_sid_here should be found.

You can test this with "tnsping database_sid_here" on the command prompt.

When oracle asks for a password it doesn't mean everything is fine. Even when oracle is totally lost, it asks for a password. So one should not think, he is one step further.

Reading starting a server - that is not needed. A client doesn't have to run any oracle service to offer access to a database. That is what servers are for. If there is a firewall between your client and server just make sure that TCP port 1521 is open between them.

Tolomir
0
 
dbaseekAuthor Commented:
Here is my tnsnames.ora in client
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE =
 (DESCRIPTION =
   (ADDRESS_LIST =     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
  )
   (CONNECT_DATA =
 (SERVICE_NAME = oracle)
 )
 )
----------------------------------
after tnsping oracle
output:

C:\Documents and Settings\Owner>tnsping oracle

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-OCT-2
008 20:31:20

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_3\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = oracle)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oracle)))
TNS-12545: Connect failed because target host or object does not exist

C:\Documents and Settings\Owner>
How can I resolve this?

0
 
fluglashCommented:
ping the host with Oracle, seems the host is unreachable
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.