i am trying to set up a very simple streams flow from one db1 to db2. when i am creating a private dblink from db1 to db2 with the stream-admin user, the dblink is showing as not active.
in the init.ora file for both db1 and db2 i have kept the global_names = TRUE and i have kept the dblink name as db2.
can anyone plzz tell me where am i going wrong.
actually after doing the Stream Admin set-up on both the db1(pdsource) and db2(uii.world), i wanted to test the dblink thru OEM, where i am getting this.
but Nir, one thing i want to mention here - don't know whether it is relevant or not.
i have set up the db "pdsource" in my pc yes'day thru the OEM - the TNS entry for this comes like
another thing, i am creating this dblink with stream-admin user and it is a private dblink - that's what the setup demands i guess - what if i create it as public with my schema user of "pdsource" ??? - but don't know whether the streams will work or not.
actually was referring to the doc -
check your sqlnet.ora parameter names.default_domain value..
and post your db link creation script, does the domain name appended
in your dblink name? You can also post errorcodes as what nir_s have asked.
can use just use your database alias in your tnsnames.ora instead
of that whole description in that USING statement?
what is the db link created when you query DB_LINK in either user_db_links or dba_db_links?