dispatcher mode and question about database link

All posts relating to Oracle database administration.

Moderator: Tim...

dispatcher mode and question about database link

Postby Guest » Mon Nov 01, 2004 6:09 pm

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.
Guest
 

RE:dispatcher mode and question about database link

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE:dispatcher mode and question about database link

Postby Guest » Mon Nov 01, 2004 6:09 pm

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.
Guest
 

RE:dispatcher mode and question about database link

Postby Tim... » Mon Nov 01, 2004 6:09 pm

;-)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests

cron