Home
Search results “Oracle server sga” for the 2015
Tutoriel Oracle DBA1 (14) : Les composants SGA et PGA.
 
08:31
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 5185 Abdessamad HALLAL
DML Processing in an Oracle Database -  DBArch Video 8
 
09:07
This video explains the steps involved in processing a DML statement in an Oracle Database Server. 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: 62338 Ramkumar Swaminathan
Oracle Core,  Лекция 1
 
01:41:48
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1G9WApknrVwmmfrebanes8xjfLwhSKSPVNiZFH5Jgtng/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1jCON8ZOVmtmiVJb0E1RMSexoaYzRPhjxAmhLe2egmog/edit?usp=sharing Oracle. Тема 1. Архитектура. 1. Обзор и история РСУБД Oracle 2. Установка Oracle и создание базы данных 3. Экземпляр и база данных Oracle 4. Физическая и логическая структура данных Oracle: tablespace,segment,data file,undo,redo и т.д. 5. Структуры памяти и основные процессы Oracle: SMON, PMON, DBW,LGW, SGA, PGA, Buffer Cache, Library Cache и т.д. 6. Запуск и останов Oracle 7. Виды подключений к Oracle: DEDICATED, SHARED, DRCP 8. Системные представления V$ и DBA_ 9. Список использованных материалов Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
التعرف على ال SGA
 
07:05
في هذا الدرس سنتعرف على ال System Global Area و اجزائها الرئيسية بشكل مقتضب, حيث سيكون هنالك درس خاص بكل جزء من هذه الأجزاء. لمشاهدة جميع دروس دورة ادارة قواعد بيانات اوراكل من هنا : الدرس الأول – مقدمة دورة ادارة قواعد بيانات اوراكل : http://technawi.net/?p=2772 الدرس الثاني – مقدمة لمعمارية قواعد بيانات اوراكل : http://technawi.net/?p=3674 الدرس الثالث – ماهي قواعد بيانات اوراكل : http://technawi.net/?p=3677 الدرس الرابع – طرق الإتصال بخوادم قواعد البيانات : http://technawi.net/?p=3682 الدرس الخامس – مكونات خادم قواعد بيانات اوراكل : http://technawi.net/?p=3806 الدرس السادس – طرق تمثيل و تطبيق خوادم قواعد بيانات اوراكل : http://technawi.net/?p=3808 الدرس السابع – كيفية الاتصال بين المستخدم و خادم قواعد البيانات : http://technawi.net/?p=4081 الدرس الثامن – هيكلية ذاكرة خادم قواعد البيانات : http://technawi.net/?p=4152 الدرس التاسع – التعرف على ال SGA : http://technawi.net/?p=4155
Oracle Performance Tuning - Monitoring using Oracle Enterprise Manager
 
12:41
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 33948 itversity
Tutoriel Oracle DBA1 (33) : L'architecture Partager (Shared server).
 
05:54
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 1611 Abdessamad HALLAL
Tutoriel Oracle DBA1 (17) : Le composant mémoire Shared Pool.
 
05:43
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 3396 Abdessamad HALLAL
Tutoriel Oracle DBA1 (42) : Le composant Large POOL set RMAN.
 
05:59
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 1449 Abdessamad HALLAL
Tutoriel Oracle DBA1 (32) : L'architecture dédier (Dedicated server).
 
06:05
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 1635 Abdessamad HALLAL
#Oracle OCP认证【2.1.5】中级/Oracle的体系结构/SGA 系统全局区
 
22:43
OCP (Oracle Certified Professional)是由Oracle公司颁布并实施的一项权威的专业技术标准­­­­­,它是专为认证那些能够满足对ORACLE核心产品的服务与支持,并具有娴熟­的­操­作­能­力与广泛理论知识的专业人士。一经认证,在行业内的专业资格将被确认­,从­而使­个人­或企­业更具竞争实力。
Views: 205 我赢职场
Chapitre 3 tuto1  Architecture d'une instance Oracle les zones mémoires   YouTube
 
35:19
Chapitre 3 tuto1 Architecture d'une instance Oracle les zones mémoires
Oracle SQL Tutorial 1 - Intro to Oracle Database
 
10:18
As illustrated in the video, Oracle Database is a program designed to hold lots of information, or data. There are all kinds of different databases and they all have their uses. Some of the most common ones are MySQL, SQL Server, Sybase, and MongoDB. All of these have different uses. The differences will be easier to understand after you learn more about each kind of database. We did not discuss it much in the video, but if you are wondering what “SQL” means in the title, it stands for structured query language. Structured query language is a human readable computer language that is used to tell databases to do things. We will discuss SQL and Oracle SQL Developer more in future videos. Databases are better than spreadsheets because they allow multiple users at one time, different levels of access given to users, recovery options and transactions, and it is more protected from hacking and malicious destruction. Programming languages often have very useful functions or methods that can be used to communicate to a database and therefore they are a naturally good option for the back end of programs. This course will go over all of the major parts of database programming using Oracle SQL. We will be using Oracle 11g, but these videos should still work with other versions, including the most recent 12c. Q and A ~~~~~~ How much does Oracle cost? The full enterprise edition costs thousands. They have other versions for less and they even have a FREE VERSION! This is known as the XE version (eXpress Edition). That is the one we will be using. How long does it take to learn SQL? You can learn all of the basics and be an efficient beginner database developer in only about a month of practice. To become an intermediate it can take anywhere from an additional 3 - 6 months with a only a few hours of studying and practicing each day. How can I learn SQL faster? Take notes and actually mess around with making your own database. Watch these videos until you understand the concepts within them, read articles and books that teach in more depth. Enjoy this content? You might enjoy my programming videos. Pick one and have some fun! 🙂 Learn Javascript - http://bit.ly/JavaScriptPlaylist Learn Java - http://bit.ly/JavaPlaylist Learn C# - http://bit.ly/CSharpTutorialsPlaylist Learn C++ - http://bit.ly/CPlusPlusPlaylist Learn C - http://bit.ly/CTutorialsPlaylist Donate!: http://bit.ly/DonateCTVM2. HELP ME! http://www.patreon.com/calebcurry. Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 382866 Caleb Curry
Oracle architecture step 1:-user ,server processes
 
05:53
Description of oracle architecture including user process,server process,connection and session points
Views: 10156 [email protected]
2.  Установка СУБД Oracle 11.2
 
21:07
1. Разные версии ПО (express edition, standard edition, enterprise edition) 2. Структура каталогов 3. Выбор технологий 4. ORA_HOME 5. Database Configuration Assistance 6. Создание БД - SID 7. Системные пользователи 8. Параметры SGA, PGA. Размер блока 9. Кодировка и режим соединения 10. Параметры хранения файлов 11. LISTENER 12. Табличное пространство SYSTEM 13. SQL PLUS Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
5. Структуры памяти Oracle
 
13:34
1. SGA 2. PGA 3. Shared Pool: library cache, data dictionary cache 4. Buffer Cache: db_cache_size, db_keep_cache_size, db_recycle_cache_size 5. Redo Log Buffer Cache 6. Large Pool 7. Java Pool Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
قواعد البيانات 3  (server process and  PGA (Oracle DBA 11g Tutorial
 
21:08
oracle database 11g server processes program global area in oracle 11g user global area in oracle 11g dedicated server process
Views: 693 Ahmed Ybat
2.Table level Export and Import in Oracle database
 
05:10
Hello friends in this video i explain about table level export and import which is the best method for backup and recovery of table and easy to manage by user. #TablelevelExportandImport Oracle database Unbeatable,Unbreakable Platform..
Views: 10378 Oracle World
Exploring the Oracle Database Architecture - Part-1 (Video-1)
 
01:38:13
Oracle Database Architecture Overview - Background Processes, Memory Structures - SGA and PGA and Files on Disk
Views: 28133 Satish Lodam
Managing Database Structure -Tablespaces and Datafiles part 1st
 
21:55
Hi friends in this video i am going to explain you how to create alter tablespace and datafile in oracle. #ManagingDatabaseStructure #TablespacesandDatafiles Oracle database Unbeatable,Unbreakable Platform..
Views: 11859 Oracle World
SGA
 
46:35
SGA
Views: 74 mohammed faizan
قواعد البيانات 2  (database buffer cache (Oracle DBA 11g Tutorial
 
21:42
database buffer cache in oracle 11g - Memory Structures - Overview of the System Global Area
Views: 826 Ahmed Ybat
MNG7: PL/SQL Runtime Memory Management (PL/SQL Channel)
 
26:19
Explore the different kinds of memory used by Oracle generally and the PL/SQL runtime engine specifically, including the SGA (System Global Area), PGA (Process Global Area) and UGA (User Global Area). The video also offers techniques for analyzing memory consumption by your programs. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
SQL tutorial 62: Indexes In Oracle Database By Manish Sharma RebellionRider
 
04:03
Watch and learn concepts of SQL Index In Oracle Database. In this tutorial you will learn about B-Tree Index and Function based Index. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 43381 Manish Sharma
Automatic Historical Tracking of Data in Oracle Using Flashback Data Archive
 
21:44
Track data as it changes over time without any code or schema changes in Oracle Database using Flashback Data Archive.
Oracle DBA Tutorials for the Beginners | Oracle DBA Training
 
01:04:43
Beginners are interested with an oracle dba tutorial from kernel training. Oracle Database is referred to as Oracle RDBMS is an object-relational database management system. Users of Oracle databases refer to the server-side memory-structure as the SGA. Visit Us http://kerneltraining.com/oracle-dba/ Email Us: [email protected] Phone: 91 8099 77 6681 In this Youtube you can find a clear description of Oracle DBA 11g, and our presenter has provided full information in this tutorial. You will find a succession of descriptions about the subject in a Power Point presentation, excel sheet presentations, and the kernel training pages are also opened up for better understanding. You can feel free to ask for any doubts when you do attend one free demo session for beginners. Here, is a fine example to learn basics concept, and practical applications. You can learn oracle dba step by step that will be dealt by kernel Training online if you do attend oracle dba tutorial for beginners, and this oracle dba classes will help you learn about several topics such as oracle dba architecture, Oracle dba performance tuning, Oracle dba asm, and our faculty will deliver oracle dba interview videos that will be far more beneficial than the expected. In the process of learning, you can understand clearly oracle dba Linux commands, and also grasp the oracle dba real time scenarios, and in this oracle dba full course, you will be exposed to oracle dba interview questions and answers for experienced professionals and startups. About the Course: Oracle Database is referred to as Oracle RDBMS is an object-relational database management system. Users of Oracle databases refer to the server-side memory-structure as the SGA. The SGA typically holds cache information such as data-buffers, SQL commands, and user information. In addition to storage, the database consists of online redo logs, which hold transactional history. Processes can in turn archive the online redo logs into archive logs, which provide the basis for data recovery and for the physical-standby forms of data replication using Oracle Data Guard. Course Objective:  Software installation and the creation of new databases.  An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.  Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.  Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.  Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.  Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.  Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.  Control over database support services, including the Database Control, Oracle Net and others.  A primer on backup and recovery structures and strategies.  Operating system-specific considerations for various platforms, especially Linux and MS Windows Server. How We Teach at kernel Training? It is an Online Course with Instructor led LIVE and Interactive Sessions, Practical Work that involves Practical Hands-on, Lab Assignments, and real-world Case Studies, access to 24×7 Technical Support, a real time project with Kernel Data Center. Course participants will get a verifiable certificate after successful completion of the project work. Oracle – DBA 11g COURSE CONTENT Module 1 INTRODUCTION to ORACLE Exploring the Database Architecture Module: 2 Installing your Oracle Software Module 03 Creating an Oracle Database Module 04: Managing the Database Instance Module 05 Managing Database Storage Structures Module 06 Administering User Security Module 07 Managing Data Concurrency Module 08 Managing Undo Data Module 09 Backup and Recovery Concepts Module 10 Use of RMAN Recovery Catalog & Configuring Backup Settings Module 11 Performing Database Backups with RMAN Module 12 Performing Database Recovery Module 13 Moving Data Module 14 Using Flashback Technology I Module 15 Using Flashback Technology II Module 16 Implementing Oracle Database Auditing Module 17 Database Maintenance Module 18 Performance Management Module 19 Managing Performance by SQL Tuning Module 20 Diagnosing the Database Module 21 Managing Space Module 22 Managing Space for the Database Module 23 Managing the ASM Instance Module 24 Duplicating a Database / Cloning Database Module 25 Data Guard
Views: 120290 KernelTraining.Com
Oracle Database Tutorial 63 : Introduction to Tablespace In Oracle Database
 
04:26
Introduction to tablespace in oracle database consist Brief intro of tablepsace, type of tablespace, Big and small file tablespace, intro of Data files in oracle By manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-introduction-rebellionrider Previous Tutorial ► Indexes https://youtu.be/F5NrQYD4a9g ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 38149 Manish Sharma
AWR Report Generation
 
09:32
#Oracle #AWR Generating and viewing an AWR Report. (Note : Usage of AWR requires the Diagnostic Pack Licence !) Also see video "AWR with SQLDeveloper" https://youtu.be/QNICuRuBnZo For examples of interpreting an AWR report search https://hemantoracledba.blogspot.com for "AWR"
Views: 24297 Hemant K Chitale
Oracle 12c: Database Administration I Part 1: Course Introduction
 
05:20
http://gogotraining.com, 877-546-4446 This video describes what is covered in this course. In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to install, administer and maintain an Oracle 12c database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination. Once you have completed Oracle 12c: Database Administration I Part 1 the next course is this series is Oracle 12c: Database Administration I Part 2. The Oracle 12c: Database Administration I Part 2 course will continue to build your knowledge in shared server, database performance monitoring, database maintenance, how to use the undo management feature, how to deal with locking conflicts and finishing up with backups and database recovery. Click here to learn more about Oracle 12c: Database Administration I Part 2. http://gogotraining.com, 877-546-4446
Views: 3100 GogoTraining
Oracle World - Introduction to Oracle Memory Architecture
 
33:33
Hello friends in this video i giving you a brief Introduction to Oracle Memory Architecture like SGA and Datafile,Control File,also Redo Log File in dept (Oracle database Unbeatable,Unbreakable Platform). #OracleWorld #IntroductiontoOracleMemoryArchitecture
Views: 4288 Oracle World
2. SQL Server for Oracle DBA's - Database architecture
 
57:40
SQL Server for Oracle Database Administrators - Database architecture http://dbacatalog.blogspot.com
Views: 928 dbacatalog
Oracle Coherence: Explaining the 3 Cache Types
 
04:16
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Oracle Database Architecture - Oracle Introduction Overview - Bigclasses
 
40:47
To know more details on Oracle DBA click here : http://bigclasses.com/oracle-dba-online-training.html ,visit : +91 800 811 4040 Oracle DBA: Oracle Database Administrator: A database administrator directs or performs all activities related to maintaining a successful database environment. The Responsibilities of DBA is designing, implementing, and maintaining the database. Versions: Oracle 10g, Oracle 11g……. ,g stands for grid For regular Updates on DBA please like our Facebook page:- Facebook:- https://www.facebook.com/bigclasses/ Twitter:- https://twitter.com/bigclasses LinkedIn:- https://www.linkedin.com/company/bigclasses Google+: https://plus.google.com/+Bigclassesonlinetraining DBA Course Page:- http://bigclasses.com/oracle-dba-online-training.html Contact us: - India +91 800 811 4040 USA +1 732 325 1626 Email us at: - [email protected]
Views: 51740 Bigclasses
Oracle Architecture in 10g
 
40:17
oracle architecture in 10g
Views: 1383 Sainora Annanagar
The Oracle Real Application Clusters (RAC) Family of Solutions - A User Guide
 
56:53
In this presentation, Markus Michalewicz illustrates that RAC is more than the HA database system it is widely known for and presents additional perspectives for products, layers and features to make Oracle RAC the perfect solution.
Simplify Consolidation with Oracle Database 12c
 
38:38
Patrick Wheeler, senior director of product management, introduces Oracle Multitenant, a new architecture for consolidating databases and simplifying operations in the Cloud. He discusses upgrading to Multitenant and several important use cases that illustrate its benefits and advantages.
Using NETCA
 
07:50
Using NETCA to create listener and tnsnames entries
Views: 5224 Hemant K Chitale
1 Oracle Flashback Technologies
 
07:07
This Video Lecture Talks about Oracle Flashback Technologies. https://www.educba.com/
Views: 2716 eduCBA
قواعد البيانات 4  (Shared Pool (Oracle DBA 11g Tutorial
 
20:04
Oracle DBA 11g Tutorial shared pool - oracle 11g Library - Sql area and procedure/ sql data Dictionary cache block structure
Views: 471 Ahmed Ybat
Oracle Tablespace Management
 
41:44
How to Create and Manage tablespace watch this video
Views: 5328 COMBINATIONS FOR ALL
Install Oracle 12c in Linux 7.x Step by Step
 
30:40
Step 1: download oracle 12c in oracle website http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-2240591.html Step 2: create group and user install oracle #groupadd oinstall #groupadd dba #groupadd oper #useradd -G dba,oper -g oinstall oracle #passwd oracle Step 3: create folder install oracle #mkdir -p /u01/app/oracle/product/12.1/db_1 #mkdir -p /u01/setup #chown -R oracle:oinstall /u01 #chmod -R 775 /u01 Step 4: Set parameter #vi /etc/sysctl.conf add the following lines 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 #/sbin/sysctl -p #vi /etc/security/limits.conf add the following lines oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 Step 5: Install the following packages if they are not already present. 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 now, i installed all packages Step 6: add in hosts file #vi /etc/hosts add the following lines 192.168.10.100 oracle.test.com oracle.test oracle.test is hostname and 192.168.10.100 is ip address Step 7: Set environmental variable for user ORACLE #su - oracle $ cd ~ $ vi .bash_profile add the following lines # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=oracle.test export ORACLE_UNQNAME=dbtest export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1/db_1 export ORACLE_SID=dbtest 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 8: Upload files to server using user Oracle Step 9: Unzip files $unzip linuxamd64_12c_database_1of2.zip.zip $unzip linuxamd64_12c_database_2of2.zip.zip Step 10: Install oracle DB $xhost + $cd /u01/setup/database $./runInstaller now, install ORACLE DATABSE using DBCA $dbca
Views: 57198 Mr_Chicken
Oracle RAC  Training Course Video Tutorial
 
01:01:09
Visit Us: http://kerneltraining.com/ Oracle RAC Online Training Course Video Tutorial Oracle RAC Tutorial for beginners. Take part till end of this session and get useful details. Thanks for watching Oracle RAC Tutorial Kernel training offers Oracle RAC Tutorial led by real time expert. For further details visit: http://kerneltraining.com/oracle-rac/ https://www.facebook.com/KernelTraining Free Oracle RAC Tutorial demo class Get live interactive classes Access to LMS (Learning management system). Real time hands on experience. 24/7 Support. Visit our website: www.kerneltraining.com Contact us: Email Us: [email protected] Phone: 91 8099 77 6681 Regards Kernel training team
Views: 18126 KernelTraining.Com
Oracle Database
 
28:22
ERP SAP Basic - Net Weaver:Oracle Database: Oracle Database Administration: Terminology-(00:00-15:10) Oracle Database is a relational database with object and Extensible Markup Language (XML) capabilities. -The Oracle software that you install on your host computer -The database, which is a collection of physical files on one or more disks The Oracle instance, which is composed of the following: - The background processes. - The shared memory . -Server processes that perform work on behalf of connected users and applications, and the memory and temporary storage used by these processes - Oracle Net, which is a software layer that enables client applications and Oracle Database to communicate over a network, and the Oracle Net listener, which is a process that listens for connection requests from the network. Tools for Administering the Database- (15:10-23:39) -Oracle Universal Installer -Oracle Universal Installer (OUI) is a utility that installs your Oracle. -Oracle Database Configuration Assistant Oracle Database Configuration Assistant (DBCA) is a utility that creates a database from templates that are supplied by Oracle, or you can create your own. -Database Upgrade Assistant The Database Upgrade Assistant is a tool that guides you through the upgrade of your existing database to a new Oracle Database release. Net Configuration Assistant -Net Configuration Assistant (NETCA)- It is a utility that enables you to configure listeners and naming methods, which are critical components of the Oracle Database network. Oracle Enterprise Manager Database Control - The primary product for managing your database is Oracle Enterprise . Summary- (23:39-28:02) Video by Edupedia World(www.edupediaworld.com),Online Education. Click on (https://www.youtube.com/playlist?list=PLJumA3phskPGPlQlHs8aMiRWO21EpH1GQ) for more Videos.All Rights Reserved.
Views: 386 Edupedia World
Oracle User Management Part 1
 
39:07
Oracle DBA User Management Learn subject part 1
Views: 3443 COMBINATIONS FOR ALL
Oracle DML Commands and DDL Commands 2
 
19:55
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
PG-SGA Lecture Dr. Faith Ottery June 2015
 
01:44:46
Lecture on PG-SGA by dr. Faith Ottery, MD, PhD, at the Hanze University of Applied Sciences, June 2015
Views: 449 Pt-Global