| Application Connection Error [message #172103] |
Sun, 14 May 2006 22:01  |
manbote
Messages: 1
Registered: May 2006
Location: Putrajaya, Malaysia
|
Junior Member |
|
|
I always get error display below when trigger access procedure. The procedure will insert data into other database using dblink. Can any one explain why it happen and how to solve this problem.
Thank You.
***********************************************************************
Fatal OSN connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROT OCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=kaunter.exe)(HOST=POS11)(USER=n_hidayu))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 2.3.4.0.0 - Production
Time: 10-MAY-06 11:52:25
Tracing not turned on.
Tns error struct:
nr err code: 12206
TNS-12206: TNS:received a TNS error during navigation
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
TNS-00517: Lost contact
nt secondary err code: 0
nt OS err code: 0
|
|
|
|
| Re: Application Connection Error [message #172280 is a reply to message #172103] |
Mon, 15 May 2006 15:26  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Database links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases.
then lsnrctl reload
2) create a public database link on the local database:
As sys (or a user that can create dblinks):
CREATE PUBLIC DATABASE LINK <choose a name>
CONNECT TO LINKUSER
IDENTIFIED BY <a valid password>
USING '<a service name in your tnsnames.ora file that points to the remote database>';
3) On the remote database, create a user for the link to use:
CREATE USER LINKUSER IDENTIFIED BY <the valid password above>
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE <an appropriate profile>
ACCOUNT UNLOCK;
4) GRANT CONNECT TO <the chosen link name above>;
or perhaps
grant create session to linkuser;
Also make sure the tables and column names called in the trigger are valid ones.
[Updated on: Mon, 15 May 2006 15:29] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
