Are you over 18 and want to see adult content?
More Annotations
![A complete backup of kettererkunst.de](https://www.archivebay.com/archive2/578c3282-e356-432e-81e7-0a935771a989.png)
A complete backup of kettererkunst.de
Are you over 18 and want to see adult content?
![A complete backup of grandpalladiumrivieramaya.com](https://www.archivebay.com/archive2/c93abfb5-554b-4231-ada4-febe70e3e3b0.png)
A complete backup of grandpalladiumrivieramaya.com
Are you over 18 and want to see adult content?
![A complete backup of tsepispress.wordpress.com](https://www.archivebay.com/archive2/d2e5df23-a61a-43f6-8626-cffc56233b2d.png)
A complete backup of tsepispress.wordpress.com
Are you over 18 and want to see adult content?
![A complete backup of max-planck-schule-kiel.de](https://www.archivebay.com/archive2/2b1a53e1-73bb-4bf7-b478-438ab74644f4.png)
A complete backup of max-planck-schule-kiel.de
Are you over 18 and want to see adult content?
![A complete backup of appalachian-air.com](https://www.archivebay.com/archive2/fb8c58b2-030f-42e7-97bf-f4d1144c94e3.png)
A complete backup of appalachian-air.com
Are you over 18 and want to see adult content?
![A complete backup of ivy.over-blog.com](https://www.archivebay.com/archive2/5eb5bf9c-942a-45c6-9943-2e3054591848.png)
A complete backup of ivy.over-blog.com
Are you over 18 and want to see adult content?
Favourite Annotations
![A complete backup of tv1862helmbrechts.de](https://www.archivebay.com/archive2/4bcddd2d-b709-42f7-a000-2fbe287b8abb.png)
A complete backup of tv1862helmbrechts.de
Are you over 18 and want to see adult content?
![A complete backup of technoprestige.com.ua](https://www.archivebay.com/archive2/aeed48df-14b8-4312-8570-8d9112d8bea0.png)
A complete backup of technoprestige.com.ua
Are you over 18 and want to see adult content?
![A complete backup of prednisone50.com](https://www.archivebay.com/archive2/2e1f8c0a-8ce1-4f3b-aa09-9e6ffe72ea59.png)
A complete backup of prednisone50.com
Are you over 18 and want to see adult content?
![A complete backup of polos-ralphlaurens.co.uk](https://www.archivebay.com/archive2/cbf78ece-dfd9-490d-8981-8a84559d1db8.png)
A complete backup of polos-ralphlaurens.co.uk
Are you over 18 and want to see adult content?
![A complete backup of postpartumprogress.com](https://www.archivebay.com/archive2/80c62a8b-a761-4edd-89fe-b92d880c3229.png)
A complete backup of postpartumprogress.com
Are you over 18 and want to see adult content?
Text
as well.
HOW TO CONFIGURE SHARED SERVER MODE Shared memory resources are preconfigured to allow the enabling of shared server at run time. You need not configure it by specifying parameters in your initialization parameter file, but you can do so if that better suits your environment. Steps are Below are the init parameters needs to change ? 1- alter system set shared_servers=5; DATAGUARD REPLICATION STATUS OR DATA About Sher khan. Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com. This entry was posted in Oracle DataGaurd. STOP AND START RECOVER MANAGED STANDBY DATABASE To start Redo Apply in the foreground, issue the following SQL statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; Database altered. SQL> Alert log contents while recovery HOW TO CONVERT SCN TO DATE AND DATE INTO SCN Database SCN number some time is very important 1) particularly when you are doing rman recovery 2) Filling gaps of archive logs betweenprimary server and
TO CHECK TABLES AND INDEXES LAST ANALYZED DATE To check tables and indexes last analyzed date and Database statsset pages 200col index_owner form a10col table_owner form a10col owner form a10spool checkstat.lstPROMPT Regular Tablesselect owner,table_name,last_analyzed, global_statsfrom dba_tableswhere owner not in ('SYS','SYSTEM')order by owner,table_name/PROMPT Partitioned Tablesselect table_owner, HOW TO ADD DATAFILE TO TABLESPACE ON ASM About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO SET AUTO START RESOURCES IN 11G RAC Changing Resource Attributes in 11gR2 Grid Infrastructure In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could HOW TO CHECK/VALIDATE THAT RMAN BACKUPS ARE GOOD I Want to restore and recover the database till time ‘9:00, 22-October-2012 Step 1: The below command just gives the report of backups that are used to do the restore and recover : RMAN> HOW TO MANUALLY CREATE DATAFILE ON STANDBY SERVER About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. FIND A SESSION WHICH ARE GENERATING MORE ARCHIVE LOGS To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redoas well.
HOW TO CONFIGURE SHARED SERVER MODE Shared memory resources are preconfigured to allow the enabling of shared server at run time. You need not configure it by specifying parameters in your initialization parameter file, but you can do so if that better suits your environment. Steps are Below are the init parameters needs to change ? 1- alter system set shared_servers=5; DATAGUARD REPLICATION STATUS OR DATA About Sher khan. Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com. This entry was posted in Oracle DataGaurd. STOP AND START RECOVER MANAGED STANDBY DATABASE To start Redo Apply in the foreground, issue the following SQL statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; Database altered. SQL> Alert log contents while recovery HOW TO CONVERT SCN TO DATE AND DATE INTO SCN Database SCN number some time is very important 1) particularly when you are doing rman recovery 2) Filling gaps of archive logs betweenprimary server and
TO CHECK TABLES AND INDEXES LAST ANALYZED DATE To check tables and indexes last analyzed date and Database statsset pages 200col index_owner form a10col table_owner form a10col owner form a10spool checkstat.lstPROMPT Regular Tablesselect owner,table_name,last_analyzed, global_statsfrom dba_tableswhere owner not in ('SYS','SYSTEM')order by owner,table_name/PROMPT Partitioned Tablesselect table_owner, HOW TO ADD DATAFILE TO TABLESPACE ON ASM About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO SET AUTO START RESOURCES IN 11G RAC Changing Resource Attributes in 11gR2 Grid Infrastructure In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could HOW TO CHECK/VALIDATE THAT RMAN BACKUPS ARE GOOD I Want to restore and recover the database till time ‘9:00, 22-October-2012 Step 1: The below command just gives the report of backups that are used to do the restore and recover : RMAN> HOW TO MANUALLY CREATE DATAFILE ON STANDBY SERVER About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO OPEN PHYSICAL STANDBY DATABASE IN READ WRITE MODE Steps are follows If your primary Server has crashed and no hope to start it up, than follow the steps to open Physical stand by database to read write mode . But be very care full once you open the Physical standby in read write mode, there is no rollback. SQL> conn /as sysdbaConnected.
HOW TO STOP AND START ORACLE RAC SERVICES ON TWO NODES RAC To start services. 1: Firs off all needs to start nodeapps on both nodes. $ srvctl start nodeapps -n rac-node1 $ srvctl start nodeapps -n rac-node2. 2: Start ASMon both nodes.
HOW TO RUN DBMS_STATS.GATHER_TABLE_STATS USING … How To Run DBMS_STATS.GATHER_TABLE_STATS Using Dynamic Query. Posted on October 22, 2012 by Sher khan. Connect as scott, scott has DBA and ANALYSE ANY privileges create or replace procedure getstattest IS str1 varchar2 (1000); cnt NUMBER; CURSOR c_C1 IS select TABLE_NAME, OWNER from dba_tables where OWNER IN ('SCOTT') and TABLE_NAME IN ('EMP HOW TO DISPLAY ICONIC IMAGES USING FORMS How to display images/icons on the buttons Steps are Example 1: Using a jar file =====1] Gather all the icon files in a directory. For this copy all the icons files (gif or jpg) to a folder e.g c:\icons or /tmp/icons folder 2] Create the jar including the icons. Change directory to the target icons HOW TO CHECK/VALIDATE THAT RMAN BACKUPS ARE GOOD I Want to restore and recover the database till time ‘9:00, 22-October-2012 Step 1: The below command just gives the report of backups that are used to do the restore and recover : RMAN> HOW TO SET AUTO START RESOURCES IN 11G RAC Changing Resource Attributes in 11gR2 Grid Infrastructure In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could DELETE ARCHIVELOGS FROM PRIMARY SERVER To delete safely archive logs from primary oracle database server, I have created a SQL script on the primary database to generate a os batch file to delete archive logs those are applied on the Standby server. We can delete archive logs status=applied from the primary server. steps are below 1.cmd connect to standby server RMAN RECOVERY IF THE MISSING ARCHIVE LOGS ARE REQUIRED FOR 1- -----Restore the database ----- RMAN> restore database; Starting restore at 25-AUG-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF channel ORA_DISK_1: restoring HOW TO MANUALLY CREATE DATAFILE ON STANDBY SERVER About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. ORA-27300: OS SYSTEM DEPENDENT OPERATION:INVALID_EGID ORA-27300: OS system dependent operation:invalid_egid failed with status: 1. ORA-27301: OS failure message: Operation not permitted. ORA-27302: failure occurred at: skgpwinit6. ORA-27303: additional information: startup egid = 501 (oinstall), current egid = HOW TO CONVERT SCN TO DATE AND DATE INTO SCN Database SCN number some time is very important 1) particularly when you are doing rman recovery 2) Filling gaps of archive logs betweenprimary server and
FIND A SESSION WHICH ARE GENERATING MORE ARCHIVE LOGS To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redoas well.
STOP AND START RECOVER MANAGED STANDBY DATABASE To start Redo Apply in the foreground, issue the following SQL statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; Database altered. SQL> Alert log contents while recovery DATAGUARD REPLICATION STATUS OR DATA About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO SET AUTO START RESOURCES IN 11G RAC Changing Resource Attributes in 11gR2 Grid Infrastructure In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could HOW TO ADD DATAFILE TO TABLESPACE ON ASM About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO DISPLAY ICONIC IMAGES USING FORMS How to display images/icons on the buttons Steps are Example 1: Using a jar file =====1] Gather all the icon files in a directory. For this copy all the icons files (gif or jpg) to a folder e.g c:\icons or /tmp/icons folder 2] Create the jar including the icons. Change directory to the target icons TO CHECK TABLES AND INDEXES LAST ANALYZED DATE To check tables and indexes last analyzed date and Database statsset pages 200col index_owner form a10col table_owner form a10col owner form a10spool checkstat.lstPROMPT Regular Tablesselect owner,table_name,last_analyzed, global_statsfrom dba_tableswhere owner not in ('SYS','SYSTEM')order by owner,table_name/PROMPT Partitioned Tablesselect table_owner, HOW TO CHECK/VALIDATE THAT RMAN BACKUPS ARE GOOD I Want to restore and recover the database till time ‘9:00, 22-October-2012 Step 1: The below command just gives the report of backups that are used to do the restore and recover : RMAN> HOW TO MOVE TABLES FROM ONE TABLESPACE TO ANOTHER About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO CONVERT SCN TO DATE AND DATE INTO SCN Database SCN number some time is very important 1) particularly when you are doing rman recovery 2) Filling gaps of archive logs betweenprimary server and
FIND A SESSION WHICH ARE GENERATING MORE ARCHIVE LOGS To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redoas well.
STOP AND START RECOVER MANAGED STANDBY DATABASE To start Redo Apply in the foreground, issue the following SQL statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; Database altered. SQL> Alert log contents while recovery DATAGUARD REPLICATION STATUS OR DATA About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO SET AUTO START RESOURCES IN 11G RAC Changing Resource Attributes in 11gR2 Grid Infrastructure In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could HOW TO ADD DATAFILE TO TABLESPACE ON ASM About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO DISPLAY ICONIC IMAGES USING FORMS How to display images/icons on the buttons Steps are Example 1: Using a jar file =====1] Gather all the icon files in a directory. For this copy all the icons files (gif or jpg) to a folder e.g c:\icons or /tmp/icons folder 2] Create the jar including the icons. Change directory to the target icons TO CHECK TABLES AND INDEXES LAST ANALYZED DATE To check tables and indexes last analyzed date and Database statsset pages 200col index_owner form a10col table_owner form a10col owner form a10spool checkstat.lstPROMPT Regular Tablesselect owner,table_name,last_analyzed, global_statsfrom dba_tableswhere owner not in ('SYS','SYSTEM')order by owner,table_name/PROMPT Partitioned Tablesselect table_owner, HOW TO CHECK/VALIDATE THAT RMAN BACKUPS ARE GOOD I Want to restore and recover the database till time ‘9:00, 22-October-2012 Step 1: The below command just gives the report of backups that are used to do the restore and recover : RMAN> HOW TO MOVE TABLES FROM ONE TABLESPACE TO ANOTHER About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C.ORACLE RAC DBA
Hi, I have some queries on RAC 11gr2 on Linux platform we are migrating our storage from HP EVA to Hitachi HDS storage. i have been provided all the new disks and i HOW TO CONFIGURE SHARED SERVER MODE Shared memory resources are preconfigured to allow the enabling of shared server at run time. You need not configure it by specifying parameters in your initialization parameter file, but you can do so if that better suits your environment. Steps are Below are the init parameters needs to change ? 1- alter system set shared_servers=5; HOW TO SET AUTO START RESOURCES IN 11G RAC Changing Resource Attributes in 11gR2 Grid Infrastructure In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could HOW TO MOVE TABLES FROM ONE TABLESPACE TO ANOTHER About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO DISPLAY ICONIC IMAGES USING FORMS How to display images/icons on the buttons Steps are Example 1: Using a jar file =====1] Gather all the icon files in a directory. For this copy all the icons files (gif or jpg) to a folder e.g c:\icons or /tmp/icons folder 2] Create the jar including the icons. Change directory to the target icons HOW TO STOP AND START ORACLE RAC SERVICES ON TWO NODES RAC About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO CONFIGURE SSH FOR A RAC INSTALLATION /ORACLE USER About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. HOW TO OPEN PHYSICAL STANDBY DATABASE IN READ WRITE MODE Steps are follows If your primary Server has crashed and no hope to start it up, than follow the steps to open Physical stand by database to read write mode . But be very care full once you open the Physical standby in read write mode, there is no rollback. SQL> conn /as sysdbaConnected.
RMAN RECOVERY IF THE MISSING ARCHIVE LOGS ARE REQUIRED FOR 1- -----Restore the database ----- RMAN> restore database; Starting restore at 25-AUG-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF channel ORA_DISK_1: restoring ORA-27300: OS SYSTEM DEPENDENT OPERATION:INVALID_EGID About Sher khan Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C.ORACLE RAC DBA
Skip to content
* Home
* About me
* Delete Archivelogs from Primary ServerORACLE RAC DBA
WELCOME TO MY BLOGS
I HAVE WRITTEN MANY POSTS ALL RELATED TO ORACLE DATABASE ADMINISTRATION. ORACLE DATABASE 12C ADMINISTRATOR CERTIFIED PROFESSIONAL Oracle RAC administration. Oracle 11g Exadata. ORACLE DATA GAURD ADMINISTRATION AND MAINTANANCE. ORACLE 11G ACTIVE DATAGAURD. ORACLE 10G PHYSICAL STANDBY DATAGUARD. ORACLE MANUL PHYSICAL STANDBY CONFIGURATION ON STANDARD EDITION USING SQL SCRIPTS. ORACLE DATABASE BACKUP AND RECOVERY.RMAN AND EXPORT.
ORACLE DATABASE PERFORMANCE TUNING. ORACLE 10G APPLICATION SERVER INSTALLATIONAND CONFIGURATION.
ORACLE 10G APP REPORT SERVER CONFIGURATION ANDMaintenance.
Unix Commands and script and many more.Advertisements
Report this ad
Report this ad
SHARE THIS:
*
8 RESPONSES TO _ORACLE RAC DBA_*
Junaid Khan says:
September 21, 2013 at 4:55 pmHi,
I have some queries on RAC 11gr2 on Linux platform we are migrating our storage from HP EVA to Hitachi HDS storage. i have been provided all the new disks and i have added those disks to all the disk groups available. DG’s are as follows: SQL> show parameter asmNAME TYPE VALUE
———————————— ———– —————————— asm_diskgroups string REDO_1, REDO_2, ORADATA, ORAFLASH
SQL> select GROUP_NUMBER,NAME,STATE,TYPE,VOTING_FILES fromV$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE TYPE V ———— ————— ———– —— – 1 OCR_VOTING MOUNTED EXTERN Y 2 ORADATA MOUNTED EXTERN N 3 ORAFLASH MOUNTED EXTERN N 4 REDO_1 MOUNTED EXTERN N 5 REDO_2 MOUNTED EXTERN N re balance is completed successfully. now can you please let me know the exact steps which needs to be takencare here.
Thanks in advance.
Reply
*
iMesh Lab says:
February 24, 2014 at 10:06 am I like your post thanks for sharing with us..imeshlab
Reply
*
kells says:
March 13, 2017 at 11:39 am I created a 11GR2 RAC three node cluster and it installed successfully without any problem BUT It is having a problem starting up as seen below in the screenshot.Reply
*
kells says:
March 13, 2017 at 12:21 pm I created a 11GR2 RAC three node cluster and it installed successfully without any problem BUT It is having a problem starting up as seenbelow
Database Creation complete. for details check the logfiles /u01/app/oracle/cfgtoollogs/dbca/cabdabuat Global database Name: Cabdabuat System Identifier(SID)prefix: Cabdabuat Server Parameter File name: +DISK2/cabdabuat/spfilecabdabuat.ora BUT when I try logging in, i get Connected to an idle instanceSQL> startup
ORA-01078: failure in processing system parameters LRM-00109: Could not open parameter file ‘u01/app/oracle/product/11.2.0/dbhome_1/dbs/cabdabuat.ora’Reply
*
Sher khan says:
March 15, 2017 at 3:53 amHi,
While connecting to database it’s looking you have not specified parameters for the Oracle os user. Your db name is Cabdabuat. While connecting from Node1 you do, Export ORACLE_SID=Cabdabuat1Export ORACLE_HOME=
than connect surplus SQL>connect sys as syadba Hope it will help , let me know if you still have a problem.Thanks
Sent from my Sony Xperia™ smartphone*
Azharuddin says:
May 16, 2017 at 10:26 am Thanks for the information. Mindmajix provides best Oracle RAC training. Online training by real time experts. Explore Online training and Oracle RAC course is aligned with industry needs & developed by industry experts. Attend free demo here! https://mindmajix.com/oracle-rac-trainingReply
*
venkat
says:
December 1, 2017 at 9:16 am Valuable information thanks for sharing Oracle RAC DBA Online TrainingReply
*
srcalfre
says:
August 13, 2018 at 10:33 am Thanks for sharing nice information for more do visit us at Oracle RAC Training in TexasReply
LEAVE A REPLY CANCEL REPLY Fill in your details below or click an icon to log in:*
*
*
*
*
Email (required) (Address never made public)Name (required)
Website
You are commenting using your WordPress.com account. ( Log Out /Change )
You are commenting using your Google account. ( Log Out /Change )
You are commenting using your Twitter account. ( Log Out /Change )
You are commenting using your Facebook account. ( Log Out /Change )
Cancel
Connecting to %s
Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data isprocessed .
*
Search for:
*
RECENT POSTS
* Chnage the Path for the mdf and ldf file while Creating aSQL Database
* The file ‘F:\data\DB05_log.ldf’ cannot be overwritten. It is being used by database ‘test’. * LINUX USEFULL COMMANDS * Public key for .rpm is not installed * Migration of Database With Zero Down Time*
ARCHIVES
* January 2019
* December 2018
* January 2017
* October 2014
* September 2014
* August 2014
* July 2014
* June 2014
* May 2014
* April 2014
* September 2013
* August 2013
* July 2013
* May 2013
* April 2013
* March 2013
* January 2013
* December 2012
* November 2012
* October 2012
* September 2012
* August 2012
*
CATEGORIES
* ASM
* Configuration
* Database administration * Database Corruption* Database Locks
* Database Migration* EBS
* Exadata
* Linux commands for DBA* Materialized view
* Ocfs2
* Oracle Application server * Oracle backup & recovery* Oracle DataGaurd
* Oracle fusion Middleware* Oracle RAC
* Performance and Tuning* rman
* scripts
* SQL Server
* statistics
* Uncategorized
*
META
* Register
* Log in
* Entries RSS
* Comments RSS
* WordPress.com
Advertisements
Report this ad
ORACLE RAC DBA
Create a free website or blog at WordPress.com. Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. To find out more, including how to control cookies, see here: CookiePolicy
* Follow
*
* ORACLE RAC DBA
* Customize
* Follow
* Sign up
* Log in
* Copy shortlink
* Report this content * Manage subscriptions* Collapse this bar
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0