Home » RDBMS Server » Networking and Gateways » Oracle forms login problem
Oracle forms login problem [message #447751] Wed, 17 March 2010 13:54 Go to next message
aa321
Messages: 7
Registered: March 2010
Junior Member
it asked me to log on, i typed:
Username: oracle, Password: password, Database: orcl

i get the error, TNS: could not resolve the connect identifier specifiec

Can please some1 help

Thanks

This is wat my files says

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.93.130)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Re: Oracle forms login problem [message #447753 is a reply to message #447751] Wed, 17 March 2010 13:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: "TNS:could not resolve the connect identifier specified"
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.

Check default_domain of your sqlnet.ora.

Regards
Michel

[Updated on: Wed, 17 March 2010 13:57]

Report message to a moderator

Re: Oracle forms login problem [message #447758 is a reply to message #447753] Wed, 17 March 2010 14:36 Go to previous messageGo to next message
aa321
Messages: 7
Registered: March 2010
Junior Member
I have gone through the list everything looks fine.

I dont understand this bit:

"Check default_domain of your sqlnet.ora"

My files are:

# tnsnames.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.130)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.130)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


# sqlnet.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)


NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
Re: Oracle forms login problem [message #447762 is a reply to message #447758] Wed, 17 March 2010 14:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)

Do you really use all these ones?
If you only use tnsname then keep only this one.

Check if you have a TNS_ADMIN variable set or explicitly set it to the directory containing your tnsnames.ora.

Regards
Michel
Re: Oracle forms login problem [message #447764 is a reply to message #447762] Wed, 17 March 2010 14:57 Go to previous messageGo to next message
aa321
Messages: 7
Registered: March 2010
Junior Member
Ok removed it, when i installed the suite it was already like that.

Sorry i dont understand by what you mean by:

Check if you have a TNS_ADMIN variable set or explicitly set it to the directory containing your tnsnames.ora.


Also the TNSnames.ora do they both have to be the same in the

C:\DevSuiteHome_1\NETWORK\ADMIN
&
C:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN

?

Thanks
Re: Oracle forms login problem [message #447766 is a reply to message #447764] Wed, 17 March 2010 15:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't know which one is used, yes they have to be the same as well as sqlnet.ora.

TNS_ADMIN is an environment variable that points to the directory containing your network configuration files.

Regards
Michel
Re: Oracle forms login problem [message #447767 is a reply to message #447766] Wed, 17 March 2010 15:15 Go to previous messageGo to next message
aa321
Messages: 7
Registered: March 2010
Junior Member
These are my current files at the moment:

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.130)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.130)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

------------------------------------------------------------
# sqlnet.ora Network Configuration File: C:\app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)


NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

------------------------------------------------

# listener.ora Network Configuration File: C:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.130)(PORT = 1521))
)
)

# tnsnames.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.130)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.130)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
---------------------------------------------------------
# sqlnet.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)


NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES)
------------------------------------------------------------

When i try : TNSping orcl in CMD

I get the error : failed to resolve name

Could the problem be caused by this?
Re: Oracle forms login problem [message #447768 is a reply to message #447767] Wed, 17 March 2010 15:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In CMD, post SET

Regards
Michel
Re: Oracle forms login problem [message #447769 is a reply to message #447768] Wed, 17 March 2010 15:30 Go to previous messageGo to next message
aa321
Messages: 7
Registered: March 2010
Junior Member
shall i type set in CMD?
Re: Oracle forms login problem [message #447774 is a reply to message #447769] Wed, 17 March 2010 15:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Oracle forms login problem [message #447775 is a reply to message #447774] Wed, 17 March 2010 15:53 Go to previous messageGo to next message
aa321
Messages: 7
Registered: March 2010
Junior Member
C:\Documents and Settings\Administrator>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=Aa-05B1525E28
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Administrator
LOGONSERVER=\\Aa-05B1525E28
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\app\Administrator\product\11.1.0\db_1\bin;C:\DevSuiteHome_1\jdk\jre\bin\
classic;C:\DevSuiteHome_1\jdk\jre\bin;C:\DevSuiteHome_1\jdk\jre\bin\client;C:\De
vSuiteHome_1\jlib;C:\DevSuiteHome_1\bin;C:\DevSuiteHome_1\jre\1.4.2\bin\client;C
:\DevSuiteHome_1\jre\1.4.2\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System3
2\Wbem a ; C:\Documents and Settings\Administrator\Desktop\aircrack-ng-1.0-win\b
in
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0d
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERDOMAIN=Aa-05B1525E28
USERNAME=Administrator
USERPROFILE=C:\Documents and Settings\Administrator
windir=C:\WINDOWS
Re: Oracle forms login problem [message #447776 is a reply to message #447775] Wed, 17 March 2010 15:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORACLE_HOME is not set so tnsping can't work.

SET ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1
tnsping orcl

If it does not work (I wonder why it could not), retry with:

SET TNS_ADMIN=C:\app\Administrator\product\11.1.0\db_1\network\admin

Regards
Michel
Re: Oracle forms login problem [message #447785 is a reply to message #447776] Wed, 17 March 2010 17:00 Go to previous messageGo to next message
aa321
Messages: 7
Registered: March 2010
Junior Member
Hi

Would you be able to fix it by using teamviewer to look at my machine because i need to hand in an assigment but cannot get it to work please.
Re: Oracle forms login problem [message #447794 is a reply to message #447785] Wed, 17 March 2010 23:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry I don't understand your post.
Did you fix it or not?

Regards
Michel
Re: Oracle forms login problem [message #447810 is a reply to message #447794] Thu, 18 March 2010 01:53 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member


Quote:
Sorry I don't understand your post.
Did you fix it or not?

Regards
Michel


@Michel He/She wants you to connect his system(computer) using "teamviewer" and fix His problem.

sriram Smile
Previous Topic: Connect time fail over
Next Topic: Db links issues..
Goto Forum:
  


Current Time: Mon Nov 04 11:03:43 CST 2024