Solved

DBID

Posted on 2010-11-30
15
1,042 Views
Last Modified: 2012-05-10
Hey how can I change DBID for oracle databases. I really appreciate your help. Thanks in advance
0
Comment
Question by:hussainkhan22
  • 8
  • 6
15 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 34239700
0
 
LVL 6

Assisted Solution

by:anumoses
anumoses earned 250 total points
ID: 34239726
0
 

Author Comment

by:hussainkhan22
ID: 34239934
If I change DBID will it effect anything. If I duplicate the database with same database name. Does it have same DBID or new one.
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34239947
The docs talk all about this.

If you do not change it, it has the same DBID.  If done properly it should not effect anything.
0
 

Author Comment

by:hussainkhan22
ID: 34240245
C:\Documents and Settings\Administrator>nid target=/
DBNEWID: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

Connected to database ORACLE10 (DBID=2466766045)

Control Files in database:
    C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE10\CONTROL01.CTL
    C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE10\CONTROL02.CTL
    C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE10\CONTROL03.CTL

Change database ID of database ORACLE10? (Y/[N]) => y

Proceeding with operation
Changing database ID from 2466766045 to 2468335534

NID-00107: File I/O error on datafile "C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE10
\CONTROL01.CTL" during block 1 offset operation (27047/kunidb1c)


Change of database ID failed during validation - database is intact.
DBNEWID - Completed with validation errors.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34240256
Check your versions....

nid you ran was 9.2 and the database is possibly 10gR2?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34240281
This is the problem with getting all your answers from a site like this and not taking the time to read the docs and actually learn.

You've asked enough questions about multiple Oracle homes that selecting the correct ORACLE_HOME and PATH should no longer be an issue.
0
 

Author Comment

by:hussainkhan22
ID: 34240315
C:\Documents and Settings\Administrator>nid target=sys/sys@oracle10
DBNEWID: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.


NID-00106: LOGIN to target database failed with Oracle error:
ORA-12541: TNS:no listener



Change of database ID failed during validation - database is intact.
DBNEWID - Completed with validation errors.
0
 

Author Comment

by:hussainkhan22
ID: 34240370
C:\oracle\product\10.2.0\db_1\BIN>set ORACLE_SID=oracle10

C:\oracle\product\10.2.0\db_1\BIN>set ORACLE_HOME=c:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1\BIN>nid target=sys/sys@oracle10

DBNEWID: Release 10.2.0.1.0 - Production on Tue Nov 30 10:53:20 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


NID-00106: LOGIN to target database failed with Oracle error:
ORA-12170: TNS:Connect timeout occurred



Change of database ID failed during validation - database is intact.
DBNEWID - Completed with validation errors.


Shall I open this in another question as I have already closed this question without testing
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34240469
>>Shall I open this in another question as I have already closed this question without testing

No.  That would be a duplicate question.  We can either continue like this or I can reopen this question if you wish.

Give me a minute on the error.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34240483
Try without the dbalias nw that the path is correct:  nid target=/
0
 

Author Comment

by:hussainkhan22
ID: 34240789
i HAVE MULTIPLE ORACLE HOME AND DATABASE. So nid target=/ will make problem that is why I was trying with nid target=sys/sys@oracle10 and getting the above error
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34240840
>>So nid target=/

This will connect to the instance set by ORACLE_SID.  Verify the SID is correct and please try it.

>>getting the above error

The timeout error can be caused by a few things but it is typically caused by a firewall issue.  

Verify the ipaddress/host for oracle10 in your tnsnames.ora and listener.ora files and make sure everything is set up properly.
0
 

Author Comment

by:hussainkhan22
ID: 34241570
I have everything on a single laptop. so It is not necessary to verify ipaddress for listener or tnsnames.ora file right. Anyway its working fine with nid target=/. so do I need to close the question again or just leave it
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34241709
I never reopened it so it's fine.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
installing docker on ubuntu 6 29
AWS ELB 5 79
remove one line from a file in solaris 8 29
Create file system directory from Oracle 10g 4 14
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question