Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-12154: tns:could not resolve the connect identifier specified

Tony007Mar 31 2012 — edited Mar 31 2012
hi i have install my oracle form 11g release 2 in my window xp when i try to log in to my database in my form builder i get the above error ora-12154: tns:could not resolve the connect identifier specified but am able to log in to my database with sql*plus without any problem and when i log in using my oracle 10g form builder i dont have problem,and before my 11g form builder start i get the error frm-18122:Oracle Forms Debugger failed to Initialize my set is ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Desmond\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=MADIMAD-B533821
ComSpec=C:\WINDOWS\system32\cmd.exe
FORMS90_PATH=C:\forms
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Desmond
LD_LIBRARY_PATH=C:\Oracle\Middleware\Oracle_FRHome1\lib
LOGONSERVER=\\MADIMAD-B533821
NUMBER_OF_PROCESSORS=2
ORACLE_HOME=C:\product\11.2.0\dbhome_1
OS=Windows_NT
Path=C:\product\11.2.0\dbhome_1;C:\product\11.2.0\dbhome_1\bin;C:\forms;C:\DevSu
iteHome_1\BIN;C:\DevSuiteHome_1\jlib;C:\Oracle\Middleware\Oracle_FRHome1\bin;C:\
Program Files\PHP;C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32
;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Roxio Shared\
DLLShared;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Program Files\
Common Files\Roxio Shared\9.0\DLLShared;C:\Program Files\Common Files\DivX Share
d;c:\Program Files\Java\jdk1.6.0_21\bin;C:\product\11.2.0\dbhome_1\BIN;C:\DevSui
teHome_1;C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared;C:\Program Fi
les\Common Files\Roxio Shared\DLLShared;C:\Program Files\Common Files\Roxio Shar
ed\10.0\DLLShared;C:\mywls;C:\mydomain\base_domain\bin;C:\Program Files\Java\jre
6\bin\client;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jdk1.6.0_21\jr
e\bin;C:\Program Files\Java\jdk1.6.0_21\bin;C:\Program Files\Java\jdk1.6.0_21;C:
\Program Files\Java\jre6;C:\DevSuiteHome_1\forms;C:\DevSuiteHome_1\cgenf61\admin
;C:\DevSuiteHome_1\forms;C:\forms\sms_code.pll;C:\mywls\wlserver\bin;C:\Java\jdk
1.6.0_21;C:\Oracle\Middleware\Oracle_FRHome1\opmn\bin;C:\Oracle\Middleware\Oracl
e_FRHome1\opmn\lib;C:\Oracle\Middleware\Oracle_FRHome1\perl\bin;C:\product\11.2.
0\dbhome_1
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PHPRC=C:\Program Files\PHP\
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 10, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=170a
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\Desmond\LOCALS~1\Temp
TMP=C:\DOCUME~1\Desmond\LOCALS~1\Temp
USERDOMAIN=MADIMAD-B533821
USERNAME=Desmond
USERPROFILE=C:\Documents and Settings\Desmond

and my default.env is
# $Id: default.env 14-apr-2005.13:22:43 pkuhn Exp $
# default.env - default Forms environment file, Windows version
#
# This file is used to set the Forms runtime environment parameters.
# If a parameter is not defined here, the value in the Windows registry
# will be used. If no value is found in the registry, the value used will
# be that defined in the environment in which the servlet engine (OC4J
# or JServ) was started.
#
# NOTES
# 1/ The Forms installation process should replace all occurrences of
# <percent>FORMS_ORACLE_HOME<percent> with the correct ORACLE_HOME
# setting, and all occurrences of <percent>O_JDK_HOME<percent> with
# the location of the JDK (usually $ORACLE_HOME/jdk).
# Please make these changes manually if not.
# 2/ Some of the variables below may need to be changed to suite your needs.
# Please refer to the Forms documentation for details.
#
ORACLE_HOME=C:\DevSuiteHome_1

#
# Search path for Forms applications (.fmx files, PL/SQL libraries)
# If you need to include more than one directory, they should be semi-colon
# separated (e.g. c:\test\dir1;c:\test\dir2)
#
FORMS_PATH=C:\forms;C:\DevSuiteHome_1\forms;C:\work\forms;C:\DevSuiteHome_1\forms\server;C:\DevSuiteHome_1\forms

# webutil config file path
WEBUTIL_CONFIG=C:\DevSuiteHome_1\forms\server\webutil.cfg

# Disable/remove this variable if end-users need access to the query-where
# functionality which potentially allows them to enter arbitrary SQL
# statements when in enter-query mode.
FORMS_RESTRICT_ENTER_QUERY=TRUE

#
# The PATH setting is required in order to pick up the JVM (jvm.dll).
# The Forms runtime executable and dll's are assumed to be in
# C:\DevSuiteHome_1\bin if they are not in the PATH.
# In addition, if you are running Graphics applications, you will need
# to append the following to the path (where <Graphics Oracle Home> should
# be replaced with the actual location of your Graphics 6i oracle_home):
#
# ;<Graphics Oracle Home>\bin;<Graphics Oracle Home>\jdk\bin
#

PATH=C:\DevSuiteHome_1\bin;C:\DevSuiteHome_1\jdk\jre\bin\client;C:\work\forms;C:\DevSuiteHome_1\forms\server;C:\Oracle\Middleware\Oracle_FRHome1\bin
UI_ICON=C:\DevSuiteHome_1\reports\plugins\resource;C:\Documents and Settings\Administrator\My Documents\My Templates\Icons\ico-files;C:\work\icons


#
# Settings for Graphics
# -------------------------------
# NOTE: These settings are only needed if Graphics applications
# are called from Forms applications. In addition, you will need to
# modify the PATH variable above as described above.
#

#
# Please uncomment the following and put the correct 6i
# oracle_home value to use Graphics applications.
#
RACLE_GRAPHICS6I_HOME=C:\DevSuiteHome_1\reports\plugins\resource;C:\Documents and Settings\Administrator\My Documents\My Templates\Icons\ico-files;C:\work\icons

#
# Search path for Graphics applications
#
GRAPHICS60_PATH=C:\DevSuiteHome_1\reports\plugins\resource;C:\Documents and Settings\Administrator\My Documents\My Templates\Icons\ico-files;C:\work\icons

#
# Settings for Forms tracing and logging
# -----------------------------------------------
# Note: This entry has to be uncommented to enable tracing and
# logging.

#FORMS_TRACE_PATH=<FORMS_ORACLE_HOME>\forms\server


#
# System settings
# ---------------
# You should not normally need to modify these settings
#
FORMS=C:\DevSuiteHome_1\forms


#
# Java class path
# This is required for the Forms debugger
# You can append your own Java code here)
# frmsrv.jar, repository.jar and ldapjclnt10.jar are required for
# the password expiry feature to work(#2213140).
#
CLASSPATH=C:\DevSuiteHome_1\BIN;C:\DevSuiteHome_1\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;C:\DevSuiteHome_1\jlib\repository.jar;C:\DevSuiteHome_1\jlib\ldapjclnt10.jar;C:\DevSuiteHome_1\jlib\debugger.jar;C:\DevSuiteHome_1\jlib\ewt3.jar;C:\DevSuiteHome_1\jlib\share.jar;C:\DevSuiteHome_1\jlib\utj.jar;C:\DevSuiteHome_1\jlib\zrclient.jar;C:\DevSuiteHome_1\reports\jlib\rwrun.jar;C:\DevSuiteHome_1\forms\java\frmwebutil.jar;C:\Oracle\Middleware\Oracle_FRHome1\bin;C:\oracle\Middleware\Oracle_FRHome1\forms
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2012
Added on Mar 31 2012
6 comments
2,573 views