Search results “Oracle linux exports”
Exports - Imports Utility step by step
In this video i'm going to show you how to use Exports - Import Utility, Schema lever, Table Level and Full Database Level step by step. #export #import #impdp #expdp #oracletutorial #oracle12c
Views: 29380 OCP Technology
Oracle Data Export and Import using DataPump expdp and impdp
Oracle Data Export and Import using DataPump expdp and impdp
Views: 183945 Abbasi Asif
3.Schema level Export and Import in oracle database
Hello friends in this video i explain how to export full schema(user) and performing a recovery after drop of user. #SchemalevelExportandImport Oracle database Unbeatable,Unbreakable Platform..
Views: 19031 Oracle World
Install Oracle Database 18c in Oracle Linux 7.6 64-bit OS
Simple demonstration on how to install Oracle database 18c in Oracle Linux 7.6 64-bit OS. Steps are given below: Step 1 Disable firewall and selinux ====================== service iptables stop chkconfig iptables off vi /etc/selinux/config SELINUX=disabled ======================= Step 2 create OS group and user ======================= groupadd -g 1100 oinstall groupadd -g 1131 dba groupadd -g 1132 oper useradd -u 1101 -g oinstall -G dba,oper oracle passwd oracle ========================= create directories ========================= mkdir -p /u01/app/oracle/product/18.3.0/dbhome_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01 ========================= ---------------------- vi /etc/hosts ---------------------- testlab.com.bd testlab run the following command from anywhere as root yum install oracle-database-preinstall-18c.x86_64 #---------------------------- #as oracle user #---------------------------- TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=testlab.com.bd; export ORACLE_HOSTNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/18.3.0/dbhome_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ORACLE_TERM=xterm; export ORACLE_TERM BASE_PATH=/usr/sbin:$PATH; export BASE_PATH PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$BASE_PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH log in as oracle go to ORACLE_HOME directory and run ./runInstaller after software is install run dbca to create database.
Views: 481 Oracle Testlab
The Value of Oracle Linux Support
Oracle Linux Support provides the best enterprise-level 24x7 support at an affordable cost. Watch this video to understand features and support levels.
Views: 1578 Oracle
Working with NFS Export options in OCI File Storage
NFS export options enable you to create more granular access control than is possible using just security list rules to limit VCN access. Exports control how NFS clients access file systems when connecting to a mount target. To learn more, visit Working with NFS Export Options. https://docs.cloud.oracle.com/iaas/Content/File/Tasks/exportoptions.htm
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- 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: 78092 Manish Sharma
Install Oracle JDK in Linux
Download Java SE from oracle official page: http://www.oracle.com/technetwork/java/javase/downloads/index.html After that follow the video instruction to install java in linux (Oracle JDK in Linux) After that configure alternative using update-alternative commands as in Video. Make sure that You need to setup PATH variable in Linux in ~/.bashrc # Exporting Java JDK Profile export JAVA_HOME=/opt/jdk8/ export JRE_HOME=/opt/jdk8/jre export PATH=$PATH:/opt/jdk8/bin:/opt/jdk8/jre/bin above part are just suggestion here. Make sure you must have to provide in JAVA_HOME=/your_JDK_DIR and also for JRE_HOME in PATH too. and follow the command : update-alternative --configure java and select prefered version in.
Oracle Linux 5.7 Installation
In this video I have demonstrated that how we can install OEL 5.7 64 bit on VMWare Workstation.
Generate SSH Key Pairs to Access Oracle Linux instances in the Oracle Cloud Infrastructure
ntroduces Secure Shell key pair generation and demonstrates how to generate a SSH key pair to use when remotely connecting to Oracle Cloud Infrastructure instances.
Oracle Linux Track - Importing the Oracle Linux Appliance - OTN Virtual Sysadmin Day
How to import the Oracle Linux appliance into Oracle VirtualBox.
Views: 503 OTN Systems Hub
Virtualization - Importing and Exporting VirtualBox VM Virtual Machines ( .ova and .ovf)
Quick demonstration on how to import and export VirtualBox VM.
Views: 15158 systempeeps
How to Export and Import Full Oracle Database using Datapump Utility.
we can export ( expdp ) and import ( impdp ) Full Oracle Database using datapump utility. we can use expdp for export and impdp for import. In this video i am showing you how to export Full Oracle Database and how to import Schema, Tablespace, Tables, Viwes using Datapump utility. It is very easy to understand.
Views: 4355 Parag Mahalle
11 Exporting Variables in the Linux Shell Tutorial
Playlist: https://www.youtube.com/playlist?list=PLcUid3OP_4OU9LTiKK4NQwKvlEuEYzpHG Webpage - http://filmsbykris.com Support - https://www.patreon.com/metalx1000 Donate - https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=J9FK6WWVRQMG6 Other Channel - https://www.youtube.com/channel/UCFsvtR4aNPwefLjR1a9Hgvg For help: http://filmsbykris.com/irc FaceBook: https://www.facebook.com/pages/Films-By-Kris/225113590836253
Views: 456 Kris Occhipinti
How to Share Files Using NFS: Linux Server Training 101
http://www.soundtraining.net/linux-server-training-101 Learn how to install and configure a basic NFS (Network File System) file server using CentOS or Red Hat Linux 6.5. In this Linux tutorial, IT author and speaker Don R. Crawley demonstrates how to install NFS using Yum, along with NFS configuration and NFS testing procedures.
Views: 59897 soundtraining.net
SCP between 2 oracle linux instances
SCP between 2 oracle linux instances
Views: 34 Ora Tube
how to launch any graphical application on linux or X11 forwarding or Xming launch
This video is about how to use Graphical application in Linux server environment. And this video will cover the basic concept of X11 forwarding, Xming server, DISPLAY variable in Linux and Graphical application on Linux. So to get the Graphical access to any GUI based application we need to follow below listed steps: 1. While logging into the server, Enable the X11 forwarding in Putty Setting. 2. After Login into the Linux machine you need run X11 forwarding server which is "xming" on window machine, which you are using to get access to the Linux server. 3. The xming can be downloaded from google and very easy to install. To launch Xming just click on "Xming Launch" icon and provide the port number where you want to run the xming server and finish the setup. 4. Once Xming is successfully launched on window machine. Just go to the Linux server and set the DISPLAY environment variable using the command "export DISPLAY=Window machine IP : Port of Xming server" i.e. "export DISPLAY=" (Refer video for more clarity). 5. You can launch any Graphical application now. Test using "xclock" command. Also check the IPTABLES & SELINUX status at your Linux machine, both should be turned off. We are focusing on the basic problems, which we are facing during the installation or implementation of any application and due to unavailability of related content, it took large amount of time. Hope this kind of video will help you and you will not lose your continuity during the activity. Will come with more videos soon.
Views: 24709 OpenGyanHouse
MySQL exporting and importing with command line
This is a quick demonstration showing you how to quickly export and import a specific MySQL database using mainly the command line. This is faster and somewhat less prone to errors than requesting a dump through phpMyAdmin, for example. You require SSH access, though. Shared hosts usually do not provide this. This is a quick video which I made for my portfolio, but for the sake of informational purposes I decided to do the video in English rather than in Dutch (I'm from Belgium). Sorry for potato quality.
Views: 44038 Vince0789
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: 6236 Data Science Center
Building a virtual appliance with Oracle Linux 6 and Oracle VM VirtualBox
This screencast shows you how you can install Oracle Linux 6 VirtualBox Appliance. By Lenz Grimmer, Sr.Product Manager, Oracle You can download this appliance from the Oracle Technology Network (http://www.oracle.com/technetwork/server-storage/linux/downloads/vm-for-hol-1896500.html). See this video (https://www.youtube.com/watch?v=9e2_zUCaGH4) for a short screencast about how to install Oracle VM VirtualBox on Windows.
Views: 10419 Oracle Linux
Highly Available NFS (HANFS) Over ACFS
HANFS over ACFS enables highly available NFS servers to be configured using Oracle ACFS clusters. The NFS exports are exposed through Highly Available VIPs (HAVIPs), and this allows Oracle’s Clusterware agents to ensure that HAVIPs and NFS exports are always available. If the node hosting the export(s) fails, the corresponding HAVIP and hence its corresponding NFS export(s) will automatically fail over to one of the surviving nodes so that the NFS client continues to receive uninterrupted service of NFS exported paths.
Views: 1298 Oracle RAC SIG
Export Command in Shell Scripting
Hi Friends, Export Command The export command is one of the bash shell BUILTIN commands, which means it is part of your shell. Export command marks an environment variable to be exported with any newly forked child processes and thus it allows a child process to inherit all marked variables. Frequently Used Options -p : List of all names that are exported in the current shell -n : Remove names from export list -f : Names are exported as functions Think over the following example: $ Var1=shubhneet.com $ echo $Var1 shubhneet.com $ bash $ echo $Var1 $ Let's define a new variable called "Var1" containing a string "shubhneet.com" Now, Let's echo this command to print out a content of the variable "Var1" Now, Let's create a new child bash shell As you can see now, that variable "Var1" is no longer having any values Like, I said earlier any new child process forked from a parent process by default does not inherit parent's variables. This is where the export command comes handy. $exit $ echo $Var1 shubhneet.com $ export Var1 $ bash $ echo $Var1 shubhneet.com $ First, let's exit from the current child shell. Now, let's echo the variable Var1 to check if it is still there in the parent shell, so it is there. Now, let's use the export command to make the variable "Var1" to be exported when a new child process is created. Now, Let's create a new child bash shell And, Not Let's try to echo this variable in the child shell Gr8 this worked :) In our next video we will study about bash startup. So, Stay tuned and Please Like & Subscribe our channel for future videos. Thank You,
Views: 2511 Shubhneet Goel
Oracle 11G Export and Import using Oracle Data Pump
Step1. Login through Enterprise Manager using System user but not as "sysdba". Instead as normal User. Step 2. Go to "Data Movement Page" Step 3. Select Export Step 4. Use the Wizard to complete the Export. Same way you can Import. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. To know about me visit my profile at www.rnsangwan.com. I deliver online training on Business Analysis, Linux, Unix, MySQL, Sybase, SQL Server, Perl, Python, R Data Analysis, Scala etc.
Views: 16258 TheSkillPedia
Best Oracle expdp impdp rac 12c - Deep dive part 1
This video will explore some advanced features of datapump expdp and impdp. Author:George S Pulinattu https://admin-docs.com/databases/oracle/datapumpexpdpimpdp/
Views: 1480 Admin Documentation
Oracle Database Backup and Recovery Session 2
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. MASTER AND LEARN: - Introduction to RMAN - Configuring RMAN - Database Backup using RMAN - RMAN Database Recovery
Views: 56065 DBA Genesis
Oracle Database Administration DBA: Oracle database 11g installation on RedHat Linux
https://www.facebook.com/Tutorialmonsters/ In this Facebook page you will find more helpful and useful tutorial. Please Like and Subscribe. Oracle 11g Installation manual on Redhat Linux.... 1- vi /etc/hosts add IP-address machine-name 2- Update Kernel parameters vi /etc/sysctl.conf ------------ fs.suid_dumpable = 1 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048586 ----------- 3- update security limits vi /etc/security/limits.conf ----------- oracle soft nproc 16384 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 oracle soft stack 10240 ---------- 4- Install required packages for Oracle installer Yum Configuration: https://www.youtube.com/watch?v=bJgLeZTUAMU 5- Run these commands one by one: yum install glibc-2*x86_64* nss-softokn-freebl-3*x86_64* yum install binutils-2*x86_64* yum install glibc-2*i686* nss-softokn-freebl-3*i686* yum install compat-libstdc++-33*x86_64* yum install glibc-common-2*x86_64* yum install glibc-devel-2*x86_64* yum install glibc-devel-2*i686* yum install glibc-headers-2*x86_64* yum install elfutils-libelf-0*x86_64* yum install elfutils-libelf-devel-0*x86_64* yum install gcc-4*x86_64* yum install gcc-c++-4*x86_64* yum install ksh-*x86_64* yum install libaio-0*x86_64* yum install libaio-devel-0*x86_64* yum install libaio-0*i686* yum install libaio-devel-0*i686* yum install libgcc-4*x86_64* yum install libgcc-4*i686* yum install libstdc++-4*x86_64* yum install libstdc++-4*i686* yum install libstdc++-devel-4*x86_64* yum install make-3.81*x86_64* yum install numactl-devel-2*x86_64* yum install sysstat-9*x86_64* yum install compat-libstdc++-33*i686* yum install compat-libcap* ----------- 6- Create the new groups and users: groupadd -g 501 oinstall groupadd -g 502 dba groupadd -g 503 oper groupadd -g 504 asmadmin groupadd -g 506 asmdba groupadd -g 505 asmoper useradd -u 502 -g oinstall -G dba,asmdba,oper oracle passwd oracle ---------- 7- Amend the "/etc/security/limits.d/90-nproc.conf" file as described below # Change this * soft nproc 1024 # To this * - nproc 16384 --------- 8-Set secure Linux to permissive by editing the "/etc/selinux/config" file SELINUX=permissive --------- 9- make directories mkdir -p /u01/app/oracle/product/11.2.0/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01 --------- 10- Login as the oracle user and add the following lines at the end of the ".bash_profile" file. # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=localhost; export ORACLE_HOSTNAME ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH --------------- 11 - Installation move Oracle_11g binaries mv oracle_binarties /u01 unzip 1.zip unzip 2.zip then execute these commands from root to activate kernel parameters: sysctl -a sysctl -p
Views: 800 Tutorial Monsters
Editing THe Bash Profile And Exporting To A Different Database
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
Solaris 11 Creating NFS Exports with ZFS
More videos like this online at http://www.theurbanpenguin.com In this video we see how the simple ZFS command lines tools can be used to control the NFS server and create NFS exports
Views: 4132 theurbanpenguin
Exporting and importing dmp file in oracle database 12c
Exporting and importing dmp file in oracle database 12c Contact: రవి కుమార్ . లంకె Ravi kumar Lanke Email : [email protected] Gmail : [email protected] Yahoo : [email protected]
Views: 550 Ravikumar Lanke
Informatica Installation On Linux - Part2 (Oracle Installation)
Oracle 11g Standard Edition Installation n Oracle Linux -- Oracle installation is a toughest part however if you follow the steps mentioned in below link exactly, it will make sure job easier. http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-5.php
Views: 8718 Mandar Gogate
04 Oracle 10201 Installation in rhel4 by exporting display of server into local machine
Oracle 10201 installation in rhel4 by exporting display of server into local machine using vncserver/vncviewer.
Views: 175 meemaht28
Export and Import oracle Data dump
Export and Import oracle Data dump استيراد وتصدير قاعدة يانات اوراكل
Views: 96976 Appsstuff Middleware
Oracle VM VirtualBox 6.0: Export your VMs to Oracle Cloud Infrastructure
VirtualBox 6.0 in action - Deploy your VMs on Oracle Cloud Infrastructure
Views: 922 scoter80
ZFS share access via both SMB and NFS
Brief demonstration of concurrent access to a ZFS storage appliance from both Windows and Linux clients with mapped credentials
Views: 2247 How-To Videos
Oracle Database Tutorial 58: How To Import Schema using REMAP_SCHEMA in impdp Data Pump Import
Learn how to import schema using REMAP_SCHEMA in impd data pump import in oracle database By Manish Sharma Rebellion Rider. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/how-to-import-schema-impdp-data-pump-oracle Previous Tutorial Tut 56 How to import table in same schema : http://youtu.be/oEnmEUlicY0 ------------------------------------------------------------------------- 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: 23097 Manish Sharma
How to Run VMware Virtual Machines on VirtualBox
Author: Jeremy Druin Twitter: @webpwnized Thank you for watching. Please help by up voting, subscribing or even supporting this channel at https://www.youtube.com/user/webpwnized (Click Support). Description: This video covers running a VMware VMDK disk image on Oracle VirtualBox by exporting the virtual machine as an OVA file then importing the virtual machine. This same process can be used to export an OVA from VirtualBox for import into VMware.
Views: 31935 webpwnized
Restore RMAN backup To another New DB Server
Although there are several other methods to achieve this, this is just one of those methods. This can be done differently based on the setup of your environments, such as your backup methods, location files / file system etc. This can be helpful in case where there is a need for QA/DEV environments to be refreshed with PROD data. Please get below checklist download to follow this video: ************************************************************ https://drive.google.com/open?id=0B1Vyp5-9fissZjRfbHpyVzhPZkE Follow the below link to find other oracle stuffs. http://oraerrors.blogspot.in/ Pradeep Kumar.
Views: 5998 Pradeep Kumar
Oracle DBA Putty Connection
Oracle DBA Putty Connection
Views: 6556 srinu bondada
Create EXCEL/PDF/html/etc Report from Oracle | Ten Minute Code
BELOW CODE cerate report server below commands windows key+R run paste -- rwserver server=showjobs status=on Declare repid REPORT_OBJECT; v_rep VARCHAR2(1000); rep_status VARCHAR2(20); PL_ID PARAMLIST; pr_nm varchar2(20):='PNM'; --rwserver server=SHOWJOBS EXCECUTE IT ON RUN v_rptserver varchar2(10):='SHOWJOBS'; ---- Change 1 v_host varchar2(20):='localhost'; ---- Change 2 -- v_rptserver varchar2(10):=:global.RWS1; -- v_host varchar2(20):=:global.IP1; BEGIN PL_ID := GET_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) = FALSE THEN DESTROY_PARAMETER_LIST(PL_ID); PL_ID := CREATE_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) THEN MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm); RAISE FORM_TRIGGER_FAILURE; END IF; ELSE PL_ID := CREATE_PARAMETER_LIST(pr_nm); END IF; --add parameter with separate statement for each parameter Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); ---change 3 your report have parameters Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); repid := find_report_object('DESG'); --- change 4 report name SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF'); -- change 5 pdf/html -- SET_report_object_property(repid,REPORT_DESFORMAT,:BLOCK3.REP_FORMAT); ------ need all format SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_rptserver); v_rep := RUN_REPORT_OBJECT(repid,PL_ID); rep_status := REPORT_OBJECT_STATUS(v_rep); IF rep_status = 'FINISHED' THEN WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank'); ELSE message('Error when running report'); END IF; END;
Views: 6485 Together Oracle
How to administer the Oracle Enterprise Command Center for E-Business Suite
On September 28th, the Oracle Enterprise Command Center Framework Release 12.2 V1 Quick Install for Linux x86-64 was made general available on My Oracle Support as Patch 28574967. A detailed instruction document for installing the Oracle Enterprise Command Center Framework was uploaded into MOS in the Doc ID 2409163.1. Why another reporting tool? In an informal conversation with our head of finance, I mentioned the possible announcement of this product a few weeks before GA, and his first reaction was to ask: “why another reporting tool”. It is an awful truth that IT over the last few years has explored many reporting tools on different technologies and we’re still doing it. But this is different, and bear with me on this blog to learn why I think this is not just another “reporting tool”.
Views: 575 Gustavo Gonzalez
How to run Background jobs in Oracle Export and Import Datapump /* step by step */
In this video i am showing you How to run Background jobs in Oracle Export and Import. Suppose I want to Export Database, Schemas job in background. So, use nohup in the front of expdp command Nohup command is used for jobs are running in the background.
Views: 1264 Parag Mahalle
Setting the display for oracle
Above video explain how to set the display for installation of oracle database software on linux
Views: 4945 dbaforbeginners
Oracle Developer Day Database VirtualBox Appliance
Getting started working with Oracle Database is as easy as downloading this free VirtualBox image and hitting 'start.' This presentation shows how to download, install, and use one of the most popular Oracle Technology Network downloads. 12c, with Multientant and In-Memory options running on Oracle Linux 7 with sample data AND hands-on labs.
OracleVM With Oracle DB OVA
Oracle VM with Oracle Database OVA file which is having Linux OS + Oracle Database Software
Views: 1464 pradeep kumar
Oracle 11G DATAPUMP Import-Export Ej:1
Creacion, exportacion, eliminacion e importacion de las tablas con Oracle 11G DATAPUMP
Views: 2801 WilderK Diaz
how to import oracle database or dmp file
This video will tell you how to import a user from oracle data to you oracle data base
Views: 91148 brijesh kumar
Migrating OBIEE 11g to OBIEE12c
Upgrade existing OBIEE 11g to OBIEE 12c. You have to be on OBIEE or later to be able to successfully do the migration. If you are on an earlier release of OBIEE, first migrate to and follow this video to migrate to OBIEE 12c. Here are the steps: 1) Exporting OBIEE 11g catalog & RPD copy [ORACLE_HOME]\bi\migration-tool\jlib\bi-migration-tool.jar to your OBIEE 11g system say to c:\migration run the following command on your OBIEE 11g system java -jar bi-migration-tool.jar out [BI11g Home] [BI11g Domain] [output file] ex. java -jar c:\migration\bi-migration-tool.jar out c:\oracle\obi\Oracle_BI c:\oracle\obi\user_projects\domains\bifoundation_domain c:\migration\BI11g.jar Copy the exported file back to your OBIEE 12c server 2) Importing OBIEE 11g catalog & RPD into 12c run the following command on your OBIEE 12c system java -jar bi-migration-tool.jar in [BI12c Home] [BI12c Domain] [exported file] [service instance name] ex. java -jar c:\oracle\middleware\bi\migration-tool\jlib\bi-migration-tool.jar in c:\oracle\Middleware\ c:\oracle\Middleware\user_projects\domains\bi c:\migration\BI11g.jar ssi
Views: 11642 hchehab11