Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1071
  • Last Modified:

DBID

Hey how can I change DBID for oracle databases. I really appreciate your help. Thanks in advance
0
hussainkhan22
Asked:
hussainkhan22
  • 8
  • 6
2 Solutions
 
slightwv (䄆 Netminder) Commented:
0
 
hussainkhan22Author Commented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
slightwv (䄆 Netminder) Commented:
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
 
hussainkhan22Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
Check your versions....

nid you ran was 9.2 and the database is possibly 10gR2?
0
 
slightwv (䄆 Netminder) Commented:
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
 
hussainkhan22Author Commented:
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
 
hussainkhan22Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
>>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
 
slightwv (䄆 Netminder) Commented:
Try without the dbalias nw that the path is correct:  nid target=/
0
 
hussainkhan22Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
>>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
 
hussainkhan22Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
I never reopened it so it's fine.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now