Home » RDBMS Server » Networking and Gateways » Can not connect to the designer & Developer (Suite10 ______Windows)
icon5.gif  Can not connect to the designer & Developer [message #426664] Sun, 18 October 2009 07:05 Go to next message
sfd221
Messages: 11
Registered: May 2008
Junior Member
I install Ora10g & Dev Suite10 on my computer.
I can Conn to Database whit Sql plus and PLSql Developer But I can't conn to database by Designer or Devloper.
PLEASE HELP ME To RESOLVE MY PROBLEM.
Re: Can not connect to the designer & Developer [message #426776 is a reply to message #426664] Mon, 19 October 2009 10:02 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
But I can't conn to database by Designer or Devloper.
PLEASE HELP ME To RESOLVE MY PROBLEM.


Okay. We'll help you on this. Did you fell without posting any error detalis if possible to fix your issue?

Post the error details.

- Babu
Re: Can not connect to the designer & Developer [message #426786 is a reply to message #426664] Mon, 19 October 2009 11:22 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I suspect that solution has something to do with your TNSNAMES.ORA file(s). Please, search the board for TNS_ADMIN environment variable and the way it is used.
Re: Can not connect to the designer & Developer [message #426982 is a reply to message #426776] Tue, 20 October 2009 08:17 Go to previous messageGo to next message
sfd221
Messages: 11
Registered: May 2008
Junior Member
ERROR Code :
ORA-12154: TNS:could not resolve service name
RME-00220: Failed to connect to Repository

I changed Designer's TNS path in registry (as same as oracle Tns path).
I really confused about of this: SQL Pluse & Net manager & Net Configuration Assistant & Oracle EM connect to my data base but Form builder and Designer don't connect. (I didn't had same problem with dev&des 6i)


please help me
Re: Can not connect to the designer & Developer [message #426985 is a reply to message #426982] Tue, 20 October 2009 08:39 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


echo %TNS_ADMIN%

echo %PATH%

set

tnsping <<connection identifier>>


Post output of the above command.

-Babu
Re: Can not connect to the designer & Developer [message #427006 is a reply to message #426985] Tue, 20 October 2009 09:55 Go to previous message
sfd221
Messages: 11
Registered: May 2008
Junior Member
*************************************
*************************************
M:\Documents and Settings\sfd222>ECHO %TNS_ADMIN%
%TNS_ADMIN%
**************************************
**************************************
M:\Documents and Settings\sfd222>ECHO %PATH%
F:\DevDes\bin;F:\oracle\product\10.1.0\db_1\bin;F:\oracle\product\10.1.0\db_1\jr
e\1.4.2\bin\client;F:\oracle\product\10.1.0\db_1\jre\1.4.2\bin;F:\DevSuiteHome_1
0\jdk\jre\bin\classic;F:\DevSuiteHome_10\jdk\jre\bin;F:\DevSuiteHome_10\jdk\jre\
bin\client;F:\DevSuiteHome_10\jlib;F:\DevSuiteHome_10\bin;F:\DevSuiteHome_10\jre
\1.1.8\bin;F:\Ora-Suite-9\jlib;F:\Ora-Suite-9\bin;M:\Program Files\Oracle\jre\1.
1.8\bin;M:\Program Files\Oracle\jre\1.3.1\bin;M:\WINDOWS\system32;M:\WINDOWS;M:\
WINDOWS\System32\Wbem;F:\DevDes\jdk\bin

********************************************
********************************************
********************************************
M:\Documents and Settings\sfd222>SET
ALLUSERSPROFILE=M:\Documents and Settings\All Users
APPDATA=M:\Documents and Settings\sfd222\Application Data
CLIENTNAME=Console
CommonProgramFiles=M:\Program Files\Common Files
COMPUTERNAME=FADAEI-XP
ComSpec=M:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=D:
HOMEPATH=\Documents and Settings\sfd222
LOGONSERVER=\\DC-BACK
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=F:\DevDes\bin;F:\oracle\product\10.1.0\db_1\bin;F:\oracle\product\10.1.0\db
_1\jre\1.4.2\bin\client;F:\oracle\product\10.1.0\db_1\jre\1.4.2\bin;F:\DevSuiteH
ome_10\jdk\jre\bin\classic;F:\DevSuiteHome_10\jdk\jre\bin;F:\DevSuiteHome_10\jdk
\jre\bin\client;F:\DevSuiteHome_10\jlib;F:\DevSuiteHome_10\bin;F:\DevSuiteHome_1
0\jre\1.1.8\bin;F:\Ora-Suite-9\jlib;F:\Ora-Suite-9\bin;M:\Program Files\Oracle\j
re\1.1.8\bin;M:\Program Files\Oracle\jre\1.3.1\bin;M:\WINDOWS\system32;M:\WINDOW
S;M:\WINDOWS\System32\Wbem;F:\DevDes\jdk\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=F:\oracle\product\10.1.0\db_1\perl\lib\5.6.1\MSWin32-x86;F:\oracle\prod
uct\10.1.0\db_1\perl\lib\5.6.1;F:\oracle\product\10.1.0\db_1\perl\5.6.1\lib\MSWi
n32-x86;F:\oracle\product\10.1.0\db_1\perl\site\5.6.1;F:\oracle\product\10.1.0\d
b_1\perl\site\5.6.1\lib;F:\oracle\product\10.1.0\db_1\sysman\admin\scripts
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 4 Stepping 1, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0401
ProgramFiles=M:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=D:
SystemRoot=M:\WINDOWS
TEMP=M:\DOCUME~1\sfd222\LOCALS~1\Temp
TMP=M:\DOCUME~1\sfd222\LOCALS~1\Temp
USERDNSDOMAIN=KPC-IR.COM
USERDOMAIN=***
USERNAME=sfd222
USERPROFILE=M:\Documents and Settings\sfd222
windir=M:\WINDOWS

M:\Documents and Settings\sfd222>
Previous Topic: Ora-12547
Next Topic: ORA- 12154: TNS:Could not Resolve the service name
Goto Forum:
  


Current Time: Thu Mar 28 04:54:54 CDT 2024