Home » Infrastructure » Windows » Developer 10 with oracle database 11g (Windows 7 - 64 bit)
Developer 10 with oracle database 11g [message #612763] Thu, 24 April 2014 11:50 Go to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
I have installed Oracle developer 10.1.2.0.2 in c:\DevSuiteHome_1 folder & installed oracel database 11g on d:\app\shah folder

I can able to connect oracle using user name system & with password.

but when i am trying to connect database using forms it gives me error ORA-12560 TNS:Protocol adapter error.

I had copied tnsnames.ora & sqlnet.ora file from oracle folder (d:\app\shah\product\11.2.0\dbhome2\network) to developer folder (c:\devsuitehome_1\network\admin)

My LSNRCTL Status is given below....



LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 24-APR-2014 20:44:29

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 24-APR-2014 19:07:57
Uptime 0 days 1 hr. 36 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\Shah\product\11.2.0\dbhome_2\network\admin\listener.ora
Listener Log File d:\app\shah\diag\tnslsnr\Shah-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully




Please help me how to connect developer with oracle database

Thanks in advance

Mitesh
Re: Developer 10 with oracle database 11g [message #612766 is a reply to message #612763] Thu, 24 April 2014 12:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I thought that SQL Developer used JDBC to connect to the DB & did not use tnsnames.ora

post content of tnsnames.ora file
Re: Developer 10 with oracle database 11g [message #612793 is a reply to message #612766] Thu, 24 April 2014 15:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
BlackSwan, this is not SQL Developer but Developer Suite 10g (Forms & Reports).
Re: Developer 10 with oracle database 11g [message #612845 is a reply to message #612766] Sat, 26 April 2014 02:14 Go to previous messageGo to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
yes it is developer suite 10g

please help me

regards
Mitesh Shah
Re: Developer 10 with oracle database 11g [message #612850 is a reply to message #612845] Sat, 26 April 2014 07:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know why you can't connect to the database with Forms Developer but can with SQL*Plus, if that's what your "I can able to connect oracle using user name system & with password" means. I suppose that Oracle is up and running - check it in Windows Services (Control Panel - Administrative Tools - Services) its name looks like "OracleService..." and its status should be "Started". If it is not, start it.

Which Windows 7 version do you have? Is it, by any chance, Home edition? Oracle isn't certified with any "Home" edition so that *might* be your problem, although people say that they run Oracle on Home editions without problems.
Re: Developer 10 with oracle database 11g [message #612852 is a reply to message #612850] Sat, 26 April 2014 07:42 Go to previous messageGo to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
Thanks boss for replying,

I use windows 7 ultimate version

I was able to login using sql plus inside oracle folder but not with developer folder.

oracleseviceORCL is started

Please help

Thanks,,
Re: Developer 10 with oracle database 11g [message #612857 is a reply to message #612852] Sat, 26 April 2014 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what results when you issue OS command below


sqlplus scott/tiger@orcl

post content of tnsnames.ora file
Re: Developer 10 with oracle database 11g [message #612859 is a reply to message #612857] Sat, 26 April 2014 09:21 Go to previous messageGo to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
I have typed following message in the DOS command prompt

sqlplus scott/tiger@orcl

Result is :

EEROR
ORA-28000: the account is locked
Re: Developer 10 with oracle database 11g [message #612860 is a reply to message #612859] Sat, 26 April 2014 09:22 Go to previous messageGo to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
Content of tnsnames.ora

# tnsnames.ora Network Configuration File: D:\app\Shah\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Shah-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Re: Developer 10 with oracle database 11g [message #612862 is a reply to message #612860] Sat, 26 April 2014 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-28000: the account is locked

above shows that the listener is working OK & correctly handing off the connection request to the database.

is Forms installed on the same system where the database is installed & running?
Re: Developer 10 with oracle database 11g [message #612863 is a reply to message #612862] Sat, 26 April 2014 09:56 Go to previous messageGo to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
yes form is installed in the same machine but on the c:\ drive -- where as oracle database installed on d:\ drive.
Re: Developer 10 with oracle database 11g [message #612865 is a reply to message #612863] Sat, 26 April 2014 10:03 Go to previous messageGo to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
after unlocking the scott account now i am able to connect to oracle database from forms

thanks a lot
Re: Developer 10 with oracle database 11g [message #612883 is a reply to message #612865] Sat, 26 April 2014 14:36 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's good news.

I just can't see any relation between a locked account and "ORA-12560 TNS: Protocol adapter error".
Previous Topic: About Installing
Next Topic: Not writing into REDO LOG File
Goto Forum:
  


Current Time: Fri Mar 29 03:39:05 CDT 2024