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: invoking sqlplus giving error

Re: invoking sqlplus giving error

From: <fitzjarrell_at_cox.net>
Date: 28 Jan 2007 08:01:52 -0800
Message-ID: <1170000112.497975.24450@a34g2000cwb.googlegroups.com>

On Jan 28, 12:54 am, "Jagjeet Singh" <jagjeet.ma..._at_gmail.com> wrote:
> Hi
>
> Can anybody please look into this. I have installed oracle 920 on
> Redhat ES 3.
> But while invoking sqlplus I am getting this error.
>
> ##########################################
> [ora9_at_vicky admin]$ uname -a
> Linux vicky.oracle.com 2.4.21-4.EL #1 Fri Oct 3 18:13:58 EDT 2003 i686
> i686 i386 GNU/Linux
> [ora9_at_vicky admin]$
> [ora9_at_vicky admin]$ set | grep ORACLE
> ORACLE_BASE=/ora9/app/oracle/product
> ORACLE_HOME=/ora9/app/oracle/product/9.2.0
> ORACLE_SID=db1
> [ora9_at_vicky admin]$ sqlplus
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Sun Jan 28 12:23:41 2007
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter user-name: / as sysdba
> ERROR:
> ORA-12545: Connect failed because target host or object does not exist
>
> ##########################################
>
> Regards,
> Jagjeet Singh

You did follow the pre-installation checklist and set your kernel parameters as specified? You did check your /etc/hosts file to verify you have localhost defined properly? According to oerr ( which you should have installed and should have used ):

ORA-12545: Connect failed because target host or object does not exist
Cause: The address specified is not valid, or the program being connected to does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.

Please check the listed items, restart the server to recognise the changed kernel settings and try again.

David Fitzjarrell Received on Sun Jan 28 2007 - 10:01:52 CST

Original text of this message

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