RAC instance to re-build libraries and declarations errors and solutions.

Jan 14 posted in Oracle (RSS), 86 views.
Re-establish the ASM instance
1, stop instances.

[oracle @ ora2 ~] $ srvctl stop asm-n ora1
[oracle @ ora2 ~] $ srvctl stop asm-n ora2

2, remove the service
[oracle @ ora2 ~] $ srvctl remove asm-n ora1
[oracle @ ora2 ~] $ srvctl remove asm-n ora2

3, delete the configuration file, in the two nodes to run

[oracle @ ora2 ~] $ rm-f $ ORACLE_HOME / dbs / * ASM *
[oracle @ ora2 ~] $ rm-fr $ ORACLE_BASE / admin / * ASM * 4, delete the / etc / oratab examples of registration, in the two nodes to run. Remove about it, of which + ASM instance starts for asm.

+ ASM2: / u01/app/oracle/product/10.2.0/db_1: N 5, create asm instance using the dbca to re-create.
If you do not clean up / etc / oratab content, will be under construction asm instance holds about errors:

The ASM instance configured on the local node is a single-instance ASM.To create a single-instance database using this ASM instance, restart DBCA and select the single-instance database option, to create a RAC database using this ASM instance, convert it to RAC ASM first.
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of RAC instance to re-build libraries and declarations errors and solutions.

  • ORACLE10G full version centos5 installed (the installation has passed)

    ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...

  • SGA extended the principle of 32bit oracle

    SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...

  • AX3.0 + Oracle 10G RAC installation

    During these two days, you installed RAC, in a virtual machine inside, with a full day, there have been some questions on his way. Now have their own solution. In fact, it is loaded, it is easy, as long as planned, carefully point on OK, the trouble ...

  • High Availability Oracle Flashback

    Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...

  • An example of the use of TKPROF

    First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE

  • Diagnosis and principles of order

    SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...

  • ORACLE 10G dataguard configuration Step by Step

    oracle dataguard

Leave a Reply

Recent
Recent Entries
Tag Cloud
disconnect from db_link db_keep_cache_size script monitor sql oracle adduser sql apex boot stop sqlplus   initialization parameter files oracle 9i Centos 5 install guide sqlplus in windows batch job command delete data from blob table GROUP BY IN DELETE STATEMENT ORACLE how to monitor oracle truncate rep 501 sometimes how convert integer to string in powerbuilder 10 SKGXP AIX ORACLE_HOME 11.2 variable Windows sqlnet.ora failsafe hot to rebuild enterprise manager 11gR2 dbconsole rollback oracle windows oracle_sid client v$sqlarea large_pool oracle ebs cd megaupload how to export procedures and packages using expdp sqldeveloper check if table is locked sql developer data modeler sequences HIBERNATE CRITERIA trunc date -nhibernate oracle terminating the instance error 16038 03113 emctl secure dbconsole -sysman_pwd oracle dbControl Agent port 3938 oracle datenbank appliance -exadata serial# minus v$session select * from chained rows;
Random Entries
Latest Comments
Categories
Related