Home » SQL & PL/SQL » SQL & PL/SQL » Login Failed to DB 11.2 from SQL*PLUS [merged 2]
Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520554] Tue, 23 August 2011 07:25 Go to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
Dear Gentlemen

I have laptop by this specification:
1) Operating System: Windows 7 64-bit
2) Virtual Machine: Windows XP Service Pack 3
3) DB: Oracle 11.2
4) Oracle Form Designer 4.5


i try to connect to SQL*PLUS 3.3 i got this error after defining in TNSNAMES.ORA in this folder c:\orant\network\admin\tnsnames.ora



SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 18 19:49:12 2011

Copyright © 1982, 2010, Oracle. All rights reserved.

SQL> SHO USER
USER is ""
SQL> CONN SYSTEM@LOC
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL>
Re: Login Failed to DB 11.2 from SQL*PLUS [message #520559 is a reply to message #520554] Tue, 23 August 2011 07:58 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
That is not a cut and paste of your session. I see a sqlplus banner, but no database connect banner.
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520560 is a reply to message #520554] Tue, 23 August 2011 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.

Regards
Michel
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520565 is a reply to message #520560] Tue, 23 August 2011 08:32 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member

if i am using DOS Command is ok by TNSPING and the name of my Host DB but for SQL not sucess

Plase Help me by more clarification

Thanks in Advance
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520566 is a reply to message #520565] Tue, 23 August 2011 08:34 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Show it! Not just the output, because we have no idea "how" you got there.
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520582 is a reply to message #520554] Tue, 23 August 2011 10:46 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
I hope these attached file are clear to get my problem

This is part 1

/forum/fa/9287/0/

for any clarification i am ready for any questions


[mod-edit: image inserted into post by bb]

[Updated on: Tue, 23 August 2011 16:42] by Moderator

Report message to a moderator

Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520583 is a reply to message #520582] Tue, 23 August 2011 10:47 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
This part 2
/forum/fa/9288/0/


[mod-edit: image inserted into post by bb]

[Updated on: Tue, 23 August 2011 16:44] by Moderator

Report message to a moderator

Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520584 is a reply to message #520582] Tue, 23 August 2011 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Many of us can't or don't want to download files, so post them inline and post them formatted.

Regards
Michel
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520585 is a reply to message #520583] Tue, 23 August 2011 10:48 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
this is part 3 from 3
/forum/fa/9289/0/


[mod-edit: image inserted into post by bb]

[Updated on: Tue, 23 August 2011 16:46] by Moderator

Report message to a moderator

Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520586 is a reply to message #520585] Tue, 23 August 2011 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 23 August 2011 17:48
Many of us can't or don't want to download files, so post them inline and post them formatted.

Regards
Michel

Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520587 is a reply to message #520584] Tue, 23 August 2011 10:50 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
can you give me3 example because this first time to me to put subject and i do not know how become professional way to explaen to all of you
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520590 is a reply to message #520587] Tue, 23 August 2011 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Explain what? How to copy and paste text?
Just see how I posted, it is from a DOS box.

Regards
Michel
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520591 is a reply to message #520590] Tue, 23 August 2011 11:00 Go to previous messageGo to next message
cookiemonster
Messages: 13968
Registered: September 2008
Location: Rainy Manchester
Senior Member
Read this How to use [code] tags and make your code easier to read?
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520593 is a reply to message #520591] Tue, 23 August 2011 11:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

when logged directly onto DB Server system, then SQL*Net is NOT required to access local DB

instead of SQL> CONNECT USERNAME/PASSWORD@LOC just do as below
SQL> CONNECT USERNAME/PASSWORD
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520595 is a reply to message #520593] Tue, 23 August 2011 11:44 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
local.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1526)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

C:\orant\NETWORK\ADMIN>tnsping local

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 23-AUG-2
011 20:07:11

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

Used parameter files:
C:\app\Abadi\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
OK (10 msec)
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520596 is a reply to message #520595] Tue, 23 August 2011 11:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(HOST = 127.0.0.1)
above precludes access from remote client system.
can only be accessed directly from DB Server itself.
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520597 is a reply to message #520596] Tue, 23 August 2011 11:50 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
BlackSwan wrote on Tue, 23 August 2011 19:47
>(HOST = 127.0.0.1)
above precludes access from remote client system.
can only be accessed directly from DB Server itself.





It is hang and not respond if keep null for DB Host name

and i found in Service Task in Oracle start automatic but that status is null so not working , its name OracleDBConsoleorcl
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520598 is a reply to message #520597] Tue, 23 August 2011 11:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It works for me.

oracle@bcm-laptop:~$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-AUG-2011 09:56:54

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                23-AUG-2011 09:56:56
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "v112" has 1 instance(s).
  Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@bcm-laptop:~$ tnsping v112

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 23-AUG-2011 09:57:11

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

Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=V112)))
OK (40 msec)
oracle@bcm-laptop:~$ sqlplus hr/hr@v112

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 23 09:57:35 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 

Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520601 is a reply to message #520598] Tue, 23 August 2011 12:00 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
Dear Black swan

My concern for SQL*PLUS version 3.3

not SQL for ORacle DB 11.2

because i will work on Designer 4.5 and Report 2.5

is it clear or need detail

Thanks a lot
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520602 is a reply to message #520601] Tue, 23 August 2011 12:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>My concern for SQL*PLUS version 3.3
above is ancient & obsoleted client & likely incompatible with V11 DB
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520604 is a reply to message #520602] Tue, 23 August 2011 12:06 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
ok what is also about the Form Builder 6 with SQL*PLUS 8


Kindly from where you get this is not compatible
Please Advice
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520608 is a reply to message #520604] Tue, 23 August 2011 12:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Same thing.
Start using softwares that have developed in this century.

Regards
Michel
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520628 is a reply to message #520608] Tue, 23 August 2011 14:04 Go to previous messageGo to next message
s3di
Messages: 11
Registered: March 2010
Junior Member
before i was using Oracle DB 10G for both Tools for Form Designer 4.5 and Forms Builder 6i
and it is ok.

But what is your said not match with this case because DB 10g in this century and old tools for Forms for Previous century

this is what i understand from you, is not it.


Thanks,

Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520629 is a reply to message #520628] Tue, 23 August 2011 14:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
As a general rule, Oracle client tools will successfully inter-operate as long as they are within TWO major release numbers.
This means that V8 client can talk to V10 DB but can have issues talking to V11 DB.
For example V7 client can not operate against V10 DB.
Forms 6 is built upon V8 SQL*Net

If you have any continuing issue, then submit Service Request to Oracle Support!
Re: Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520630 is a reply to message #520628] Tue, 23 August 2011 14:15 Go to previous message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, it is not.
And bewteen 10g and 11.2 there are 5 years. 5 years is is an era in computer world.

Regards
Michel
Previous Topic: oracle
Next Topic: hi
Goto Forum:
  


Current Time: Mon Sep 01 12:01:26 CDT 2025