![]() |
|
|
| Subject:
Ora:12560 TNS Protocol adapter error; Oracle 9.2.0.1.0 personal edition & DS R2
Category: Computers Asked by: sknikam-ga List Price: $5.00 |
Posted:
30 Oct 2003 12:49 PST
Expires: 30 Oct 2003 19:42 PST Question ID: 271226 |
System Description: Windows 2000 service pack 4, RAM 256MB First I installed the personal edition of oracel 9i release 2 (9.2.0.1.0) on the system. the installation went off smoothly. I can connect to the database using SQL plus. I can create tables etc. I can connect to thej database using the followinf username/pwd : dbuser/oracle system/oracle (NOT system/manager) scott/tiger Then I installed Oracle developer suite 9i release 2 on the system. the installation was completed successfully. Then I opened the forms developer program and tried to RUN a forms builder application.The first time it asked me to log in to the database. I logged in using the "dbuser/oracle" username/pwd combination. Then it went thru the Java Initiator procedure. After this the web browser was started and the applet was initialized. and then suddenly there is a popup box ie. a connect dialog box with an error message at the top. The error message is as follows ORA:12560 TNS protocol adapter error the dialog box has <DBUSER> in the "Connect as" field. when i re-enter the password , it again displays the same error message. if i enter the oracle database service SID i.e. "orcl" in my case it displays again the same Connect dialog box with the following error message ORA:12514 unable to resolve service name i followed the instructions given at the bottom of the following link for installing both the database and the developer suite http://www.course.com/cdkit/installinstructionsguideto9i.cfm after searching thru web i set the TNS_ADMIN environmental variable as follows TNS_ADMIN=C:\oracle\Oradev\network\admin;C:\oracle\po92\network\admin but even this did not work. Also i changed the loopback IP address in the file C:\oracle\Oradev\network\admin\tnsnames.ora from 127.0.0.1 to the name of my machine i.e. oracle2. even this did not work. Please let me know if u have u any specific steps tht i can follow to fix this problem. thank you |
|
| There is no answer at this time. |
|
| Subject:
Re: Ora:12560 TNS Protocol adapter error; Oracle 9.2.0.1.0 personal edition & DS R2
From: al_gupta-ga on 30 Oct 2003 16:26 PST |
Easiest thing to do. is edit the tnsnames.ora file in
C:\oracle\Oradev\network\admin. Add this alias
myDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME=orcl)
)
)
assuming that "orcl" is your SID. Please confirm the port also.
default is 1521 but you can change it also. ( i assumed you havn't
changed it) Try this if it doen't work put the same thing in
tnsnames.ora file in C:\oracle\po92\network\admin. Now you this alias
"myDB" while it asks the username, password and service_name. I have
faced this problem. Reason for happening is because of ORACLE_HOME in
you registry file. You can edit that too to make sure where it should
point to. Ideally TNS_ADMIN should solve it, but at times on windows
machine it creates problem. If this thing doesn't please let me know
the values in sqlnet.ora file at same location (
C:\oracle\po92\network\admin and C:\oracle\Oradev\network\admin ).
Thanks
Alok |
| Subject:
Re: Ora:12560 TNS Protocol adapter error; Oracle 9.2.0.1.0 personal edition & DS R2
From: al_gupta-ga on 30 Oct 2003 16:27 PST |
I don;t how to answer a question. That's why i added it as comment. hope it helps. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |