how to connect database10g to Form11g [message #458148] |
Thu, 27 May 2010 10:26 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
hii
I am install the forms11g and database10gr1 , now when you open the
form and write in login ( scott/tiger@orcl ) thise message is show
ORA-12154: TNS: could not resolve the connect identifier specified.
how to connect database10g to Form11g.....?????!!!!!!!!!!!!
I cant find the net configuration assistant same form10g .....
can you help me ......
|
|
|
|
|
Re: how to connect database10g to Form11g [message #458395 is a reply to message #458394] |
Sat, 29 May 2010 09:10 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
I am work this steps :-
first I am not find any file ( tnsnames.ora ) in form11g directory in ( C:\oracle\fmw11g\as_1\network\admin ) only find the sqlnet file .
1- create the folder 0_library and copy the tnsnames.ora in oracle database directory ( C:\oracle_dbr2\NETWORK\ADMIN ) in this folder .
2- start - run - cmd
3- c:\temp>set tns_admin=c:\0_library
4- restart the weblogic server and form11g
5- when you connect the ( scott/tiger@orcl4) in form11g the same problem ( ORA-12154: TNS: could not resolve the connect identifier specified.)
this steps is correct or not ???????
can you help me ................
|
|
|
|
Re: how to connect database10g to Form11g [message #458400 is a reply to message #458396] |
Sat, 29 May 2010 10:27 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
the content of tnsnames.ora is :-
LISTENER_ORCL4 =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
ORCL4 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl4)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-----------------------------------------
and this file in ( C:\oracle_dbr2\NETWORK\ADMIN ).. full path in my pc
I am not any change from this file ( tnsnames.ora ) only copy in folder c:\0_library
and
- start - run - cmd
- c:\temp>set tns_admin=c:\0_library
- restart the weblogic server and form11g
- when you connect the ( scott/tiger@orcl4) in form11g the same problem ( ORA-12154: TNS: could not resolve the connect identifier specified.)
this steps is correct or not ???????
can you help me ................
|
|
|
|
|
|
|
Re: how to connect database10g to Form11g [message #458625 is a reply to message #458607] |
Mon, 31 May 2010 15:07 |
gregor
Messages: 86 Registered: March 2010 Location: Germany
|
Member |
|
|
Hi aljabali,
sorry it may be ok with your Port 1522, ( 1521 is the default).
what I see from your postings is:
1- TNS_ADMIN in registry ( C:\oracle\fmw11g\asinst_1\config )
2- not find any file ( tnsnames.ora ) in form11g directory in ( C:\oracle\fmw11g\as_1\network\admin ) only find the sqlnet file
3- the content of your tnsnames.ora
4,5,6...help
7. use Port 1251
The solution is : copy your tnsnames.ora-file to C:\oracle\fmw11g\asinst_1\config -Directory, because definied in the win-registry; or define an other TNS_ADMIN-Path in the registry . "set c:\temp>set tns_admin=c:\xyz" doesn't work, because the listener works ( in windows ) as a service.
After copy, A restart of Windows .
After restart test connection with your apps.
If it doesn't work , start form the commandline (cmd.exe):
-- %ORACLE_HOME%/tnsping.exe ORCL4
Please report me, in case, a´what tnsping answers.
Greetings Gregor (in short GG)
|
|
|
|
|
|
|
Re: how to connect database10g to Form11g [message #459427 is a reply to message #459146] |
Sat, 05 June 2010 01:05 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
I am not understand .....
I have SQLNET.ORA ONLY IN DATABASE LOCATION (C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN) NOT IN FORMS11G
AND I am copy the TNSNAMES.ORA IN ( C:\oracle\fmw11g\asinst_1\config )
I am not have the SQLNET.ORA in ( C:\oracle\fmw11g\asinst_1\config )
BUT THE SAME PROBLEM ????????????????????????????????????
can you help me ......................................
|
|
|
|
|
|
Re: how to connect database10g to Form11g [message #459737 is a reply to message #459656] |
Tue, 08 June 2010 03:08 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
Ms Littlefoot thanx first
I have ( Dtabase10 r1 and Database10g r2 and Form11g )
no any problem in database10g r1 or r2 I am work in sqlplus
Did you insert it into its own directory ????
but only the problem how to connect database10g to Form11g.....?????!!!!!!!!!!!!
show the message ORA-12154: TNS: could not resolve the connect identifier specified.
|
|
|
|
Re: how to connect database10g to Form11g [message #459870 is a reply to message #459738] |
Tue, 08 June 2010 10:29 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
Ms Littlefoot thanx
show I am work all steps ....
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings>cd..
C:\>cd C:\oracle\fmw11g\as_1\bin
C:\oracle\fmw11g\as_1\bin>sqlplus scott/tiger@orcl4
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jun 8 08:30:49 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
|
|
|
|
Re: how to connect database10g to Form11g [message #459930 is a reply to message #459896] |
Wed, 09 June 2010 01:16 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
dear Ms Littlefoot thanx
show I am work all steps ....
1- I am copy the tnsnames in ( C:\oracle_dbr2\NETWORK\ADMIN )... directory of database10gr2
2- paste the tnsnames in ( C:\oracle\fmw11g\asinst_1\config ) ...directory of form11g
3- start
4- run
5- cmd
C:\>set tns_admin=C:\oracle\fmw11g\as_1\config
C:\>cd C:\oracle\fmw11g\as_1\bin
C:\oracle\fmw11g\as_1\bin>sqlplus scott/tiger@orcl4
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jun 8 23:04:48 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
The form11g tools is connect the database10g Only in Sqlplus
now when you connect the ( scott/tiger@orcl4) in form11g the same problem ( ORA-12154: TNS: could not resolve the connect identifier specified.)
and in registry I am defined the tns_admin=C:\oracle\fmw11g\asinst_1\config;
can you help me ....
C:\oracle\fmw11g\as_1\config
|
|
|
|
Re: how to connect database10g to Form11g [message #460081 is a reply to message #459931] |
Wed, 09 June 2010 09:04 |
aljabali
Messages: 53 Registered: July 2008
|
Member |
|
|
Dear Ms Littlefoot ... Thank you so much
now the my problem is solved
relay I have two different directory names (ASINST_1 vs. AS_1) its the problem in fact
but ASINST_1 as you successfully
I am change the cd command and registry ( TNS_ADMIN)
AND I am remove the tnsnames in C:\oracle\fmw11g\as_1\config
only tnsnames in C:\oracle\fmw11g\asinst_1\config
set tns_admin=C:\oracle\fmw11g\as_1\config
C:\oracle\fmw11g\as_1\bin>sqlplus scott/tiger@orcl4
Thank you so so so much
Thank you all ..........
|
|
|
|
|