![name change aion database name change aion database](https://static.wikia.nocookie.net/aion/images/1/14/Prorite.png)
What we wanted now was to remove the COMPANY.COM domain name from the global_name. This is where our issues start and we cannot revert. Now we will try to create a database link without the domain name (LOG OUT and log in again as a normal user):ĭba_tzhluma3> create database link malu connect to dba_tzhluma3 identified by XXXXX using 'DMAN01' ĭba_tzhluma3> select db_link from user_db_links SQL> alter database rename global_name to Setting the global name was done like this:Ĭd /tmp sudo -u oracle sqlplus "/ as sysdba" * We had issues in applications with hardcoded db link names (not using the domain name). (google on: alter database rename global_name "database link name expected")īut first a short walk through the issue:ġ) When assigning a domain name to a GLOBAL_NAME, we encountered issues Then I started doing some targeted searches. > sudo -u oracle strings system01.dbf | grep -i company > sudo -u oracle strings control01.ctl | grep -i $ I sort of got to the solution by grepping for our domain name in the system01.dbf datafile, which sort of got me into the idea that the domain name is NOT in the control file, but rather in a $ I would like to file this as a BUG, or is it really meant to be so that I will not be able to remove a domain name from the GLOBAL_NAME?Īlso, DROP DATABASE LINK seems to fetch this domain name concatenating it to the database link name when I try to drop a database link that was created before the change of GLOBAL_NAME.
#Name change aion database trial
Well, I sort of got a bit upset and spent some time to find a workaround, which I found after a couple of hours of googling and trial and error, which in the end was just anĪs the sys user, which was the only workaround I could find, which allowed me to remove the domain name completely.įollowing my step by step description below should reproduce the problem. TNS for HPUX: Version 10.2.0.3.0 - Production Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
![name change aion database name change aion database](https://i.ytimg.com/vi/kyJ8kaJoOsI/maxresdefault.jpg)
We are running Oracle 10.2.0.3 on select banner from v$version We had some weird issues with this, and just could not revert the configuration after giving a database a GLOBAL_NAME with a domain name.Īfter setting this, encountering really weird issues, reverting and go back to the way it was before was not possible, as we could not get rid of the domain name, and old database links that we had created was not possible to delete. I don't have this domain in my SQLNET.ORA. I cannot understand where it comes create database link test connect to test identified by test using select * from show parameter db_domain I've tried to create some DB links and they are created with this long domain also. And what is happening conn sys as sysdba Įnter password: select * from alter database rename global_name to select * from have tried to conn sys as sysdba Įnter password: select * from the alert log I can see the following:Ĭompleted: alter database rename global_name to rexīut obviously nothing has happened. During the installation, I specified database name to be 'rex'.
#Name change aion database windows
I have just installed Oracle 10.2.0.1.0 on Windows XP. I have a strange problem while trying to change GLOBAL_NAME. SLOG$ has snapshot owner, name, and snapid, but notĬurrently, if I do a complete refresh in OJA8 I can't do a fast refresh in OJAS. Will the above proc call cause a problem in the SLOG$ table? I took flag and snapshot id from SNAP$ in OJAS Snapshot_id => 119, - that's the value in OJAS OJA8.WORLD is the original, production DB Nvl(r.snapshot_site, 'not registered') snapsite,įrom sys.slog$ s, dba_registered_snapshots r There's a query, mview_reg_info.sql, which I ran on the Master site: Thanks, I learning more about the master site Will it work if I leave the snapshots as is? Or Do I pretty much have to drop and recreate them? Now, if I want the snapshot_site to be the same as the global_name, how do I do that? The snapshots are internal (i.e. MSC_BIS_RES_DATE_MV INST816.US.ORACLE.COM MSC_BIS_INV_DATE_MV INST816.US.ORACLE.COM SQL> SELECT NAME, SNAPSHOT_SITE from DBA_REGISTERED_SNAPSHOTS Set global_name = 'DVLP.US.MYCOMPANYNAME.COM' Īlter database rename global_name to. Will it cause any problems if I set the GLOBAL_NAME as follows Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production