[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1002
  • Last Modified:

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...
0
dbaseek
Asked:
dbaseek
  • 2
  • 2
1 Solution
 
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
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now