Home
Search results “Mount oracle instance”
Oracle Instance Startup - DBArch Video 13
 
03:38
In this video you will learn the various steps involved in starting an Oracle Database Instance. You get introduced to the different states of an Instance - IDLE, NOMOUNT, MOUNT and OPEN and what happens in each of these states. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 10456 Ramkumar Swaminathan
How does an Oracle database start? - Database Tutorial 38
 
12:39
Video 38 How does an Oracle database start? - Database Tutorial 38 How does an Oracle database start? - Database Tutorial 38 The startup of sequence of an Oracle Database. 1) Startup process looks for a parameter file in the default location. 2) If a parameter file is found, it then parses it and gets the information about the control files. 3) With that information, it reads the control files. 4) Upto this point, we can say that the Oracle Instance has been started in nomount mode. 5) The same can be achieved by issuing the following command in sqlplus. a) startup nomount; 6) Then, from the control files, the Instance gets to know about the details of the database and its related files. 7) It then 'mounts' the database. 8) At this point, the database has been started. But it can be only accessed by the DBAs. 9) This is called 'mount' mode. 10) The same can be achieved by issuing the following command in sqlplus. a) startup mount; 11) Then, once the database has mounted, it gets opened for other users. 12) This is called 'OPEN' mode. 13) This is the final mode of a startup process after which the database is available for use. 14) The same can be achieved by issuing the following command in sqlplus. a) startup 15) That concludes the startup.
Views: 12488 Sam Dhanasekaran
Oracle DB - Startup & Shutdown
 
11:55
Oracle DB - Startup & Shutdown Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Starting and Shutdown Oracle Database Manually on Windows
 
05:22
Starting and Shutdown Oracle Database Manually on Windows Contact: రవి కుమార్ . లంకె Ravi kumar Lanke Blog: www.installationbyravi.co.in Gmail : [email protected] Yahoo : [email protected]
Views: 9708 Ravikumar Lanke
ORACLE DBA Startup Stages
 
02:33
The Startup 'nomount' Stage When you issue the startup command, the first thing the database will do is enter the nomount stage. During the nomount stage, Oracle first opens and reads the initialization parameter file 'init.ora' to see how the database is configured. For example, the sizes of all of the memory areas in Oracle are defined within the parameter file. After the parameter file is accessed, the memory areas associated with the database instance are allocated. Also, during the nomount stage, the Oracle background processes are started. Together, we call these processes and the associated allocated memory the Oracle instance. Once the instance has started successfully, the database is considered to be in the nomount stage. If you issue the startup command, then Oracle will automatically move onto the next stage of the startup, the mount stage. Starting the Oracle Instance 'Nomount Stage' There are some types of Oracle recovery operations that require the database to be in nomount stage. When this is the case, you need to issue a special startup command: startup nomount, as seen in this example: startup nomount The Mount Stage When the startup command enters the mount stage, it opens and reads the control file. The control file is a binary file that tracks important database information, such as the location of the database datafiles. In the mount stage, Oracle determines the location of the datafiles, but does not yet open them. Once the datafile locations have been identified, the database is ready to be opened. Mounting the Database Some forms of recovery require that the database be opened in mount stage. To put the database in mount stage, use the startup mount command as seen here: startup mount If you have already started the database instance with the startup nomount command, you might change it from the nomount to mount startup stage using the alter database command: alter database mount; The Open Oracle startup Stage The last startup step for an Oracle database is the open stage. When Oracle opens the database, it accesses all of the datafiles associated with the database. Once it has accessed the database datafiles, Oracle makes sure that all of the database datafiles are consistent. Opening the Oracle Database To open the database, you can just use the startup command as seen in this example startup If the database is mounted, you can open it with the alter database open command as seen in this example: alter database open;
Views: 595 Oracle DBA Training
Delete an Oracle instance the right way
 
16:08
Hi friends today i giving you a proper method to delete or drop an oracle database right way. #DeleteanOracleinstance Oracle database Unbeatable,Unbreakable Platform..
Views: 1546 Oracle World
StartupOracle12nomount mount open
 
01:10
Start oracle 12c instance with the steps: nomount mount open
how to start and stop oracle database
 
05:17
startup and shutdown modes of oracle database startup - it will startup database to read write mode. shutdown - normal shutdown. startup mount; -- maintenace mode. startup nomount; - it reads the pfile. alter database mount; - maintenance mode. alter database open; - it opens the database to read write mode. shutdown ========== alter database close; alter database dismount; shutdown; startup force; - it will shutdown and restart database (note: not recommende :)) it is like restart option in windows o/s select name,open_mode from v$database;
Views: 4229 Praveen Biyyapu
How to Install Oracle Database 11g R2 on Oracle Linux 7.5 with ASM
 
07:21
1-ASM multipath ile Disklerin Yapılandırması 2-Sunucumuzda Oracle ASM Kernel modülünü aktif edip “/dev/oracleasm/disks” altında Oracle Mount Point’in oluşmasını sağlıyoruz. (# oracleasm init) 3-Sunucularımızda ASM için kullınılacak disklerimizi “fdisk” ile oluşturup ASM için damgalıyoruz. 4-Oracle Grid Infrastructure ve Oracle Database kurulumları için ilk 3 .zip dosyasına ihtiyacımız var. ($ unzip p10404530_112030_Linux-x86-64_1of7.zip $ unzip p10404530_112030_Linux-x86-64_2of7.zip $ unzip p10404530_112030_Linux-x86-64_3of7.zip) 5-Öncelikle “Oracle Grid Infrastructure” yazılımının kurulumuna başlıyoruz.-- Oracle kullanıcısı ile sistemimize bağlıyken $ /u01/install/grid/.runInstaller uygulamasını çalıştırıyoruz. 6- grid root.sh script çalıştırmadan önce patch uygulamamız gerekmektedir. Link : (https://www.markusdba.net/?p=175) patch yüklemek link aşağıda mevcutur. https://updates.oracle.com/Orion/Services/download/p18370031_112040_Linux-x86-64.zip?aru=17950825&patch_file=p18370031_112040_Linux-x86-64.zip 7-. Oracle Grid Infrastructure kurulumumuz tamamlandı artık veritabanı kurulumuna geçebiliriz. $/u01/install/database/.runInstaller Oracle Enterprise Linux 7.5 64 Bit üzerine Oracle Database 11.2.0.4.0 Grid Infrastructure ASM Kurulumunu gördük.
Views: 196 Ercan Turgut
How to Start,Stop Pluggable database-Oracle 12C administration
 
09:32
How to Start,Stop Pluggable database-Oracle 12C administration =================================================== Important Command SQL= show con_name; CON_NAME ------------------------------ CDB$ROOT SQL-- sho pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDB MOUNTED SQL alter session set container=PDB;
Views: 6344 ANKUSH THAVALI
Migration from Non-Container to PDB database-PART I- Oracle 12C Administration
 
09:30
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs;
Views: 868 ANKUSH THAVALI
How to Create a Dblink Between Two Oracle Database oracle12c/11g
 
18:06
"Must Watch" How to Create a Dblink Between Two Oracle Database oracle12c/11g instance in different machine. #CreateaDblink #Oracle Database12c/11g Oracle database Unbeatable,Unbreakable Platform..
Views: 11522 Oracle World
Oracle DBA | Startup Mode | Bangla | DBA1-11
 
12:00
Oracle DBA | Startup Mode | Bangla | DBA1-11 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Task Of Different Mode: Shutdown Mode: -Create Server parameter file (SPFILE) Nomount Mode: -Rename orcl -restore controlfile from autobackup Mount Mode: -Backup dtabase -Restore Database -Recover Database -Create control file -Enable Archive mode: -Flashback On -Controlfile Autobackup: Open Mode: -Do anything Option for Startup: sql= startup -Instance is created, Database mount and Database opened sql= startup force -Current Instance is aborted, Instance created, Database mount and Database opened sql= startup restrict - Database opened only for users with a restricted session system privilege sql= startup nomount -Only Instance is created sql= startup mount -Instance is created and Database mount Command for Going Different Mode: Shutdown sql=shutdown immediate Nomount/Mount sql=startup nomount/startup mount Mount sql=alter database mount; Open sql=alter database open; To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 84 OracleDB Solutions
ORA-01033: ORACLE initialization or shutdown in progress
 
04:35
ORA-01033: ORACLE initialization or shutdown in progress - How to fix this issue? You can fix ORA-01033: ORACLE initialization or shutdown in progress issue using following commands. Error Message: ORA-01033: ORACLE initialization or shutdown in progress Resolution: As a DBA, you must know the Shutdown, Shutdown Immediate or Startup commands that are issued by database administrator with SYSDBA privileges. 1) select status, database_status from v$instance; 2) select open_mode from v$database; 3) alter database mount; 4) select status, database_status from v$instance; 5) select open_mode from v$database; 6) / as sysdba 7) alter database open; 8) select status, database_status from v$instance; 9) select open_mode from v$database; Check out this entire video and you will see the database is opened in read write mode and your database issue is resolved. Now you can login with your user name and password to access your database. You can also follow below step by step guide to resolve ORA-01033: ORACLE initialization or shutdown in progress issue. http://techiesdigest.com/ora-01033-oracle-initialization-or-shutdown-in-progress/ Share your LOVE by Liking & Sharing this Video and SUBSCRIBE to our YouTube channel for more interesting and useful Tech videos. LIKE - SHARE - SUBSCRIBE Subscribe - https://goo.gl/Z4No32 Website: http://techiesdigest.com/ Twitter: http://www.twitter.com/techiesdigest Facebook: http://www.facebook.com/techiesdigest Google+ - https://plus.google.com/100074553945448527181 YouTube: http://www.youtube.com/techiesdigest Thank you so much! We appreciate your continued extended support, enthusiasm, dedication and passion to LOVE our channel.
Views: 18543 Techies Digest
Block Volume Storage for Oracle Linux on Oracle Cloud Infrastructure
 
05:36
Shows how to create a Block Volume in the Oracle Cloud Infrastructure, and how to attach the device and make it ready to use.
Moving datafile to different Mount Point while the database is Running Live
 
08:25
Hi Guys welcome to my channel ORACLE WORLD today m going to share a new topic Moving datafile to different Mount point while the database is Running Live. #Movingdatafile #MountPoint Oracle database Unbeatable,Unbreakable Platform..
Views: 1065 Oracle World
How to Migrate Non-ASM Database to ASM filesystem |Live Proof
 
11:28
Hello friends in this video i'm going to teach you how to migrate Non-ASM to ASM database with RMAN step by step. For configuration step you can visit on http://ocptechnology.com/oracle-database-migration-from-non-asm-to-asm/ #migratedatabase #nonasm #asm Oracle Interview application https://play.google.com/store/apps/de... My Facebook page https://www.facebook.com/ocptechnology My Second Channel https://www.youtube.com/4usupport My Instagram https://www.instagram.com/ocptechnology/ My Website http://ocptechnology.com/ My twitter https://twitter.com/ocptechnology
Views: 865 OCP Technology
Oracle Database Protection with Hitachi Data Instance Director, How to Set up (video 2)
 
08:23
Use these three videos to design a solution with Hitachi Data Instance Director (HDID) to protect Hitachi Unified Compute Platform for non-multitenant Oracle Database 12c with Oracle Real Application Clusters (RAC) in a single-site environment. Watch how to use Veritas NetBackup to backup a snapshot of a Hitachi Thin Image mount of Oracle Database 12c to Hitachi Content Platform for intensive data protection, recovery, and retention. The first of three videos describes the project details about the solution. The second video describes how to set up the solution. The third video shows how to execute the solution. For more information, see Protect Hitachi Unified Compute Platform for Oracle Database 12c with Hitachi Data Instance Director, Veritas NetBackup, and Hitachi Content Platform Reference Architecture Guide (AS-565-01 or later) at https://www.hds.com/en-us/pdf/architecture-guide/protect-hitachi-ucp-for-oracle-database-12c-with-hdid-vertias-netbackup-and-hcp.pdf
Creating Auxiliary, Clone, Sandbox, Duplicate Database Using RMAN
 
17:32
Duplicating Target Database Using RMAN Auxiliary Database or Creating Auxiliary Database on the Same Server Using RMAN. We have Target Database name as ORCL And we are creating a Auxiliary database with name as AUXDB 1.Check log_mode of Target Database. Target must be in archivelog mode. Other put the database in archivelog mode. shutdown immediate startup mount alter database archivelog; alter database open; 2.Take Whole Hot/Cold Backup of Target Database RMAN backup database plus archivelog; 3.Create Pfile from Target Database Spfile SQL create pfile='C:\ORACLE\PRODUCT\10.2.0\DB_1\Database\initauxdb.ora' from spfile; 4.Open pfile with notepad and replace Ctrl + H all orcl to auxdb SQL host notepad C:\ORACLE\PRODUCT\10.2.0\DB_1\Database\initauxdb.ora 5.On Windows Platform You need to Create a new Instance for auxdb which also creates an password file for the same. SQL host oradim -new -sid auxdb -syspwd admin 6.Create All the folders in Oracle Folder Structures. SQL host mkdir C:\oracle\product\10.2.0\oradata\auxdb SQL host mkdir C:\oracle\product\10.2.0\flash_recovery_area\AUXDB SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\adump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\bdump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\cdump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\dpdump SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\pfile SQL host mkdir C:\oracle\product\10.2.0\admin\auxdb\udump 7.Connect to auxdb and startup instance at nomount stage. C:\set ORACLE_SID=auxdb C:\sqlplus / as sysdba SQL startup nomount //Instance started with pfile SQL create spfile from pfile; SQL shut immediate SQL startup nomount //Instance started with spfile now 8.Now set these two parameters to convert your datafiles and logfile names. SQL show parameter convert SQL alter system set db_file_name_convert = 'orcl','auxdb' scope=spfile; SQL alter system set log_file_name_convert = 'orcl','auxdb' scope=spfile; SQL shut immediate SQL startup nomount 9.Now you need to connect Recovery Manager to start the duplicating (cloning) process. C:\set ORACLE_SID=auxdb C:\rman auxiliary / RMAN connect target sys/[email protected] RMAN run allocate auxiliary channel ch1 device type disk; allocate channel ch2 device type disk; duplicate target database to auxdb; 10.If all steps are done correctly you will have a new database clone created successfully.
Views: 2643 Saurabh Joshi
Configure and Test an OCFS2 Cluster with Oracle Linux on Oracle Cloud Infrastructure
 
10:37
This video shows how to configure an OCFS2 cluster among two instances, using shared ISCSI storage from a third instance.
How to Move a Datafile From File System To ASM Disk Group
 
08:02
Hello friends today is very interesting topic about moving datafile from File system to ASM Disk Storage. #MovingDatafile #ASMDiskGroup Oracle database Unbeatable,Unbreakable Platform..
Views: 4394 Oracle World
Oracle Database Protection with Hitachi Data Instance Director, Project Details (video 1)
 
05:43
Use these three videos to design a solution with Hitachi Data Instance Director (HDID) to protect Hitachi Unified Compute Platform for non-multitenant Oracle Database 12c with Oracle Real Application Clusters (RAC) in a single-site environment. Watch how to use Veritas NetBackup to backup a snapshot of a Hitachi Thin Image mount of Oracle Database 12c to Hitachi Content Platform for intensive data protection, recovery, and retention. The first of three videos describes the project details about the solution. The second video describes how to set up the solution. The third video shows how to execute the solution. For more information, see Protect Hitachi Unified Compute Platform for Oracle Database 12c with Hitachi Data Instance Director, Veritas NetBackup, and Hitachi Content Platform Reference Architecture Guide (AS-565-01 or later) at https://www.hds.com/en-us/pdf/architecture-guide/protect-hitachi-ucp-for-oracle-database-12c-with-hdid-vertias-netbackup-and-hcp.pdf
Backing up Oracle Databases in AWS
 
01:07:21
In this webinar, you'll learn about how the cloud changes your database backup and recovery strategy and what solutions are available to you to use with your Oracle databases in AWS. Plus, a live demo of Veritas CloudPoint in AWS.
How to change of oracle database | Steps to change the database name using dbnewid or nid tool
 
16:40
This video describes the steps used for changing the db name using dbnewid tool . This utility is also known as nid
Views: 6461 Wysheid Wysheid
Streamline Cloning Oracle Databases for Development and Testing
 
14:25
For DBAs looking to streamline the process of cloning a database for development and test efforts, the Oracle Snap Management Utility (SMU) for Oracle Database may help solve that need. The SMU software coordinates storage cloning from the Oracle ZFS Storage Appliance with the process to mount the new clone to a database host from a single interface. Take cloning for development databases from weeks to minutes and accelerate dev/test with SMU. Scott Ledbetter, Oracle Application Integration Engineer, shows how to easily clone an Oracle database instance using the Oracle Snap Manager Utility for Oracle Database. To learn more and obtain a free trial, go to http://oracle.com/storage/nas/snap/index.html. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
How to install oracle 12c on Linux
 
20:53
Learn ow to install the latest release for oracle database i.e 12C. watch the step by step installation in the above video. Click the below link for all the commands and steps http://techlair.info/2015/11/08/oracle12cinstall/ Step 1 - Edit Host Files - /etc/hosts 127.0.0.1 localhost.localdomain localhost 192.168.0.210 oracle_12C.localdomain oracle_12C Step 2 - Edit Kernel Parameters /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 sysctl -p - apply changes Step 3 - Edit Limits file - etc/security/limits.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 Step 4 - Install dependencies yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install gcc -y yum install gcc-c++ -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libXext -y yum install libXext.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install libXi -y yum install libXi.i686 -y yum install make -y yum install sysstat -y yum install unixODBC -y yum install unixODBC-devel -y Step 5 - Add Groups and Users groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper useradd -u 54321 -g oinstall -G dba,oper oracle passwd oracle Step 6 - /etc/security/limits.d/90-nproc.conf # Change this * soft nproc 1024 # To this * - nproc 16384 Step 7 - Set SELINUX SELINUX=permissive run the command after edit setenforce Permissive Step 8 - Stop Firewall # service iptables stop # chkconfig iptables off Step 9 - Create directories for oracle Installation mkdir -p /oracle/product/12.1.0/db_1 chown -R oracle:oinstall /oracle chmod -R 775 /oracle Step 10 - xhost + Step 11 - Edit bash profile for oracle user /home/oracle/.bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=oracle_12C.localdomain export ORACLE_UNQNAME=db1 export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_SID=db1 export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Step - 12 Extract Installation Files unzip linuxamd64_12c_database_1of2.zip unzip linuxamd64_12c_database_2of2.zip Step - 13 Start the Oracle Universal Installer ./runInstaller Post Installation dit the "/etc/oratab" file setting the restart flag for each instance to 'Y' cdb1:/u01/app/oracle/product/12.1.0/db_1:Y Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 138083 TechLair
Oracle DBA Justin - How to drop/delete an Oracle database
 
09:03
How to delete/drop an Oracle database
Views: 15183 jbleistein11
Detaching and Attaching Boot Volumes on Oracle Cloud Infrastructure Instances
 
10:15
This video shows how to detach and attach boot volumes from and to Oracle Cloud Infrastructure Instances, in order to troubleshoot or repair a volume. It shows how to stop an instance and attach its boot volume as a data block volume to another instance.
How to install Grid ASM with RDBMS instance in 11gR2
 
53:48
Hello guys today i describe briefly about 11g ASM configuration with RDBMS instance in 11g to configure asm we need 11g grid software Oracle database Unbeatable,Unbreakable Platform.. #HowtoinstallGridASM #RDBMSinstancein11gR2
Views: 5926 Oracle World
Oracle Database Protection with Hitachi Data Instance Director, Solution Execution (video 3)
 
06:32
Use these three videos to design a solution with Hitachi Data Instance Director (HDID) to protect Hitachi Unified Compute Platform for non-multitenant Oracle Database 12c with Oracle Real Application Clusters (RAC) in a single-site environment. Watch how to use Veritas NetBackup to backup a snapshot of a Hitachi Thin Image mount of Oracle Database 12c to Hitachi Content Platform for intensive data protection, recovery, and retention. The first of three videos describes the project details about the solution. The second video describes how to set up the solution. The third video shows how to execute the solution. For more information, see Protect Hitachi Unified Compute Platform for Oracle Database 12c with Hitachi Data Instance Director, Veritas NetBackup, and Hitachi Content Platform Reference Architecture Guide (AS-565-01 or later) at https://www.hds.com/en-us/pdf/architecture-guide/protect-hitachi-ucp-for-oracle-database-12c-with-hdid-vertias-netbackup-and-hcp.pdf
Steps to drop an Oracle database using DBCA
 
05:50
This video discuss about the steps to drop a database using dbca utility
Views: 4768 Wysheid Wysheid
oracle connected to an idle instance Resolved ✅
 
01:14
How To Fix Oracle connected to idle instance issue ? Worked this. Please Subscribe ❤ Our YouTube Channels ❤ : ☛ CBOT : http://goo.gl/IyFFSV 🔗 ☛ LazyAssTrainer : http://goo.gl/38LlyY 🔗 ☛ Free Promotions For YouTubers : http://goo.gl/bl4OLq 🔗 ☛ Indian Vlogger : http://goo.gl/pHJWIO 🔗 Please Follow ❤ Us On Twitter ❤ : ☛ LazyAssTrainer : http://goo.gl/osKEO7 🔗 ☛ Sameer Pradhan : http://goo.gl/FKWUPt 🔗 ☛ CBOT : http://goo.gl/e4JYn7 🔗 Please Join ❤ Us At FaceBook ❤ : ☛ Sameer Photography : http://goo.gl/6wthA2 🔗 ☛ TCS Photographers Photostock Group : http://goo.gl/8G8n5i 🔗
Views: 15798 WikiVlog
Oracle Compute Cloud: Windows 2012 Server R2
 
04:49
Oracle Compute Cloud: Windows 2012 Server R2
Views: 3249 Ora Tube
SCPT 28 : Oracle Database Start Up Steps
 
14:03
The three steps to starting an Oracle database and making it available for system wide use are: Start an instance. Mount the database. Open the database.
How configure oracle 11g In Archivelog Mode & No archvielog Mode On Redhat
 
16:45
The following are the steps required to enable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:02:52 2010 Copyright 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 25 Current log sequence 27 SQL The log mode is No Archive Mode. Note that Archive destination is USE_DB_RECOVERY_FILE_DEST. You can determine the path by looking at the parameter RECOVERY_FILE_DEST. SQL show parameter recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash_recovery _area db_recovery_file_dest_size big integer 3852M SQL By default, archive logs will be written to the flash recovery area. If you do not want to write archive logs to the flash recovery area you can set the parameter LOG_ARCHIVE_DEST_n to the location in which you wish to write archive logs. SQL alter system set log_archive_dest_1='LOCATION=/u02/app/oracle/oradata/orcl/arch' scope = both; System altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Current log sequence 27 SQL Now we shutdown the database and bring it backup in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL Lastly all that is needed it set archive log mode and open the database. SQL alter database archivelog; Database altered. SQL alter database open; Database altered. SQL archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Next log sequence to archive 27 Current log sequence 27 SQL We can now see that archive log mode is enabled. Notice that Automatic archive is enabled as well. In Oracle 9i an earlier another parameter needed to be set in order to enable automatic archiving. This in no longer the case in 10g and 11g as automatic archiving is enabled when the database is placed in archive log mode. You can switch to the log file to see that an archive is written to archive log location. SQL alter system switch logfile; System altered. SQL host [email protected] ~$ ls /u02/app/oracle/oradata/orcl/arch 1_27_711369564.dbf [email protected] ~$ exit exit SQL The following are the steps required to disable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] ~$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:54:05 2010 Copyright c 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Next log sequence to archive 28 Current log sequence 28 he Database log mode is Archive mode. Next we shut down the database and bring up back up in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL All that is left is to disable archive log mode and open the database. SQL alter database noarchivelog; Database altered. SQL alter database open; Database altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Current log sequence 28 SQL
Views: 206 Md Arshad
Migration of  Non-Container Database to Pluggable-PART II- Oracle 12C Administration
 
37:16
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs; ==================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 755 ANKUSH THAVALI
66b  Rename Oracle  db instance in AWS RDS in Tamil | AWS Tamil
 
06:28
Rename Oracle db instance in AWS RDS in Tamil | AWS Tamil AWS tutorial for beginners in Tamil You can manually adjust the video quality of this video you're watching on a computer or mobile device. oracle on aws rds AWS rds oracle tutorial create oracle database on rds oracle on rds aws oracle db tutorial create oracle database on aws rds create aws oracle on rds aws in tamil AWS For Beginners AWS Tutorial AWS Certification Training aws tutorial for beginners in tamil aws tutorial for beginners aws tamil aws certification aws training aws solution architect associate aws solution architect tutorial for beginners upgrade AWS oracle database version on rds upgrade AWS oracle instance type ,resize rds-instance Fast Database Cloning in Amazon oracle databsae cloning oracle database on aws cloning rds oracle database on aws
Views: 61 jeyfreecloud
Basic Concepts of Oracle 12c   ASM - Simple approach
 
10:27
Created using http://studio.stupeflix.com/
Views: 3580 Krishan Sainani
Oracle Integration: Approved By Both Database and Backup Admins
 
03:48
Abdul Rasheed, Director of Product Strategy, walks through Rubrik's Oracle support with the Alta release. Rubrik's integration delivers control, protection, and compliance while enabling Oracle's incremental merge capabilities.
Views: 1461 Rubrik
How to Install Ubuntu 16.04 LTS on VirtualBox in Windows 8 / Windows 10
 
19:20
I this video I am going to show , How to Install Ubuntu 16.04 LTS on VirtualBox in Windows 8 / Windows 10. Ubuntu is a most popular Linux-based operating system. Recently Ubuntu releases its newest version 16.04 (Xenial Xerus). VirtualBox is also a popular software for creating virtual machine available for Windows and Linux environment. -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter
Views: 340157 ProgrammingKnowledge
Delete Database Using DBCA
 
04:11
Hi... Friends In This Video We Learns How To Delete Database Using DBCA in Oracle 11g On Windows
Views: 1150 PGT POINT
Part 1: Redhat linux Installation for RAC
 
09:59
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 283 Md Arshad
Moving a Database (datafile and Controlfile and Redo Log File)  from File System to ASM Storage
 
27:02
Hi guys today i explaining a real environment scenario that require to move a Full Database from File system to #MovingDatabase #FileSystemtoASMStorage ASM Disk Group Storage. Oracle database Unbeatable,Unbreakable Platform..
Views: 4617 Oracle World
Lost prameter file in oracle database
 
05:28
this video explains how to recreate lost parameter file
Views: 2729 P-Square Technologies
How to remove Oracle database.
 
07:00
Dropping of oracle database using dbca.
Views: 58 dralmostright
Part 3: Making clone of RAC1 node for preparing RAC2 node & create share drive
 
03:33
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 163 Md Arshad
Attach EBS volumes with Windows EC2 instance
 
04:36
Amazon Elastic Block Store
Views: 5090 Prabhu Sunderaraman