Login Failed to DB 11.2 from SQL*PLUS [merged 2] [message #520554] |
Tue, 23 August 2011 07:25  |
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 [merged 2] [message #520595 is a reply to message #520593] |
Tue, 23 August 2011 11:44   |
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 #520597 is a reply to message #520596] |
Tue, 23 August 2011 11:50   |
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   |
 |
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 #520628 is a reply to message #520608] |
Tue, 23 August 2011 14:04   |
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,
|
|
|
|
|