Home
Search results “Oracle alter system reset parameter”
10 Oracle XE Installation in Windows 10
 
09:40
Run SQl Command Line connect sys/[email protected] as sysdba show parameter session show parameter processes alter system reset sessions scope=spfile sid='*'; alter system set processes=400 scope=spfile; Restart the database or windows PC Enter “shutdown immediate” Restart your Windows PC To start the database Click on Start All Programs Oracle Database 11g Express Edition Start Database Right click Run as administrator Run SQl Command Line show parameter session show parameter processes There are two ways. One option is to simply open a command prompt and type tnsping xe It should show that its able to ping the db. Other way is to go to Start All Programs Oracle Database 11g Express Edition Get Started If the following page opens up, that means the database is up 127.0.0.1:8080/apex/ WORKSPACE = INTERNAL USER = ADMIN PASSWORD : manager
Views: 765 Middleware_Tech
08 SOA 01 java and orcle XE Installation
 
09:58
After Oracle XE Installation follow the below step : Open SQL Command line : connect sys/[email protected] as sysdba show parameter session show parameter processes alter system reset sessions scope=spfile sid='*'; alter system set processes=400 scope=spfile; Restart DB SOA Installation VERY IMPORTANT NOTE!!!!!!! If you are using Oracle XE as your database, you need to set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE prior to running RCU. Run Below Command From Terminal : set RCU_JDBC_TRIM_BLOCKS=TRUE echo %RCU_JDBC_TRIM_BLOCKS%
Views: 8 Middleware_Tech
Oracle DBA Justin - How to reset RMAN persistent parameters back to their defaults
 
06:47
How to reset RMAN persistent parameters back to their defaults
Views: 2674 jbleistein11
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 278412 Chandra Shekhar Reddy
HOW TO DISABLE USER PASSWORD SENSITIVITY IN ORACLE 11G
 
04:55
HOW TO DISABLE USER PASSWORD SENSITIVITY IN ORACLE 11G ======================================================= show parameter sec_case_sensitive_logon alter system set sec_case_sensitive_logon=false; create user pavan identified by pavan; grant connect,resource to pavan;
Views: 281 Praveen Biyyapu
username password NOT Case sensitive in oracle | Ten Minute Code
 
04:28
Below Code SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE scope=both; ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE scope=both; SELECT username, password_versions FROM dba_users;
Views: 437 Together Oracle
Solving ORA-01033 oracle initialization or shutdown in progress 12c
 
01:26
Solving ORA-01033 oracle initialization or shutdown in progress 12c select name, open_mode from v$pdbs; Solution 1 Alter pluggable database pdborcl open Solution 2 create or replace TRIGGER pdb_startup AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'alter pluggable database pdborcl open'; END;
Views: 10387 khaled alkhudari
Recover Database upto Recent Backup in No Archive mode when  missed all redo groups and any datafile
 
09:40
By Vivek Saxena Shabad Coachings Recover Database upto Recent Backup in No Archive mode when missed all redo groups and any datafile show parameter db_name; startup archive log list alter system switch logfile create table vishu(rn number(10)) tablespace vivek; insert into vishu values(1) commit shut immediate startup ERROR ORA-01257: cannot identify/lock data file ORA-01110: data file shut immediate startup ERROR ORA-00313 open failed for member of log group ORA-00312: online log recover database until cancel //media recovery complete alter database open resetlogs;
Habilitar archivelog Oracle
 
07:48
Comandos utilizados: mkdir -p /u01/app/oracle/oradata/CDB1/archivelog select log_mode from v$database; ALTER SYSTEM SET log_archive_format = '%d_%t_%s_%r.arc' SCOPE=SPFILE; %d = ID do BD %s = Número sequencial do log %t = Número da thread %r = ID de resetlogs. Assegura que nomes únicos sejam criados junto à múltiplas encarnações do BD. shutdown immediate; startup mount; alter database archivelog; alter database open; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/u01/app/oracle/oradata/CDB1/archivelog' SCOPE=BOTH; select log_mode from v$database;
Views: 94 Vídeos Aulas TI
07 Login Profile Parameters in SAP
 
06:58
Login Profile Parameters in SAP
Views: 1322 kumar M
Oracle User account is Locked/Expired & Backup of user account password
 
15:00
This video will cover the trobleshooting steps for follwoing three topics 1) User account in Locked 2) User account is Locked and expired 3) Backup of user account/Reset password Please visit my official website for oracle database training and hadoop blog. https://www.orcldata.com/ Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 how to change expiry date of user in oracle alter user account lock oracle alter user password never expire alter user password expire how to change expired password in oracle sql developer how to unlock oracle user account in 11g oracle system password expired oracle expired(grace)
Views: 475 ANKUSH THAVALI
Oracle Database Users / User Management (Simple)
 
09:33
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Views: 41424 Abbasi Asif
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: 16861 Techies Digest
ORA-01017: invalid username/password; logon denied | Oracle apps
 
03:48
The SEC_CASE_SENSITIVE_LOGON initialization parameter gives control over case sensitive passwords. If existing applications struggle to authenticate against 11g, you can use the ALTER SYSTEM command to turn off this functionality. ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;
Views: 310 Young India
Oracle DBA Justin - How to reset a user accounts password in an Oracle database
 
11:26
How to reset a user accounts password in an Oracle database
Views: 21803 jbleistein11
Oracle password file creation and usage  | manage password file in oracle
 
12:23
Oracle password file creation and usage
Views: 8112 Wysheid Wysheid
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►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 [email protected] 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: 83858 Manish Sharma
BluePrism - Environment & Session Variables || Reality & Useful
 
35:23
Hi Friends, Let's come into the development/implementation part. Environment variables We have two types of environment variables, mean we can declare process level and business level in System Manager. See here, You saw this, I created one environment variable in Business level but I can see under process also. Then why the tool differentiated under process and business object? It's a categorizing the variables that's it. we will access the created environment variable in process Here is my process, let's access the varible into internal data item. I Created the local data item. to access the environment variable configure the local data item. We have the Expose option in data item, open it and see 'Environment - Read the corresponding Environment variable from System Manager' But I didn't find my 'hello' variable. Let's close and reopen it. See I got it and select the env variable name from the list. But how can I see value for that environment variable. Let's do it. 1. I created another local variable and using calculation stage copying the value from configured data item to local variable. Can we edit the environment variable value? Try that once. See, before executing the bot while reset, I am getting error message open and see that what is the message 'Cannot store data in an environment variable' even If you run it won't work. See that I got the internal exception. Environment variables are final variables, once you declare the varible only you can change the value in System Manager and cannot be possible through process/Business Object. ----------------------------------------------------------------------------------- Let's create/open another process or business object and see can we able to access the same environment variable or not? See I got the environment variable and it's value in newly created process. ------------------------------------------------------------------------------------ Now we will see about Session Varible. let's revert the code of existing process as I will concatenate the environment variable value to local variable and storing the result into local variable. Let's run and check it. I got the concatenated value. If we run through control room can we see these value? Let's publish our process and run it from control room. process started and finished. Where we can see the session variables. There is a link to see session variables 'Show Session Variables' I enabled, let's run and check it Started and finished, but we cannot see the data item value. Because we didn't configured the data item to show in session variables list. For this, we need to expose the local data item to show in session variables list. Open the process and open the data item and choose the option called 'Session - Expose the data item to Control Room' Now run and check it once We did the right way to show the data item in session variables list but why can't we see the variable value? To that the process/business object show wait for some to before complete it. Because our process is very small. let's use the wait stage before end Ohh! We don't have wait stage in process, how use the sleep Action in General Business Object. drag the Action stage and choose the values. I choosen the 'Utility - General' and Sleep and passed the how many seconds should wait our process let's run and see it See that while the process is in running mode we can see the configured session variable. After finished the process it's gone. Thank you for watching video
Views: 10018 Reality & Useful
Oracle DBA Justin - How to kill an RMAN session
 
10:38
How to kill an RMAN session
Views: 3823 jbleistein11
Oracle Password File and Password Complexity
 
12:25
Oracle Password File and Password Complexity
Views: 813 The Silent DBA
can we shutdown a database when it is in backup mode
 
02:28
can we take hot backup when the database is in noarchive log mode? =================================================================== no archive log list; alter database begin backup; can we shutdown a database when it is in backup mode? ===================================================== alter database begin backup; shutdown immediate; ==no shutdown normal;==no shutdown transcational;==no shutdown abort;==yes database is in hot backup mode,db crashes now how to recover and open the database? =================================================================================== alter databse begin backup; shutdown abort; ORA-10873: file 1 needs to be either taken out of backup mode or media recovered ORA-01110: data file 1: 'E:\DATABASE\DATABASE\ORADATA\ORCL\SYSTEM01.DBF' solution: startup mount; alter database end backup; alter database open; how to check whether the database is in backup mode or not? =========================================================== select * from v$backup; how to take hot backup of database manually? ============================================ alter database begin backup; copy datafiles manually from original location to backup location alter database end backup; alter system switch logfile; alter system switch logfile; alter system switch logfile; copy archives from archive location to backup location. alter database backup controlfile to trace; (or) alter database backup controlfile to location; copy controlfile to backup location. How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 315 Praveen Biyyapu
Oracle DBA Justin - How to use the RMAN keep until time retention policy
 
15:58
How to use the RMAN keep until time retention policy
Views: 3658 jbleistein11
Oracle DBA Justin - PL/SQL # 2: How to use comments/remarks
 
06:39
How to use comments/remarks
Views: 2052 jbleistein11
Oracle DBA Justin - How to unregister a target database from an RMAN recovery catalog
 
13:32
How to unregister a target database from an RMAN recovery catalog
Views: 3952 jbleistein11
5  Update User information with Session to get current Database values on Update page with JSP Servl
 
24:05
Update User Info with session Current user values will be available in text boxes and drop downs modify any field if you want to and save changes to reflect in database detailed code using JSP and Servlet
Views: 10707 Joy Hadoop
How to find Oracle Service Name by sql command
 
01:40
If you have an Oracle database on your network which is able to connect to with Oracle SQL Developer, using hostname, port, username, password and the SID. you need to connect another application, however it uses the Service Name instead of the SID. it is the way for to you to determine the SERVICE_NAME of the database when you am connected in SQL Developer via the SID thanking you... just share this video to your friends...
Views: 16579 w3h
Oracle DBA | How To Enlarge The Database | Bangla | DBA1-16
 
07:09
Oracle DBA | How To Enlarge The Database | Bangla | DBA1-16 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 Dear viewer, In this tutorial you will know How To Enlarge The Database. Ways of Enlarging The Database: You can enlarge the database in the following ways: -Creating a new tablespace -Adding a data file to an existing smallfile tablespace -Increasing the size of a data file -Providing for the dynamic growth of a data file. Increasing the size of a data file: Command: sql- alter database datafile 'E:\app\Administrator\oradata\orcl \dfile1.dbf' resize 500m; Providing for the dynamic growth of a data file: sql- create tablespace test3 datafile 'E:\app\Administrator\oradata\orcl\dfile3.dbf' size 300m autoextend on online extent management local uniform size 5m 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: 83 OracleDB Solutions
RHCE EX300 exam: Configure an iSCSI initiator on Red Hat Enterprise Linux
 
15:08
RHCE EX300 exam: Configure an iSCSI initiator (client) on Red Hat Enterprise Linux --- Our given task is: Configure an iSCSI initiator. Configure system2 so that it connects to the iqn.2017-04.com.example.domain9:system1 target on system1 as follows: - The iSCSI device should automatically be available on system boot. - The iSCSI block device contain a 1700 MiB that is formatted as ext3. - The partition is mounted to /mnt/data and is automatically mounted to this directory at system boot. --- Fist we have to install iscsi-initiator-utils package: yum install -y iscsi-initiator-utils Once iscsi-initiator-utils package is successfully installed we have to modify initiatorname.iscsi file: vi /etc/iscsi/initiatorname.iscsi InitiatorName musts be equal to the name which we had already set up on the iSCSI target. You can confirm iSCSI initiator name on iSCSI target server by running targetcli command. Initiator name can be found under acls in targetcli environment. Enable iscsi service to start automatically during system startup: systemctl enable iscsi Double-check that iscsi service is enabled to start automatically after system startup: systemctl is-enabled iscsi Start iscsi service: systemctl start iscsi Please do not confuse iscsi service with iscsid service. If you start iscsi service it will start iscsid service for you as well. iscsi service will: - start iscsid service. - login initiator to target after system startup. - logout initiator from target before system shutdown. If you will start only iscsid service instead of iscsi service it will not login initiator to target after system startup and iscsid will not logout initiator from target during system shutdown which may result to system hang during shutdown. Next step is to discover targets on our iSCSI server system1. Command to discover targets can be found in EXAMPLES section of iscsiadm man page. iscsiadm --mode discoverydb --type sendtargets --portal 172.24.9.10 --discover Node record id found by the discovery (output of above command) will be used to login to the target. Command to login to the target can be found in EXAMPLES section of iscsiadm man page again. iscsiadm --mode node --targetname iqn.2017-04.com.example.domain9:system1 --portal 172.24.9.10:3260 --login Verify that iSCSI disk device was picked up successfully. Presence of the new iSCSI disk can be confirmed in /var/log/messages file, output of dmesg command and in the output of various Linux tools: iscsiadm -m session -P3 | grep Attached lsscsi -s WHERE: -s option prints disk capacity in human readable form. lsblk lsblk --scsi fdisk -l | grep Disk cat /proc/scsi/scsi cat /proc/partitions Connection parameter defaults can be found in default file. /var/lib/iscsi/nodes/iqn.2017-04.com.example.domain9:system1/172.24.9.10,3260,1/default Once iSCSI disk was successfully added yo our Linux server, we will create disk partition, filesystem and we will modify /etc/fstab file to ensure that filesystem will be mounted after reboot as well. To create disk partition we will use fdisk command. Once disk partition with requested size is successfully created - we will create ext3 filesystem with below command: mkfs.ext3 /dev/sda1 NOTE: On your RHCE exam requested filesystem type can be xfs, ext4 or vfat. Create directory for mount point: mkdir /mnt/data Update /etc/fstab file with entry related to your newly created filesystem on your new iSCSI storage. You have to specify _netdev option for new filesystem created on iSCSI storage otherwise mounting of filesystem will fail because it will happen before network services will be up and running. If you will specify _netdev option - system processes will know that they have to wait and try to mount network filesystem once network will be fully operational. Mount new filesystem: mount /mnt/data Verify the size of the new filesystem: df -h /mnt/data Related Video Tutorials: RHCE EX300 Exam: RHCE EX300 exam: Configure an iSCSI target on Red Hat Enterprise Linux https://youtu.be/vF3YFVqwLT0 RHCSA Fast Track course: Reset forgotten root password in Redhat 7: https://youtu.be/cUG16kdYCxE Setting up network using a NetworkManager command line interface (nmcli) in Red Hat 7 https://youtu.be/v-soSvSsw18 nmcli cheat! Setting up network using nmcli in Red Hat 7 in less than a 30 seconds - QUICK & EASY!!! https://youtu.be/NqEuucdSS60 Setting up network using a NetworkManager text user interface (nmtui) in Red Hat 7 - EASY!!! https://youtu.be/IKH1sCEjG2A Setting up network in Red Hat 7 in less than a minute https://youtu.be/TqMdzTPsjJY Shrink ext2 ext3 and ext4 file system and reduce the size of a logical volume with only one command. https://youtu.be/tTpStv6cfeQ Complete guide to file system shrinking and reducing the size of the underlying logical volume. https://youtu.be/8AD8ZiYDavY Other related video tutorials: NetworkManager connection priority - manage network profile priority in Linux: https://youtu.be/21SIHo_Rc_M
BluePrism - Collections || Reality & Useful || Reality & Useful
 
27:24
Hi Friends, Now we will discuss about collections How to add rows to collections. and additional Actions on collections. -------------------------------------------------------------------------- Basically we call add rows to collections using two ways. using internal VBO as 'Collections' using 'Utility - Collection Manipulation' VBO Let's see 1. create a process in Blueprism 2. Let's create a collection and add rows to that collection using internal VBO 3. I was added two fields named as 'No' and 'Name' 4. Use Action stage to add empty row to collection. choose the Action 'Add Row'. It is expecting the one parameter is collection name in the form of text type. 5. Now we need to add data for the empty row. 6. Use multi calculation to add data to collection in the empty row. 7. As of now I am adding the data with hard coded format Let's run and check it. If I run again it will add another row If you do reset, we loose the data. But If my data is available in Data Items then Instead of hard coding the values use data items. drag two dataitems and use them in the multi calculation stage Initialize the data items with values If I run this will add same data. So, I want to make this dynamic using the Counter After adding the data to collection I will increment the collection and I will use this Counter in the Multi Calculation stage See, everytime I am setting the Next stage to start and running and the data getting populated to collection. Instead of that I will design like loop till Counter reaches to 6 See we got the data. Now we will use 'Utility Collection Manipulation' to add rows to collection. For this we need to add rows using another collection. 1. Create dummy collection matches the field names. For this, I am copying the existing collection and rename to dummydata. 2. Initially I am adding the two records to dummydata collection. 3. Now after the Counter reaches to 6 I will add these dummydata to existing empdata collection. Use 'Append Rows to Collection' Pass the input and output parameters as Main Collection - Out main collection is 'EmpData' Collection to Append - Which collection records we are adding to 'EmpData' Combined Collection - Final collection get's stored in 'EmpData' See, the collection has the another collection data. Once we done adding the dummydata collection records, let's remove the records in 'Dummydata'. Using internal Business Object, use 'Remove All Rows' Action Remove records will remove the currently added records, not from the initial records. That's why we will remove from 'EmpData' collection to see the result See that, records added and finally removed. Thank You for watching video
Views: 11538 Reality & Useful
Oracle DBA Justin - How to multiplex RMAN backup pieces when running a backup
 
13:00
How to multiplex RMAN backup pieces when running a backup
Views: 4259 jbleistein11
[1.0 SPS 12] SAP HANA Express Edition: Setup, Static IP for VM - SAP HANA Academy
 
06:13
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVy6nOZMFZIZxcvBCoRdshsR In this video tutorial, Denys van Kempen shows how you can configure a static IP for the SAP HANA express edition VM. Thank you for watching. Video by the SAP HANA Academy.
Views: 5035 SAP HANA Academy
Complete guide to file system shrinking and reducing the size of the underlying logical volume.
 
13:31
The Complete guide to ext2, ext3 and ext4 file system shrinking and reducing the size of the underlying logical volume in Linux. Red Hat Enterprise Linux v7 - RHCSA EX200 exam task: reduce the size of a file system. If you will be shrinking the size of the file system in your production Environment in work there are two things which you have to consider: 1) file system type musts support shrinking - XFS which is default file system in Red Hat Enterprise Linux 7 does not support shrinking at all. 2) ext2, ext3 and ext4 file systems don't support on-line shrinking so they must be unmounted during shrinking. Also best practice is to have up to date backup before you perform file system shrinking. So our given task is to shrink file system /u03 to 1GB. --- 1) First we will run "df -h" command to find out current size of our /u03 file system. 2) We will run "mount | grep u03" command to find out what is the type of the file system. 3) ext2, ext3 and ext4 file systems don't support on-line shrinking so we will unmount the file system with command: unmount /u03 4) Before we will shrink file system we will perform file system check with command: e2fsck -f /dev/datavg/lv_u03 where: -f option will force checking even if the file system seems clean. NOTE: you can use both /dev/mapper/datavg-lv_u03 or /dev/datavg/lv_u03 as parameter to command e2fsck and commands which we will use later because both of /dev/mapper/datavg-lv_u03 and /dev/datavg/lv_u03 are symbolic links to /dev/dm-4 in our case. 5) Now we can shrink file system with command: resize2fs -p /dev/datavg/lv_u03 1G where: -p option prints out a percentage completion bars for each resize2fs operation, so we can track what the program is doing. 1G : will set the size of the file system to 1GB - you can use M for Megabytes or K for kilobytes. 6) We can use output of resize2fs command to calculate new exact size of the logical volume. Size of the Logical Volume should be the same as size of a file system. It is not efficient but logical volume size can be a little bit bigger then size of the file system - we can then for example extend file system size to match logical volume size, but size of the logical volume can not be smaller then size of the file system. 7) Reduce the size of logical volume to 1GB: lvreduce -L 1048576K /dev/datavg/lv_u03 where: -L 1048576K : will set the size of the logical volume to 1GB you can use M for Megabytes or G for gigabytes and so on … NOTE: you can use also below alternatives to lvreduce command in our scenario: lvreduce -L -3145728K /dev/datavg/lv_u03 where: -3145728K means that current size of logical volume will be reduced by 3145728K or lvreduce -l 256 /dev/datavg/lv_u03 where: -l 256: means that size of the logical volume will be set to 256 logical extents which is 1GB in our scenario because size of logical extent is 4MB in our case or lvreduce -l -768 /dev/datavg/lv_u03 where: -l -768 means that size of the logical volume will be reduced by 768 logical extents which is 3GB in our scenario because the size of the logical extent is 4MB in our case. NOTE: You can find out size of the logical extent by running “vgdisplay datavg”. 8) Now we will check file system once again with command: e2fsck -f /dev/datavg/lv_u03 where: -f option will force checking even if the file system seems clean. 9) We will mount file system mount /u03 10) We will verify the NEW size of the file system with command: df -h /u03 --- File system shrinking and reducing the size of the underlying logical volume with only one command. In this case we will shrink /u02 file system from 4GB to 1 GB again. 1) First we will run "df -h" command to find out current size of our /u02 file system. 2) Shrink file system and reduce the size of underlying logical volume: lvresize -L 1G -r /dev/mapper/datavg-lv_u02 where: -L 1G : will set the size of the logical volume to 1GB. You can use M for Megabytes or K for kilobytes and so on ... -r option will re-size the file system together with the logical volume. Command "lvresize -L 1G -r /dev/mapper/datavg-lv_u02" performed all tasks which we had to do manually before: - unmounted our file system - performed file system check - shrank file system to 1GB - and also reduced the size of logical volume to 1GB as well. 3) We will confirm new size of the file system with "df -h /u02" command. --- Please remember that - first you have to shrink size of the file system - and only after size of the file system has been successfully reduced then you can reduce size of the underlying logical volume. --- Related Video Tutorials: RHCSA Fast Track course: Reset forgotten root password in Redhat 7: https://youtu.be/cUG16kdYCxE Shrink ext2 ext3 and ext4 file system and reduce the size of a logical volume with only one command. https://youtu.be/tTpStv6cfeQ === I am currently working on: Shrink ext2 ext3 and ext4 file system and recreate underlying disk partition with smaller size.
how to create user and profile
 
09:48
for more vedios www.oraman.in
Views: 461 oramandba
RedHat Enterprise Linux 7.6 Installation in VirtualBox 5.2 | RHEL 7.6 Released
 
06:29
This video demonstrates how to install RedHat Enterprise Linux 7.6 Installation in VirtualBox 5.2 step by step. Redhat Enterprise Linux 7.6 New features and Enhancements. ########################################################## Kernel Parameter Changes. In-place upgrade from Red Hat Enterprise Linux 6 to Red Hat Enterprise Linux 7 Certificate System now supports additional strong ciphers by default samba rebased to version 4.8.3 Directory Server rebased to version 1.3.8.4 Certificate System rebased to version 10.5.9 jss rebased to version 4.4.4 The CRMFPopClient utility supports CRMF requests without key archival Certificate System automatically applies ECC profiles when setting up root CA with ECC certificates Certificate System now adds the SAN extension to server certificates A low-level API to create X.509 certificates and CRLs has been added to JSS Pacemaker now supports path, mount, and timer systemd unit files GNOME Shell rebased to version 3.28 FreeType rebased to version 2.8 xorg-x11-server rebased to version 1.20.0-0.1 The CephFS kernel client is fully supported with Red Hat Ceph Storage 3 XFS now supports modifying labels on mounted file systems pNFS SCSI layout is now fully supported for client and server A new network-scripts option: IFDOWN_ON_SHUTDOWN Improved content of error messages in network-scripts Installing and booting from NVDIMM devices is now supported Support for the libnftnl and nftables packages ECMP fib_multipath_hash_policy support added to the kernel for IPv4 packets Support for hardware time stamping on VLAN interfaces Support for specifying speed and duplex 802-3-ethernet properties when 802-3-ethernet.auto-negotiation is enabled Support for changing the DUID for IPv6 DHCP connections ipset rebased to Linux kernel version 4.17 firewalld rebased to version 0.5.3 Clevis now supports TPM 2.0 gnutls rebased to 3.3.29 sudo rebased to version 1.8.23 rear rebased to version 2.4 NVMe driver rebased to version 4.17-rc1 cockpit rebased to version 173 and more.
Views: 633 java frm
How to download and Install MySql (Open source Database)
 
09:23
How to download and Install MySql (Open source Database). How to Download the MySQL? How to install MySql database. Thanks for watching my videos regularly and motivate me to touch the another milestone. Please subscribe my channel "Learn TechToTech" My Website : www.learnfromrakesh.com My Twitter Account : https://twitter.com/LearnTechtotech My Facebook Account: https://www.facebook.com/LearnTechToTech
Views: 338 Learn TechToTech
Windows CredSSP Encryption Oracle Remediation policy
 
04:07
#ItTechTools #Windows #howto Please Subscribe and Like How to fix CredSSP encryption oracle remediation Error while connecting Remote Desktop. This error occurs if you are trying to establish an insecure RDP connection, and the insecure RDP connection is blocked by an Encryption Oracle Remediation policy setting on the server or client. This setting defines how to build an RDP session by using CredSSP, and whether an insecure RDP is allowed. To resolve the issue, install CredSSP updates for both client and server so that RDP can be established in a secure manner. There is another two ways to correct the issue. Through registry and Group Policy Editor. Through Policy Editor. 1. Run gpedit.msc to open Group Policy Editor 2. Navigate Software Settings\Administrative Templates\System\Credentials Delegation\Encryption Oracle Remediation 3. Right Click and Edit Encryption Oracle Remediation and select enabled 4. Select Protection level as “Vulnerable” 5. Apply the settings and Click OK 6. Connect RDP Through registry. 1. Press Windows Key + R and type regedit 2. Navigate Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System\CredSSP 3. Create new Key “CredSSP” 4. Create another Key under CredSSP “Parameters” 5. Create a new value under Parameters DWORD 32 bit Value “AllowEncryptionOracle” 6. Modify the value Data to 2 7. Connect RDP FB : https://www.facebook.com/ittechtools
Views: 37 IT TeCH TOOLS
Reset SA password in SQL Server
 
02:46
In this video you will see how to reset your SA (System Administrator) password in SQL server by using very simple query or using GUI of SQL Server Management Studio...
Views: 58073 Barlet Hamzai
SQL: Change User Password
 
02:38
In this tutorial, you'll learn how to change user password in sql plus PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 8389 radhikaravikumar
How to Set Environment Variables in Linux
 
00:56
Follow this tutorial to learn how to set shell environment variables in a Linux operating system like Ubuntu. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, you will learn how to set environment variables in linux. Linux based operating systems use bash shell. The shell environment variables are used for several purposes, from storing data, storing software configurations, set terminal settings, and changing shell environment. The environment variables are normally created by the operating system during installation, or by different software as per the required need. Apart from that, in linux, to set environment variables, we first need to access the terminal application. That's because the user has the privilege to add, edit, and remove different variables at will. Step # 1 -- All variables on terminal In linux, to set environment variables we first need to access shell environment variables. For that, we will need to open the terminal by searching for it in the applications menu, or selecting it from the dock on the left. Once the terminal is opened up, to check for all environment variables, type the set command and press enter. This will list all the environment variables stored in the shell. Step # 2 -- One variable at a time The amount of these variables can become a very long list and locating one specific variable can become a tough task. Fortunately Linux allows us to display the value of one shell variable by using the echo command along with the name of the variable. This makes the task very easy. Step # 3 -- Changing a variable Now, to add or modify an environment variable, we can use the export command followed by the name of the variable and the values that go with it. Multiple values for a variable need to be separated by a colon. The colon indicates to the operating system that one value has ended and another has begun. The variables can be created and removed from the shell easily, and can be done whenever required. But changing important variables may mess with the operating system's functionalities so it's important to be careful. And that's basically all you need to know for how to set environment variables in Linux.
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 17581 radhikaravikumar
How-to Pass Parameter to Report Viewer
 
04:48
Using asp.net to pass values using parameters.
Views: 175234 CAFE ASP
How to change B2B DataExchange  system properties by repoutil command line
 
04:00
Agenda of this video includes: - What is Repoutil - Configuration file (Properties.txt)
Views: 187 Informatica Support
Unix shell script to read password but password is not displayed on the screen
 
04:19
Oracle SQL PLSQL and Unix Shell Scripting
Views: 823 Sridhar Raghavan
Configuring URL and Browser Settings for Altru Web Forms
 
01:55
This two-minute video explains how to configure the URL and Browser Settings as part of Altru Web forms configuration. This setting is important for what displays in your Web forms browser title bar and for where users are redirected if they access a Web form page that is no longer available.
Views: 361 BlackbaudSupport
Power BI parameters - Updating in the Power BI Service or with APIs
 
09:08
In this video, Adam looks at how you can update Power BI parameters within the service or by using APIs. You can create Power BI Parameters within Power BI Desktop using Power Query. Then you can update those Power BI parameters once the report is published to the Power BI service. PowerShell Samples: https://github.com/Azure-Samples/powerbi-powershell LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 8795 Guy in a Cube
04.27_Oracle_10gR2_RAC_4.27 Verify TNS Networking Files.avi
 
02:58
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Building an Oracle RAC 10gR2 (10.2.0.3) on Linux 4.1 Install Linux OS(CentOS 5.3) - () 4.2 Install Required Linux Packages for Oracle RAC - (Video) 4.3 Network Configuration - (Video) 4.4 Create "oracle" User and Directories - (Video) 4.5 Configure the Linux Servers for Oracle - (Video) 4.6 Configure the "hangcheck-timer" Kernel Module - (Video) 4.7 Configure RAC Nodes for Remote Access using SSH - (Video) 4.8 IP SAN Configuration - Openfiler - () 4.9 Install Openfiler - SAN - () 4.10 Configure iSCSI Volumes using openfiler - (Video) 4.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 4.12 Install and configure Oracle Cluster File System(OCFS2) - (Video) 4.13 Install and Configure ASM (ASMLib2.0) - (Video) 4.14 Download Oracle RAC 10g Software - (Video) 4.15 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 4.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 4.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 4.18 Install and configure Automatic Storage Management (ASM) - (Video) 4.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 4.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 4.21 Install Oracle Database 10g Companion CD Software - (Video) 4.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 4.23 Create TNS Listener Process - (Video) 4.24 Create ASM Instance - (Video) 4.25 Create a Cluster Database - (Video) 4.26 Post-Installation Tasks - (Optional) - (Video) 4.26.1 Re-compile Invalid Objects - (Video) 4.26.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 4.26.3 Create Shared Oracle Password Files - (Video) 4.27 Verify TNS Networking Files - (Video) 4.28 Create / Alter Tablespaces - () 4.29 Verify the RAC Cluster & Database Configuration - (Video) 4.30 Configuring the Initialization Parameters - (Video) 4.31 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 97 Yongcheng Lai
recover manager scenario 7   restore recover datafile to different locations
 
15:27
In this tutorial you will learn how to restore recover datafiles to different locations.
Views: 141 DBA Pro
02.15_Oracle_10gR2_RACDG_2.15 Upgrade Oracle Clusterware
 
09:15
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 270 Yongcheng Lai