| tns-name mising [message #64124] |
Fri, 17 December 2004 21:25  |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
While connecting to TP connect in SAP system gives error tns_name missing cannot connect o database.
Kindly help how to solve this problem
regards
sanjay
|
|
|
|
| Re: tns-name mising [message #64125 is a reply to message #64124] |
Fri, 17 December 2004 23:17  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi,
could you please give the more details....are u unable to connect the database or are u using any service name along with username...pls check out on your database machine whether TNAME file existing or not...
if the file is not existing then u have to create and make the entries in a file manually...
so pls get the exact details to help u better
Regards
D.Dilip
|
|
|
|
| Re: tns-name mising [message #125667 is a reply to message #64125] |
Tue, 28 June 2005 09:57 |
baran
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
Hi,
i have also the same problem. (oracle 9.2 IDES 4.7) When i start r3trans -d or -x, I become errors: ERROR => Cannot connect: TNS-name missing 750 0.118844
2EETW169 no connect possible: "DBMS = ORACLE --- TWO_TASK = ''"
Any suggestions?
regards
Baran
|
|
|
|
| Re: tns-name mising [message #125688 is a reply to message #64124] |
Tue, 28 June 2005 12:18 |
pras555
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
hi..
U have to manually edit the tnsname.ora file and listener.ora file which is loacted in ORACLE_HOME/ora92/network/admin/....
in tnsname.ora
<db_name> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sairam)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <db_name)
)
)
in listener.ora
(SID_DESC =
(GLOBAL_DBNAME = <db_name>)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = <db_name>)
)
edit these entries.....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
