Home » RDBMS Server » Server Administration » Re: error:ORA-12154
Re: error:ORA-12154 [message #49628] Thu, 31 January 2002 12:15
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi

The problem may be global_names parameter.
From any one of those databases try

SQL> select name, value from v$parameter where
name = 'global_names';

if you get True.

then you have to name your db links exactly as the global name of your db
in your case it might be..

SQL> CREATE DATABASE LINK OPEN2.world
2 CONNECT TO OPC_OP IDENTIFIED BY OPC_OP
3 USING 'OPEN2'

Or other wise you can reset that parameter to False and then use your original syntax

SQL> alter system set global_names = False;

Bala.
Previous Topic: Re: Howto determine which archive log is currently being written to?
Next Topic: internal password of database
Goto Forum:
  


Current Time: Tue Dec 24 10:59:14 CST 2024