dispatcher mode and question about database link

[Guest]

What is a dispatcher connection.

When I want to stop database,it give such an error message,
said becuase of connected by dispatcher mode,
can no stop database.

and another question about database link.
I have done a databaselink last week,
but I found database link is not active now.
how to enactive it?

I thought synonym should be established on database link,
but although my database link became unactive,
the synonym can be used normally.
Can you tell me why?

I don't know very much about database link.

[Tim...]

Hi.

When using shared server you are actually connectind to the database via a dispatcher. You probably won't notice a difference for the most part, but there are some operations you cannot perform, like shutdown/startup from this type of connection. For these you need a dedicated connection.

The database link should still be OK provided you are logged in as the user who created it (unless it is a public database link). The usual reason for them not working is that the password of the remote user has changed and the link has not been updated to reflect this.

If the synonym points to a table via a database link and you can use the synonym, then the database link must be working. My guess is you are not using the synonym correctly when you are testing it. Try something like:

desc user_tables@dblink

Where dblink is the name of your database link.

Cheers

Tim...

[Guest]

Tim, thanks very much.

I know the reason.
I checked the state of database link by OEM last time,
I created the database link with account acc1,
but connected database with account acc2,
So the database link seems not active.
When I changed back to account acc2,it became active.

It's just my miss.

I also tested it.
desc testtable@dblink,

It works well.

[Tim...]