Search results “Oracle permission on directory”
Error in writing to directory temp oracle universal installer needs you to have permission
error in writing to directory temp oracle universal installer needs you to have permission in this area to install. installation cannot continue . please make sure temp is set to a valid writable directory.
Oracle Export Data and Import Data using DataPump
Steps to Import and Export Table Step 1: Create Directory Step 2: Grant Read and Write Permission to Directory Step 3: GRANT ROLL DATAPUMP_EXP_FULL_DATABASE to user Step 04: Use EXPDP and IMPDP to Export and Import data
Views: 6218 Data Science Center
How to create an user and to grant all privileges to them in Oracle database
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 37372 Thamizharasan Mohan
How to fix "insufficient privileges to access this directory" error
Problem: While installing a program, the user receives the following error message: "The installer has insufficient privileges to access this directory". Solution: 1. manually create the required folder, 2. download the compressed registry file : ► https://drive.google.com/open?id=0Bw-8fzdMfWSFREZUTzZqNFROWkk 3. extract the contents to a folder you like, 4. double-click the "Take Ownership.reg" file to add it to the Windows Registry, 5. go to the folder that you manually created, right-click on it, click "Take ownership" 6. try to continue the setup, click Retry.
Views: 159625 furulevi
How to Create/Change User Role and Permissions on the Oracle ZFS Storage Appliance
Learn from Oracle's Storage Consultant, Darius Zanganeh, how to setup users and user roles for administration of the Oracle ZFS Storage Appliance through its BUI. Step-by-step instructions are given with details on how to setup permissions and other options/rules you can assign to the user such as assignment for projects or pools. For more training and information, go to http://www.oracle.com/oll/zfssa 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.
Assigning Permissions to Catalog Objects Using Oracle BI EE
This video teaches you how to assign permissions to an analysis and dashboard page. To find out more about Oracle BI EE, see the documentation at https://docs.oracle.com/en/middleware 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.
Role Based Access Control
This video is part of the Udacity course "Intro to Information Security". Watch the full course at https://www.udacity.com/course/ud459
Views: 61827 Udacity
Cool Commands: How Do I Change Permissions on UNIX Files or directories?
For more information, please visit: http://emc.im/6058BkskG Learn how to use the chmod command to change the access permissions on UNIX files or directories on your EMC Isilon cluster. For more information about the chmod command, see the man page (man chmod). For more cool commands, check out the ClusterTalk podcast on the EMC Community Network.
Views: 2534 Dell EMC
1_2 Create user & Home Directory for Oracle
create oracle user and home directory for the installation of Oracle 11g R2 on Redhat Enterprise Linux 7
Views: 259 Rinku Kumar Singh
You need permission to perform this action!! - Howtosolveit
Fix You need permission to perform this action windows 10,8,7. Folder access denied unable to delete folder. You need permission to perform this action" error message. Trying to copy a file, "You need permission to perform this action". you require permission from administrators to make changes to this folder. Download TakeOwnership reg file https://drive.google.com/open?id=0B1Y9NvUQRfxcQkVpQnd4blRvNlE .Thanks for watching Howtosolveit Channel. http://www.youtube.com/c/Howtosolveit #Howtosolveit #Howtosolveit
Views: 514837 Howtosolveit
Changing Directory and File permissions using chmod with alpha syntax in Solaris
This is a simple explanation of changing permissions using 'chmod' and alpha syntax on directories and files in Solaris Disclaimer, These videos are nothing fancy. Just getting to the point for education and information as a supplement to classes taught.
Views: 186 Christine Gidzak
Linux File And Directory Permission - Part 1
Subscribe to our channel here for notifications on new video trainings. For more videos on technology, visit our website at http://www.techytube.com. By [email protected], for more from this author visit: http://www.techytube.com/author/suphalb This Video Will help you to learn how to Change, Modify, Customize, Apply permissions on linux files and directories for User, Group and others by using chmod command with associated options and syntax. I described in these video both integer and alphabetical permission format to change permission for your desired files and directories explicitly for any particular user group and others. Please follow these video step by step to know how to apply and execute chmod command for files and directory on your Linux System. To be master on chmod please watch all of the 3 parts of these videos. Please keep visiting TechyTube.com on regular Basis to know and learn more with new technologies and their implementation. We always work hard to present you latest and important technical videos, articles based on real hands on experience. Keep visiting and enjoy our resources. Thanks TechyTube Team
Views: 2563 techytube
ORA 01031 insufficient privileges on windows 10
How to fix ORA-01031 insufficient privileges Connect as sysdba and restart database Oracle Database 11G R2
Views: 4805 zali go
Creating Users in Oracle OBIEE and WebLogic - Oracle OBIEE Training
This video tutorial demonstrates how to create an OBIEE user through the WebLogic Console. We also show you the relationships between the users and groups, as well as groups and application roles. Check out all of our OBIEE online training courses here - https://www.fireboxtraining.com/obiee-training
Views: 15536 Firebox Training
ORA-01031 insufficient privileges  -- Windows OS
when you connect to oracle database trhrouout sqlplus as sysdba by the command line (CMD) on Windows OS some times you face that you cannot connect to oracle due to oracle error OR- 01031.
Views: 39844 Abdulhakim Desuki
Server 2008 Lesson 10 - Sharing Folders and the File Services Role
In this lesson I install the File Services Role and share a folder from the Microsoft Windows Server 2008 R2 operating system. I install the role to make the appropriate changes to the OS to allow for file sharing. I then create a folder and use the Advanced Sharing options to share it and add sharing permissions to the Domain Users group. I then add the Domain Users to the Security (NTFS) permissions as well. Both permissions have to be set and the more restrictive of the two will trump the other. I test two folders with differing permissions on a client computer to see the affects. This video is part of the Server 2008 R2 Series from Lecture Snippets. The materials need to complete the lessons on your own include a disk image of Microsoft Windows Server 2008, Microsoft Windows 7, and the free download from Virtualbox.org to run the virtual machines. For more information and a complete list of the lessons visit Lecture Snippets at http://lecturesnippets.com.
Views: 153792 Lecture Snippets
How To Delete A Folder That Won't Delete [SOLVED] Windows 7/8/10
This is the real way to delete a folder that will not delete from your desktop. This is a voice tutorial very easy to follow. Subscribe! Check my download page: http://dewclarke.com Like this Video Follow on Twitter @DewClarke If it's still not working download this program: 1. https://goo.gl/cl2Drh 2. http://adf.ly/7277656/folder-remover How To Delete A File That Won't Delete Tutorial 2013 2014 2015 2016 2017 2018 2019 2020 cd /d c:\Users\YourUserName\Desktop press enter dir /x press enter rmdir /q /s your file name press enter Howto Tutorial DewClarke This tutorial addresses the following issues: I cannot delete a file on my desktop. How to delete an undeletetable file. Can't delete a file? Here's how to do it. I cannot delete a file in Windows XP for some reason, help! You cant delete a file or folder on a NTFS system volume. Cannot Delete a file or Folder in Windows 7. Help me delete a file off my desktop for Windows 7. Solved - cant delete a file. Access is denied and I cannot delete this folder from my computer. In Windows Vista, I cannot delete a file from the desktop. Unlocker - how can i delete afile that was saved to my desktop? My problem is that I cannot delete a file after checking the properties, Read Only isn't checked. You cannot delete a foler, here is a solution. How to fix "cannot delete folder". If you cannot delete a desktop folder, try this. It's not a permission problem, you simply cannot delete the file. You can't rename the file or folder. Microsoft article Q320081 helps with this problem in this video. I think a security update KB has made it so that I cannot delete a file. I can't delete a file that is using ACL Access Control List and I have changed the permissions on the file, help! I have already taken ownership of the file and cannot delete it. An error message pops up that says the file is being used but it is not. Is my file/folder corrupt and not allowing my to access it? The file has an invalid name and now I cannot delete it. The administrator has not allowed me to access my file, and I get an "Access is Denied' Error". does Lock Hunter work with deleting foles that are being used by other programs? Is there a easier way? Empty folder wont delete and I cannot delete the file in safe mode either. I can't delete an empty folder. Renaming the folder give you an error when trying to delete. I cannot delete a folder in windows.
Views: 1069731 DewClarke
How To Setup Shares, Groups  & User Permissions in FreeNAS 11
Amazon Affiliate Store https://www.amazon.com/shop/lawrencesystemspcpickup Things we love including computers, software, services, gadgets, and of course hot sauces. https://www.lawrencesystems.com/things-we-love/ Tutorial: How To Setup Shares, Groups & User Permissions in FreeNAS 11 https://winscp.net/eng/download.php https://twitter.com/TomLawrenceTech https://www.lawrencesystems.com/ https://forums.lawrencesystems.com/
Set Permission to htdocs (lampp ubuntu)
explain how to set permission to htdocs folder in lampp (linux ubuntu)
Views: 7514 Edi Prasetyo
How to Delete Undeletable Files & Folders in Windows 10/8/7 (No Software)
Cannot delete file: Access is denied Could not find this item There has been a sharing violation. The source or destination file may be in use. The file is in use by another program or user The file or directory is corrupted and unreadable. Make sure the disk is not full or write-protected and that the file is not currently in use. Facebook Page : https://www.facebook.com/MeMJTube Follow on twitter: https://twitter.com/mj1111983 Website : http://www.bsocialshine.com
Views: 176863 MJ Tube
Folder Access Denied: How to delete any folder in Windows 10
This is a tutorial on how to delete folders in Windows 10 which can not be deleted due to a "Access denied" error. This video shows you how to take ownership of the folder to delete the folder. Steps have also been listed in this pastebin: https://pastebin.com/fPtsJP50 --- Clouds by Joakim Karud http://soundcloud.com/joakimkarud Music provided by Audio Library https://youtu.be/YrvBTBmqVPE ---
Views: 51920 Max Mustermann
Create user, connection, role and grant, evoke permission in Oracle 11g
This video will show you: - How to create user - How to create role - How to create new connection - How to grant permission to user/role - How to grant role to user - How to revoke permission
Views: 1279 Progtips 4 Devs
How to find out the SID and DB Home in Oracle Database by Manish Sharma
What is my SID, Where is my DB Home in Oracle Database? Are these questions haunting you? Here's How to find out the SID and DB Home in Oracle Database by Manish Sharma from RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/sid_dbHome Previous Tutorial ► How to connect to your Pluggable Database using SQL Developer https://youtu.be/1gvN1A6xnxU ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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 #Oracle18cByRebellionRider #RebellionRider
Views: 1217 Manish Sharma
How to fix fatal internal error  cannot create  temporary directory error
In this video internal error cannot create temporary directory windows 8 , 7 and 8.1 applications and software dose not install.
Views: 57003 usmanalitoo
How to enable a Virtualbox shared folder for Debian, Linux Mint/Ubuntu, Arch Linux guest systems
You want to share files between your main system and the system you installed in a VirtualBox. Watch this video and you will lean how to enable a shared folder between your main system and your Virtualbox linux systems including Arch Linux, Debian, Linux Mint / Ubuntu. More Arch Linux videos: https://www.youtube.com/playlist?list=PLSmXPSsgkZLt66s-M_gfQtMakc8iYJY6M More Debian videos: https://www.youtube.com/playlist?list=PLSmXPSsgkZLtSGWdxu_vayfotqMCMzZl- More Linux Mint videos: https://www.youtube.com/playlist?list=PLSmXPSsgkZLsiemyy_Rzcqf_0iED8ZfHS There are several essential steps to enble a shared folder between your guest system and your host system. The guest system is the system installed in the Virtualbox, the host system is you main system installed on your hardware. 1. You need to install guest additions for your guest system. 2. Create a shared folder between your host to your guest systems. 3. Change the user permission for a shared folder - so you can access the shared files from your guest system without root privileges. After these steps all files created in this shared folder will be available in both the host and the guest systems. 1:06 Arch Linux guest system Make sure your Arch Linux guest system is up to date: sudo pacman -Syu Install linux headers: sudo pacman -S linux-lts-headers or sudo pacman -S linux-headers Install virtualbox-guest-utils: sudo pacman -S virtualbox-guest-utils for linux kernel choose virtualbox-guest-modules-arch for other kernels choose virtualbox-guest-dkms Load the Virtualbox kernel modules: sudo systemctl enable vboxservice Then add a shared folder. Reboot. Add your user to the vboxsf group and give that user a permission to access the media folder: sudo usermod -a -G vboxsf yourusername sudo chown -R yourusername:users /media/ Log out, log in. 3:02 Debian guest system (Please, use this way for any other distro. It's a more universal way.) Make sure these packages are installed: sudo apt install build-essential dkms linux-headers-$(uname -r) Then add a shared folder. Reboot. Insert Guest addition image and install VBoxLinuxAdditions: sudo sh VBoxLinuxAdditions.run Reboot. Add your user to the vboxsf group: sudo usermod -a -G vboxsf yourusername And change the permission of the media folder: sudo chown -R yourusername:users /media/ Log out, log in. 4:39 Linux Mint / Ubuntu guest system Open the software manager and install virtualbox-guest-X11 virtualbox-guest-utils virtualbox-guest-dkms Add a shared folder. Reboot. Then add your user to the vboxsf group. sudo usermod -a -G vboxsf alu Change the permission. sudo chown -R alu:users /media/ Log out, log in. Now you can use a shared folder to move files between your host and guest systems. ################################################ Support on Patreon: https://www.patreon.com/averagelinuxuser Donate through PayPal: https://www.paypal.me/Kryvokhyzha ################################################ More cool Linux stuff at other social media: Google+ - Best Linux Stuff: https://plus.google.com/+AverageLinuxUser Facebook - Top Linux Tips: https://www.facebook.com/AverageLinuxUser Twitter - Daily Linux News: http://twitter.com/AVGLinuxUser Website: http://averagelinuxuser.com/
Views: 16538 Average Linux User
Tutorial: Set permissions to access files and folder (chmod) on Linux
Learn to assign and withdraw access permissions to files and folders on Linux using chmod.
Views: 14131 TechXArena
HOW TO USE - Access Control List (ACL) in Linux PART-1st
Hello friends in this session I'm showing you to how to use Access Control List (ACL) in Linux operating system.we can able to set permission to a file or directory .ACL supports multiple users can work in the same projects. #AccessControlList #ACL #Linuxtutorial
Views: 11866 Oracle World
How To Share Files and Folders between Host and Virtual Machine On Virtualbox (Windows) ?
If you guys want high-quality, and more FREE tech content, You can Support me on Patreon and get some great rewards! https://www.patreon.com/TreeAcademy How To Share Files and Folders between Host and Virtual Machine On Virtualbox (Windows) ? Step 1: Create a Folder on Host Machine,Right click on it --Click on Properties --Click on Sharing tab--Add Everyone --Give Permission like read/write --click on ok.. Step 2: Now ,Go to Virtual Machine ,click at the Top Device and Install Guest Additions CD Image and restart the Virtual Machine . Step 3: Now ,again go to devices --shared Folders--Shared Folder Settings--Add your Shared Folder . Step 4: Now ,Open Network ,Turn on Network discovery . Step 6: Go to VboxSvr and access your shared folder. That's all Thanks for watching,if you like this tutorial ,please like and share . ============================================== Facebook: https://www.facebook.com/GoTreeAcademy Google+ : https://goo.gl/zAAXK6 Twitter: https://twitter.com/gotreeacademy #howto #sharefilesandfolders #hostandvirtualbox
Views: 50617 Tree Academy
FreeNAS 11.2 - How to Setup New Hard Drives, Windows Shares and Manage Permissions
I just purchased 4 x 4TB drives for my second NAS, so i created a tutorial that will walk you through using FreeNAS 11.2, creating the pool, datasets, user permissions and SAMBA windows share, I purposely show it not working so you can get an understanding how permissions work. https://www.myrandomtips.com/linux/freenas/freenas-11-2-setup-new-hard-drives/ Great HP MICROSVR GEN10 I recommenced: https://amzn.to/2Rnu0bS
Views: 9083 My Random Tips
Oracle Workflow 06 Components Directory Service
This Video discusses Directory Service Tables and Views that contain Roles data and Users assigned to these Roles
Views: 495 Tarek Saleh
OracleServiceXE Won't Start After Uninstalling Active Directory
This video will explain how to recover oracle 11g server . From following error "Error 1053: The service did not respond to the start or control request in a timely fashion"
Views: 4695 Heamnath J
Share Folders between VM and Host
This video tutorial demonstrates on how to share folders between Host and Virtual Machine. It's part of the blogpost - How to Install Hadoop on Windows with Cloudera VM: http://bytequest.net/big-data/install-hadoop/ For more video tutorials and blogs on Hadoop and Big Data please visit: http://bytequest.net
Views: 11220 ByteQuest
#5-  Error ORA-01031: "insufficient privileges"
you can also get this error ORA-01031: "insufficient privileges" error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges.
Views: 3474 Houssine Formation
Linux Backup with TAR and Cron Jobs
Info Level: Intermediate Presenter: Eli the Computer Guy Date Created: September 21, 2010 Length of Class: 35 Minutes Tracks Linux Prerequisites Introduction to Linux Installing Linux Basic Linux Tasks VIM for File Editing Navigation in Linux Users, Groups and Permissions in Linux Purpose of Class This class teaches students how to backup directories using TAR, and demonstrates how to schedule tasks using Cron Jobs. Topics Covered Backing Up Directories with TAR Recovering Directories with TAR Setting Up Cron Jobs for Scheduled Tasks Class Notes Backup Using TAR Backup = sudo tar --cvpzf backup.taz.gz --exclude/=directory (recursive) PATH --c = create new file (overwrites old file) --v = verbose --p = preserve permissions --z = compress --f = filename (very important) --exclude=DIRCECTORY is Recursive Naming Files with time = filename-$(date +%F-%T) Recover Files from a TAR File Recover = sudo tar --xvpzf FILE --C /DIRECTORY Capital -C = change to directory -x = extract Cron Jobs To Edit the Crontab File = sudo cron --e (first time it will ask you your default editor) Format = minute (0-59), hour (0-23, 0 = midnight), day (1-31), month (1-12), weekday (0-6, 0 = Sunday), command * Wildcard for Every Minute/Day/Hour/Month?Day of Week Example to Backup Entire Server for 1am Every Morning = 0 1 * * * sudo tar -cvpzf /backup.tar.gz --exclude=/mnt /
Views: 192052 Eli the Computer Guy
Ubuntu ●   You do not have permissions on Shared Folders ● VirtualBox Guest Additions
When you try to access the shared folder from the guest you get the error message: You do not have the permissions necessary to view the contents of “Your_share” Solution • Add user to vboxsf group • Reboot VM Prepared by Christian ALT for http://Vision6D.com Channel about IT Technology, Management and Communication To stay in touch with Christian ALT: linked In : https://www.linkedin.com/in/christian-alt-4343562/ Facebook : https://www.facebook.com/christian.alt
Views: 200 Vision 6D
Oracle Developer 10g  Installation Problem in Windows 7 and Solution
Oracle Developer 10g Installation Problem in Windows 7 and Solution by Russel Ahasan
Views: 6288 Russel Ahasan
TortoiseSVN (Subversion) Tutorial
This tutorial describes Subversion and shows how to upload files onto a Subversion repository using TortoiseSVN. Installing Tortoise SVN •http://tortoisesvn.net/downloads Using Tortoise SVN 1.Open the folder you want to submit in the explorer 2.Right click, open the repo-browser 3.The first time, youll need to type in the server information, specified with your net ID, which can be found on the CS project page (ex. svn+ssh://(csid)@schizo.cs.byu.edu/users/groups/cs235(csid)/cs235/) 4.You may need to enter in your username/password several times for permission to open the page 5.Create lab folders on the SVN repository (title them lab1, lab2, lab3, etc.) 6.Enter log messages as prompted by typing a description of the changes youve made 7.Back in the explorer window, right click the folder you want to upload and select SVN checkout 8.The URL of repository is where you are loading your folder to (ex. netID/cs235/lab2) The checkout directory is where the files are located on your computer (ex. C://cs/cs235/spell) 9.In the explorer window, highlight the JAVA files you want to submit, right click, and select ADD 10.Move up a directory, right click the folder you want to submit (spell) and select SVN Commit Updating a file (after its been loaded onto Subversion) •In the explorer, select the file(s)/folder and click SVN commit
Views: 282427 DataMiningLab
SQL tutorial 48: How to create Roles in Oracle Database
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn ● What user roles ● How to create simple roles (Role with Not Identified clause) ● How to create secure roles (Role with Identified clause) ● How to create external role. ● How To create global role. ● How to Grant System Privilege to a user Role ● How to Grant Object Privilege to a user Role In oracle database. ● How to grant a Role to another Role ● How To grant a role to database users (with Admin option) ● How To enable role using SET ROLE statement This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- 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 first 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: 24427 Manish Sharma
Linux Commands 5. File Permission : chmod
- / d # # # # # # # # # file / directory Owner/user : u Group : g other people : o chmod o-w file1 : take away write permission from other chmod 0+w file1 : give write permission to other chmod -w file1 : take away write permission of file1 chmod +w file1 : give write permission for file1 read : r : 4 write : w : 2 execute : x : 1 No permission : - : 0 ls -l: everyone get all permission chmod 754 file1 : u(4+2+1) g(4+1) o(4)
Views: 438 Linux in 11 Minutes
Oracle SQL Developer Tutorial For Beginners   50   DCL   System Privileges
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 1011 Sam Dhanasekaran
Oracle Upgrade, oracle 10g and oralce 11g to oracle 12c
SAP On Oracle Database Upgrade, From Oracle 10g to 12c Direct upgrade, ================================================= TAKE BACKUP OF EXISITNG DB brbackup -u / -p initGWP-disk-OFF.sap -d disk -t offline -m all -o time INSTALL ORACLE 12 DATA BASE - CHANGE THE HOME DIRECTORY PATH IN ENVIRONEMNT - Not to ADD FULL PERMISSION IN TO ORALCE INSTALLATION USER - TAKE A COPY OF OLD ORACLE & AND NEW ORACLE HOME BEFORE APPLYING PATCHES - TAKE COPY OF NETWORK\ADMIN AND DATABASE FOLDER - DOWNLOADED LATEST OPATCH AND REPLACE OPATCH FOLDER - APPYL NEEDED PATCHES USING OPATCHS - STOP ALL SERVICES ORACLE RELATED FOR APPLYINT PATCHES **PATCHBUNDLE12102P_1702-20012303.zip **PATCHBUNDLE12102P_1704-20012303.zip **P9584028GEN12102P_2-20012303.zip 'EG: B:\Patches\P9584028GEN12102P_2-20012303\9584028 C:\oracle\GWP\12102\OPatch\OPATCH APPLY' 'EG: B:\Patches\PATCHBUNDLE12102P_1702-20012303\25433286 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY' "EG: B:\Patches\PATCHBUNDLE12102P_1704-20012303\25632533 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY" -START SERVICES AFTER APPLYING PATCHES FOR UPGRADE. RUN THE PRE UPGRADE SCRIPT AS FOLLOWS.. PRE UPGRADE SCRIPT WILL PROVIDE YOU WHEN YOU UPDATE PATCHES ================================ OS sqlplus / as sysdba SQL @pre_upgrade_tasks.sql SQL @pre_upgrade_checks_ora.sql SQL @pre_upgrade_checks_sap.sql THEN CREATE RESTORE POINT FOR RECOVERY IF ANY FAILIUR HAPPEND */ ============================================================= /*(ALTER SYSTEM SET db_recovery_file_dest_size='10G G:\oracle\GWP\oraflash' scope=both; ALTER SYSTEM SET db_recovery_file_dest= 'E:\oracle\GWQ\oraflash scope=both';)*/ ------------------------------------------- SQL @grp_create_restore_point.sql SQL @grp_list_restore_point.sql ===TAKE BACKUP OF NETWORK/ADMIN & ORAHOME\DATABASE RUN DUBA from new home (oralce 12c) KEEP DATABSE OPEN FOR UPGRADE. ===================== CREATE RMAN BACKUP DURING THE UPGRADE \Post upgrade steps 1915315 - Database Upgrade Scripts for ====================================================================== After DUB create Listner or check the listner status LSNRCTL/ Go to directory 'post_upgrade' to run the post-upgrade scripts. --SQL @?/rdbms/admin/utlu121s.sql --SQL @?/rdbms/admin/utluiobj.sql --SQL @post_upgrade_tasks.sql Recompile invalid objects --SQL @?/rdbms/admin/utlrp.sql Run post-upgrade checks --SQL @post_upgrade_checks.sql Check whether guaranteed restore point 'GRP_BEFORE_UPGRADE_12102' exists: OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_list_restore_point.sql you need to drop this restore point and set 'COMPATIBLE' to the new value. OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_drop_restore_point.sql OS cd NEW_ORACLE_HOME /sap/ora_upgrade/post_upgrade OS sqlplus / as sysdba --SQL @set_compatible.sql After setting compatible to a new value, 'RESTART THE DATABASE.' Ensure that parameter 'compatible' is set to '' or '': --SQL SHOW PARAMETER COMPATIBLE SQL show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string noncdb_compatible boolean FALSE --SQL SELECT VALUE "COMPATIBLE" FROM V$PARAMETER WHERE NAME = 'COMPATIBLE'; Before you start the remaining database post-upgrade tasks you can create a new guaranteed restore point ====================================================== --SQL CREATE RESTORE POINT "'GRP_AFTER_UPGRADE_12102'" GUARANTEE FLASHBACK DATABASE ; --SQL SELECT NAME FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; drop V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; Check for invalid objects: =========================== --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; If the object 'DBMS_METADATA' (package body) is still invalid (Ref: patch 17871192), run utlrp to recompile the package. ====================================================== --SQL @?\rdbms\admin\utlrp.sql --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; COPY data from OLDorahome\database\ to new database\ FOLLOWING FILES INIT SID .SAP INIT SID .UTL update the kernel CHEK THE TNS FILE NAME IN NETWORK\ADMIN brconnect -u / -c -f stats -t system_stats brconnect -u / -c -f stats -t oradict_stats brconnect -u / -c -f stats -t all -f collect -p 4 deinstall the 11g /*if needed */{}{}{}{}{}{}{}{}{}{}{}{}{}{}{} ================= sqlplus / as sysdba @sapuprof_profile Insufficent privillege 134592 - Import of SAPDBA role (sapdba_role.sql) ========================== sqlplus /nolog @sapdba_role SAPSR3 --CHANGE PARAMTER ONCE UPGRADE COMPLETE. Visit My Blog:http://wrongcodes.blogspot.com/
Views: 254 SNOOPPY TV
Error 1303 - Installer has insufficient privileges to access this directory
Take Ownership ► https://drive.google.com/open?id=0Bw-8fzdMfWSFREZUTzZqNFROWkk
Views: 4715 Crazy PC Hacker