Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 282992 Manish Sharma
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 362196 Chitu Okoli
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►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: 55659 Manish Sharma
This tutorial shows you how to find your server name or instance for connecting to SQL Management Studio (SSMS). Step by step tutorial on how to check if SQL is installed on your machine using the services to check that Microsoft SQL Server has been started. Next how to find your instance name using SQL Server Configuration Manager using SQL 2012 or 2014 folder. I show you how to connect to the instance name in the Connect to Server SQL Sever 2014 box. The Server Name is made up of the following: ServerName/Instance Name 1: To find the Server name type the following into command prompt: SQLCMD -L 2: To find the instance name go to Microsoft configuration manager there you will see your version of sql server in my case sql server express as such I know my instance name is sql server express 3. Put the server name and instance name together as per the video SOPHIA-HP/SQLEXPRESS To request a video: http://itsophy.com/request-video/ More SQL Server videos: http://www.youtube.com/playlist?list=PLrTXCzXE7TKKhIhGtl65lYMAHP6xN5Wa4 My Blog: http://itsophy.com/
Views: 124147 ITSophy
...................................................Finish.................................................. To get my others videos just go to the link which is given below.. https://www.youtube.com/channel/UCFcOAx6xy6aQgKzJFaJ_8zQ Stay connected with information... Stay Connected with my tutorial.. Stay connected with updated reports tutorial... Keep learning about Oracle Databese ....... Thanks for watching... Subscribe my Channel : Mahfujur Rahman Subscribe my channel : Mahfujur Rahman Thanks For Watching MdMahfujur Rahman Database Design and Development IDB-BISEW IT Scholarship Project. 01673472384
Views: 23581 Mahfujur Rahman
This video demonstrates how to do DNS lookups and idenitify server and client host names and IP addresses in SQL and PL/SQL from Oracle. For more information see: https://oracle-base.com/articles/misc/identifying-host-names-and-addresses For information on Network Access Control Lists (ACLs) see: https://oracle-base.com/articles/11g/fine-grained-access-to-network-services-11gr1 https://oracle-base.com/articles/12c/fine-grained-access-to-network-services-enhancements-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Mike Donovan Blog: http://blog.dbvisit.com/author/miked/ Twitter: https://twitter.com/dbvisitmike Website: http://www.dbvisit.com/ Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 8448 ORACLE-BASE.com
go to this path on your computer where oracle is installled. F:\app\SVS\product\12.1.0\dbhome_1\NETWORK\ADMIN 1.check listener.ora and tnsnames.ora to verify portnumber and hostname 2.check whether lsnrctl is sleeping. if so, make it start. 3.if you are fine with above steps and even showing the errors. finally check your input for user and password is valid. select service name & type orcl and press connect button. successfully connected thanks for watching.
Views: 13481 srikanth
virtualhost creation in weblogic server HOW TO CREATE VIRTUAL HOST IN WINDOWS? LET START .......GOTO DOMAIN STRUCTURE IN ADMIN CONSOLE SELECT NEW TAB TYPE NAME ANY NAME MY PC VH1 Message icon - Success All changes have been activated. No restarts are necessary. Message icon - Normal Virtual Host created successfully. NEXT CLICK VH1 TYPE Virtual Host Names: THAT MEANS DOMAIN NAME FOR EXAMPLE: TRY.COM and save next select tragets tab server1 server2 i am selected and save next go to servers in domain structure select server1 and click and goto protocols tab and click NEXT GOTO CHANNELS TAB CREATE NEW CHANNEL NAME:CHANNEL1 PROTOCOL : HTTP AND CLICK NEXT TYPE LISTEN PORT: 80 ANY NUMBER DON T CHANGE SETTINGS CLICK FINISH IMP STEP: HOST FILE CHANGE SEE THIS PATH:C:\Windows\System32\drivers\etc SELECT HOST FILE AND EDIT IT SOME TIMES NOT SAVE SO SEE THIS CHANGE PERMISSIONS IT IS USED READ .WRITE AFTER CHANGE PERMISSIONS ADD YOUR HOST NAME # IS COMMENT SO DON'T USE # type your host name save and exit next goto admin console next step deploy application so select deployments in admin console select install tab and click next upload your file(s) select and click adn browse your app path my app name: Calendar.war and then click next next this place upload app next this place Select deployment targets select VH1 AND CLICK NEXT CLICK FINISH Message icon - Success The deployment has been successfully installed. and then go to new browse type: try.com/Calendar Calendar.html Quick link to your gwt module. click calendar.html your app is working so virtualhost is working complete installation thankyou for watching my channel thankyou.......... bye
Views: 6127 HARI KISHAN VELPULA
To Start the Reporting Services Configuration Manager. Use the following step that is appropriate for your version of Microsoft Windows: From the Windows start screen, type Reporting and select Reporting Services Configuration Manager from the earch results. Select Start, point to All Programs, point to Microsoft SQL Server 2017, and then point to Configuration Tools. If you want to configure a report server instance from a previous version of SQL Server, open the program folder for that version. For example, point to SQL Server 2014 instead of Microsoft SQL Server 2017 to open the configuration tools for SQL Server 2014 server components. Select Reporting Services Configuration Manager. The Reporting Services Configuration Connection dialog box appears so that you can select the report server instance you want to configure. Select Connect. In Server Name, specify the name of the computer on which the report server instance is installed. The name of the local computer appears by default, but you can type the name of a remote SQL Server instance if you want to connect to a report server that is installed on a remote computer. If you specify a remote computer, select Find to establish a connection. In Report Server Instance, select the SQL Server Reporting Services instance that you want to configure. Only report server instances for this version of SQL Server appear in the list. You cannot configure earlier versions of Reporting Services. Select Connect.
Views: 4341 Lahore Trend
Video 51 How to verify the Oracle Database Name - Oracle DBA Tutorial This video explains about, 'how to verify the Oracle Database Name that we are connected to'. After connecting to a database, it is very important that we need to verify that we are connected to the right database. This can be done by: select * from v$database; select * from v$instance;
Views: 6843 Sam Dhanasekaran
Hey guys, I made this video for the quick and simple installation of Oracle SOA Suite 12c version 188.8.131.52.0. I hope that this video will help you a lot. Please keep patience because the complete installation will take around 1 hour. Here is the quick step followed in this video: SOA 12C Installation:- Requirements: The Oracle Business Process Management Suite Quick Start installer zip file, fmw_184.108.40.206.0_bpmqs_Disk1_1of2.zip. • Java Development Kit (JDK) Version 1.8+ • Oracle XE Database (11gR2) ** Run everything as an Administrator. I am going to use following credentials. Username : weblogic Password : Oracle123 Step 1: Install Oracle XE Database (11gR2) step 2: Install JDK step 3: Install BPM Suite Quick Start C:\Program Files\Java\jdk1.8.0_25\bin\java -jar (path where we kept our BPM zip file)\fmw_220.127.116.11_bpm_quickstart.jar step 4: Navigate to %ORACLE_HOME%\oracle_common\bin and execute RCU.bat file. step 5. Configuring a Compact Domain. cd %ORACLE_HOME%\soa\common\bin step 6: In the command prompt, set the environment variable SET CONFIG_JVM_ARGS=-Dcom.oracle.cie.config.showProfile=true and then enter config.cmd. step 7: ‘Create a new compact domain.’ step 8: Select Oracle BPM Suite – 18.104.22.168.0 [soa] and Oracle Service Bus-22.214.171.124.0[osb] while installation. step 9: RCU Details: DSMS/Service: XE Host Name : localhost Port : 1521
Views: 3056 Syed jaweed
all education purpose videos
Views: 283365 Chandra Shekhar Reddy
This video contains a total demonstration of how to connect to oracle 12c release 1 on Oracle linux server 6.4 64 bit from MAC OSX Mountain Lion 7.0 using SQL Developer 126.96.36.199.84. Tutorial contains 2 way of connecting 1. Connecting using oracle service name. 2. Connecting using saved xml configuration file. SQL Developer for MAC OSx link : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 61665 Subhroneel Ganguly
This video shows how to create connections in MySQL Workbench and what to do if problems arise with that. Please subscribe to the MySQL Youtube channel: http://www.youtube.com/mysqlchannel Like our MySQL Facebook page: http://facebook.com/mysql Follow us on Twitter at: http://twitter.com/mysql
Views: 372547 MySQL
how to Fixed: windows could not start the oracledbconsole on local computer error code 2 or OracledbConsole does not start problem..pls watch full video & solved ur problem by urself. if face any problem; pls comments I'll try to level best to solve related problems; also u can follow below desc........... ======================================== Find & follow on Social media: Twitter: https://twitter.com/DhamaliyaNet Reddit: https://www.reddit.com/user/dhamaliyadotnet FaceBook: https://www.facebook.com/dhamaliya.Net/ Soundcloud: https://soundcloud.com/dhamaliya-dot-net GooglePlus: https://plus.google.com/u/0/100736768767244969950 Pinterest: https://www.pinterest.com/dhamaliyadotnet007/ Intagram: https://www.instagram.com/dhamaliyadotnet/ askFm: https://ask.fm/Dhamaliya007 vk: https://vk.com/id480426864 Vimeo: https://vimeo.com/user81356715 ======================================== please subscribe my channel: https://www.youtube.com/c/dhamaliyadotnet ======================================== for more Tips & tricks: https://www.youtube.com/playlist?list=PLAmEKK-wglL13Vhb9gvLHFih7LkXPkzbv ============================================= Following is the Solution which worked well for me. Step 1: Go to dbhome --- hostname_SID --- Sysman --- Config --- open emd.properties in notepad and set the value agentTZRegion=+06:00 to the value of your timezone and click save. You can also do it using export and time zone reset commands. Step 2: ALTER DATABASE SET TIME_ZONE='+06:00'; according to your time zone. You can check DB TIME Zone using " select dbtimezone from dual ; ". Step 3: In step 2 if you get the error "ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns" then please FOLLOW following steps SQL--- select count (*) from dba_tab_columns 2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE' ; COUNT(*) 1 In this case there is only one table. The owner and name can be determined by: SQL--- select owner, table_name from dba_tab_columns 2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE'; OWNER TABLE_NAME ------------------------------ OE ORDERS SQL--- desc oe.orders ; Name Null? Type -------- ORDER_ID NOT NULL NUMBER(12) ORDER_DATE NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE ORDER_MODE VARCHAR2(Cool CUSTOMER_ID NOT NULL NUMBER(6) ORDER_STATUS NUMBER(2) ORDER_TOTAL NUMBER(8,2) SALES_REP_ID NUMBER(6) PROMOTION_ID NUMBER(6) This oe.orders is just a table in the example schema of OE so this colums can be dropped. So please dont install sample schemas if you dont need them. SQL--- alter table OE.ORDERS drop column ORDER_DATE ; Table altered. Now the Time Zone can be altered using above command. Step 4: Also check the value of " SELECT SESSIONTIMEZONE FROM DUAL; " and if the value differs from os time zone, db time zone , emd.properties / agent time zone then also set it according to your timezone but I believe it always gives the OS time zone. Step 5: Stop and Restart all Services and check that Oracle DBConsole service is running or not and if not running then start from command prompt " emctl start dbconsole" . https://hostname:1158/em/
Views: 3012 Dhamaliya dot Net
How to connect Oracle database in Eclipse? Part of Java online video tutorials: http://www.javavids.com
Views: 93704 Jiri Pinkas
How to connect to Oracle Database using Toad for Oracle. Online Video to learn the simple way to connect to database through Toad for Oracle. Learn Oracle connectivity from configuring tnsnames.ora , net8 client configuration to connecting to toad. A complete oracle tutorial.
Views: 121480 Subhroneel Ganguly
IO ERROR: The network adapter could not establish the connection Learn how to solve this Oracle Database / SQL Developer Error with in 4 minutes ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-developer-error-the-network-adapter-could-not-establish-the-connection Previous Tutorial ► Intersect and Minus SQL set operators https://youtu.be/sDZFpwEw1k8 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please 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: 158609 Manish Sharma
Here are the things I always change when running a new copy of Oracle SQL Developer. It's all about the preferences.
Views: 5402 Jeff Smith
Steps on Centos 5.10: Download the software from Oracle's support portal (requires login) cd /opt/ # download files from Oracle's website unzip V37034-01.zip unzip p16406547_111_Generic.zip Install the dependencies yum install glib dhcp openldap-clients tftp-server libXp libXfont.i386 openmotif22 openssl compat-libstdc++-33 libusb-devel compat-openldap kernel-devel gdbm.i386 gcc openmotif.i386 sssd-client.i386 If you are not using sssd you will need to install the nscd.i386 package. Install the firmware cd /opt/sros_188.8.131.52/ ./utfwinstall Installing Sun Ray Operating Software 184.108.40.206 Sun Ray Operating Software 220.127.116.11 has been successfully installed. This output has been logged to /var/log/utfwinstall.2013_05_09_14:48:54.log +++ Done. Install the bundled JRE and Apache Tomcat cd /opt/srs_18.104.22.168-Linux.i386/Supplemental/Java_Runtime_Environment/Linux sh jre-6u41-linux-i586.bin mv jre1.6.0_41/ /opt/ cd /opt/srs_22.214.171.124-Linux.i386/Supplemental/Apache_Tomcat gunzip apache-tomcat-5.5.36.tar.gz tar xvf apache-tomcat-5.5.36.tar mv apache-tomcat-5.5.36 /opt/ ln -s /opt/apache-tomcat-5.5.36/ /opt/apache-tomcat Install the Sunray Server Software cd /opt/srs_126.96.36.199-Linux.i386 ./utsetup [...] Accept? (Y/N) y [...] Enter Java v1.6 (or later) location: [/usr/java] /opt/jre1.6.0_41/ [...] Continue? (Y/N) [Y] y Enter new UT admin password: Again: Enter new UT admin password: Configure Sun Ray Web Administration? (Y/N) [N] y Enter Apache Tomcat installation directory [/opt/apache-tomcat] Enter HTTP port number  8080 Enable secure connections? (Y/N) [Y] y Enter HTTPS port number  8081 Enter Tomcat process username [utwww] Enable remote server administration? (Y/N) [N] Y Configure Sun Ray Kiosk Mode? (Y/N) [N] N Configure this server for a failover group? (Y/N) [N] About to configure the following software products: Sun Ray Data Store 3.5 Hostname: mysunrayserver.example.org Sun Ray root entry: o=utdata Sun Ray root name: utdata Sun Ray utdata admin password: (not shown) SRDS 'rootdn': cn=admin,o=utdata Sun Ray Web Administration hosted at Apache Tomcat/5.5.36 Apache Tomcat installation directory: /opt/apache-tomcat HTTP port number: 8080 HTTPS port number: 8081 Tomcat process username: utwww Remote server administration: Enabled Sun Ray Server Software 4.5 Failover group: no Sun Ray Kiosk Mode: no Continue? (Y/N) [Y] Enter groupname for Windows Connector [utwc] Enter group ID (gid) for the group [auto] Do you want to configure Firmware downloads for Sun Ray clients? (Y/N) [Y] Reboot Seriously you should reboot If the services are not running on reboot You can manually start them with: /opt/SUNWut/sbin/utadm -L on /opt/SUNWut/sbin/utstart SunRay Web Administration Log into https://mysunrayserver.example.org:8081 With the user: admin and the password you specified in the installer. Note: Replace port 8081 with the port you selected in the installer if you did not select 8081. If you can't log in because the "data store is not responding" proceed to the debugging section. Click "Advanced" Check all the encryption buttons Switch soft to hard for client and server Following instruction to restart client Debugging The following two log files were especially helpful in debugging problems. tail -f /var/opt/SUNWut/log/messages tail -f /var/log/autholog Security We have the SunRays in there own vlan and only the SunRay servers are allowed to communicate with them. You should also firewall the Web Admin ports in my case port 8080 and 8081. Summary I havn't had a lot of luck with a consistent installation using the instructions above. If it doesn't work the first time try uninstalling and resintalling the SunRay software. Also I was doing this with SELinux disabled and we already had working SunRays with Solaris 10 so I can't really comment on the dhcp configs or any special network acls we may have in place.
Views: 1195 Gerald Angelripper
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 66845 Manish Sharma
This video is only for education purpose... How to create a oracle database connection Urdu Hindi Tutorial To connect to Oracle Database from SQL*Plus: If you are on a Windows system, display a Windows command prompt. At the command prompt, type sqlplus and then press the key Enter. At the user name prompt, type your user name and then press the key Enter. At the password prompt, type your password and then press the key Enter. The system connects you to an Oracle Database instance. You are in the SQL*Plus environment. At the SQL prompt, you can enter and run SQL*Plus commands, SQL statements, PL SQL statements, and operating system commands. To exit SQL*Plus, type exit and press the key Enter To connect to Oracle Database from SQL Developer: Start SQL Developer. For instructions, see Oracle Database SQL Developer User's Guide. If this is the first time you have started SQL Developer on your system, you are prompted to enter the full path to java.exe (for example, C:\Program Files\Java\jdk1.6.0_021\bin\java.exe). Either type the full path after the prompt or browse to it, and then press the key Enter. In the Connections frame, click the icon New Connection. In the New/Select Database Connection window: Type the appropriate values in the fields Connection Name, Username, and Password. For security, the password characters that you type appear as asterisks. Near the Password field is the check box Save Password. By default, it is deselected. Oracle recommends accepting the default. If the Oracle pane is not showing, click the tab Oracle. In the Oracle pane, accept the default values. (The default values are: Connection Type, Basic; Role, default, Hostname, localhost; Port, 1521; SID option, selected; SID field, xe.) Click the button Test. The connection is tested. If the connection succeeds, the Status indicator changes from blank to Success. Complete Notes Available
Views: 2 PSL 4 Live 2019
Hello Everyone, In this tutorial, Let Us Reset Root Password & Forgetter… To Fix Broken Sudo....... Errors that you are getting.......... Error 1:- you may notice an error saying you're not in the sudoers file and the incident is going to be reported. Error 2:- sorry user usuario is not allowed to execute '/usr/bin/passwd root' as root on. Error 3:- Give root password for maintenance (or type Control-D to continue) SOLVING ERROR 3 BY BELOW STEP FOLLOW Step1 :- fsck (First You need to Check file checking error, if doesn't solve follow below step) Step2 :- mount -t proc proc /proc Step3 :- mount -o remount, rw / or mount -ro remount,rw / Step4 :- passwd vi /etc/default/locale Step5 :- sync reboot Step6 :- reboot or option(above doesn't solve follow below step) Step7 :- mount | grep ' on / ' That command produces something like /dev/sda1 on / type ext4 (rw,errors=remount-ro,commit=0) as the output Step8 :- sudo mount /dev/sda1 /mnt Replace /dev/sda1 with the device name of the partition containing your Ubuntu system's root filesystem, if different. Step9 :- sudo mount /dev/sda1 /mnt Step10 :- passwd root Step11 :- exit Step12 :- sudo umount /mnt Step13 :- exit Step14 :- reboot Cause and symptoms :- the /etc/sudoers file has been altered to no longer allow users in the admin group to escalate privilege the permissions on the /etc/sudoers file are changed to something other than 0440 a user who should not have been has been taken out of the admin group. By above error and cause can be done by following steps..... To Reset Root Passwd step1 :- Restart your server or desktop step2 :- press continue shift untill boot menu show step3 :- select ubuntu generic second option press Enter step4 :- then select root shell press Enter step5 :- type mount -o rw,remount / step6 :- sudo passwd root or passwd assign passwd and then repeat again the same passwd Note :- inplace of root you can set your username or hostname any name that You assign during Installation OR Login. You can also Create NEW USER step7 :- sudo adduser username (Replace USERNAME with your username) Step8 :- sudo passwd username If you don't know your username, you can get a list of users on the system by running: Step9 :- ls /home NOTE :- For Any Clarification Please Below Comment, Like and Share us and help us to spread. ####--------------------------------------------------------------------------------------#### Subscribe :- http://www.youtube.com/user/itcloudnet?sub_confirmation=1 Website :- http://www.cloudnetwork.in Facebook :- http://facebook.com/itCloudNetwork/ Twitter :- http://twitter.com/itcloudnet Pinterset :- http://pinterset.com/itcloudnet LinkedIn :- http://in.linkedin.com/pub/itcloudnet Google+ :- https://plus.google.com/u/0/107923552480070716949/posts Skype Id :- cloud.network1 E-Mail Id :- itclo[email protected] ####----------------------------------------------------------------------------------------#### Thanking You Hope U Like it........
Views: 10446 Cloud Network
Go to Properties in My computer Advanced system settings------- Advanced ----- Environment Variables Select 'PATH' from the list of system variables and edit and set PATH to c:\windows\system32 ; this will solve your problem
Views: 101899 Solve in Web
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10g R2 (10.2.0.1) on Linux 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 - () 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 Oracle10g Release 2 - (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Install and configure Automatic Storage Management (ASM) - (Video) 1.18 Install Oracle Database 10gR2 Software - (Video) 1.19 Install Oracle Database 10g Companion CD Software - (Video) 1.20 Create TNS Listener Process - (Video) 1.21 Create ASM Instance - (Video) 1.22 Create a Cluster Database - (Video) 1.23 Post-Installation Tasks - (Optional) - (Video) 1.23.1 Re-compile Invalid Objects - (Video) 1.23.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.23.3 Create Shared Oracle Password Files - (Video) 1.24 Verify TNS Networking Files - (Video) 1.25 Create / Alter Tablespaces - () 1.26 Verify the RAC Cluster & Database Configuration - (Video) 1.27 Verify Cluster Network Configuration - (Video) 2. RAC Database Administration and Workload Management 2.1 Starting / Stopping the Cluster - (Video) 2.2 Transparent Application Failover - (TAF) - () 2.3 Configuring the Server Parameter File(SPFILE) in RAC - (Video) 3. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.3 3.1 Download and Extract the Installation Software - (Video) 3.2 Pre-installation Tasks for Patch set and Release Upgrades - (Video) 3.3 Oracle Clusterware Rolling Upgrade - (Video) 3.4 Apply the patch 10.2.0.3.0 to the ASM Home - (Video) 3.5 Applying Patch set to Oracle RAC - (Video) 3.6 Upgrading Oracle Database 10.2.0.x to 10.2.0.3.0 Using DBUA - (Video)
Views: 308 Yongcheng Lai
Views: 2731 Lent
General Query Logging for MySQL in Windows: If General Query logs are enabled without providing the location for General Query log file, then by default location for the General Query log will be "C:\ProgramData\MySQL\MySQL Server 8.0\Data" and file name will be "HostName.log". To make change for General Query log file location and name , you can go to my.ini file on below path "C:\ProgramData\MySQL\MySQL Server 8.0", Look for general-log=0 general_log_file="HostName.log" Change the value general-log=1 to enable it. if you would like to update the location for file, you can change in general-log-file=Folder Path/GeneralQueryLogFile.log General Query Log File in Linux: The default location for General Query log file for MySQL installed on Linux is /var/lib/MySQL. If you need to make changes to default location and binary file name, you can go to /etc/my.cnf file and update it. In case of default location, the name of the file will be "HostName.log". You can add below configuration to /etc/my.cnf to enable or disable General Query log. general-log=0 general_log_file="/DirectoryPath/HostName.log" Once you will make the changes, you will be restarting the MySQL service. To follow step by step tutorial for MySQL DBA for beginner to Advance http://www.techbrothersit.com/2018/11/mysql-dba-tutorial-beginner-to-advance.html MySQL Workbench Tutorial MySQL DBA Certification Training MySQL DBA Tutorial Step by Step MySQL DBA Training online free MySQL Real Time DBA Tutorial MySQL Administration Course step by Step MySQL Tools for Development and Admin
Views: 236 TechBrothersIT
Follow this step by step tutorial to learn how to set environment variables from system settings in the windows operating system. 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 windows. Operating systems require environment variables as settings and configurations for several processes. Although these variables are automatically defined or initialized during the installation of the system or specific software, in windows, to set environment variables manually is not a difficult task. That's because windows allows us to manually add, remove or edit environment variables through system settings according to our requirements. Step # 1 -- Opening environment variables In windows, to set environmental variables, you can take two paths. Either we can go to control panel, then access the system security option, and then the system option. Or we can simply right click on My Computer and select its properties. Once we are in the system window, select the advanced system settings from the list on the left side. A new window will pop up. Over here, click on the environment variables button near the bottom of this window and you can now access the Windows environment variables. Step # 2 -- Adding a variable In this window there are two sets of environment variables, one is the "user variables", and the other is the "system variables". Choose the new button in the user variables section to open the "define a new variable" dialog window. Over here, you will be required to define the variable name as anything you wish to set, such as temporary and then define its value as the path to the directory. With that done, let's complete this process by pressing OK. Your new environment variable has been created now. Step # 3 -- Editing and removing a variable To edit an environment variable, click on it, and then click on the edit button to open a dialog window. Here we can edit the name and value of the variable. Likewise to remove an environment variable, simply click on the variable and then click on the delete button. Once all the definitions are complete, close the window and restart your computer to allow the operating system to load these settings on boot. And that's basically all you need to know for how to set environment variables in windows.
Views: 130778 Best Video Tutorials and Help from HowTech
More videos like this online at http://www.theurbanpenguin.com Oracle Solaris 11 has a security mechanism within RBAC that goes beyond the normal OS security we may expect to find. We may want a user account to be able to back-up the complete file-system for this they will need to be able to read all files. It is a mammoth task to ensure the user has read access to all files so often the root account may be used for this. Using privileges within RBAC we can assign the user file_dac_read which allows them to read files even though they may not be in the files ACL. Now we maintain the security that we need using the concept of Least Privilege
Views: 1690 theurbanpenguin
Oracle Database Pre-requisite information and checking. Checking your Host name : It should be fully qualified Host name. Make required arrangements. Check for the required rpms. Need to check metalink note and get the missing ones installed. Can take help of YUM utility. Need to configure this first prior to getting other RPM's. check this video to get steps how to configure YUM Utility. Configuring the repository. Hope you get better understanding of YUM. If still having any doubts please check other videos in google/Youtube for better picture for your OS version. Yum Install Make sure all the rpms are installed The ones shown in this video are not mandatory but are good to have. All you got to do is fire that command and wait. Yum update : this will get to latest versions. It will check for the dependencies and all the required things will be done automatically. Based on your bandwidth you will see that all the RPM's get installed. Check the report for any errors and manually install them. IF lucky enough all will be installed without any issues. 716 Packages get installed. (As mentioned these aren't mandatory). Choosing OEL Linux version would save lot of your Pre-requisite works.. ------------ Make sure parameters are properly there under /etc/sysctl.conf files. Verify and mismatched values are to be updated. You can ignore if the values are greater than minimum requirements. Check video for more details how did I do that. /etc/security/limits.conf values should match to the one shown in the video. Make sure oracle user is created or not? If not need to create it. check for groups and create them accordingly. Check for permissions. Putting the passwords Check the parameter SELINUXTYPE Create required directories. Tweak your directories based on client naming conventions. Sample changes are shown in the video. Decide on your locations and ORACLE_HOME,ORACLE_SID and create the missing directories. Place permissions to newly created directories. Update values in profile and source it to get these parameters activated. Create VNC Session and check for the windows working. Test it with xclock or any other GUI. Check and fix the display settings. Review and fix with some of the tips provided in the video. Once all are set you are good to go with Installation process. Check other video where I have a demo Walk through Installation wizard. This is Kiran Signing off
Views: 481 kiran ginni
This video shows you how to install Debian 8 (Jessie) in VMware Workstation 12. Debian 8.2 GNOME is used in this video. English Subtitle is available for this video. You can also contribute subtitle for your language. Debian is known for its rock-solid foundation, nothing could possibly go wrong on a Debian linux server. It is easy to manage a Debian system. Debian is flexible and can be configured as a desktop, or as a server. Debian made dpkg manager, which is the underlying system on several popular distros like Ubuntu and Mint. Debian Website: https://www.debian.org/ Website: http://www.sysadminshowto.com/ Facebook Page: https://www.facebook.com/SysAdminsHowto/ Twitter: https://twitter.com/SysAdmHowto Google Plus: http://google.com/+Sysadminshowtos Video URL: https://youtu.be/-C1UDPg9YQ8 0:00:02 Today, It's my honor to show you how to install Debian 8.2 Jessie in VMware Workstation. 0:00:08 I have been using Debian for almost 15 years. 0:00:11 Debian is one of the oldest Linux distribution, which first released in 1996. 0:00:18 It has served as the framework for many other distributions. 0:00:23 Such as Ubuntu, Linux Mint and Kali Linux 2 and many others. 0:00:28 Debian 8 offers different desktop environments but GNOME is the primarily supported interface. 0:00:34 In this video, I will also use GNOME. 0:00:37 Debian is a great choice for both workstations and server systems. 0:00:44 First, we'll go to Debian website and download Debian 8.2 Installation media. 0:00:50 and we'll create a virtual machine. 0:00:52 and we'll start Debian 8 installation. 0:00:56 After the installation, we'll do post installation tasks. 0:01:03 Open up your browser and go to Debian website. 0:01:17 You can see "Try Debian live before installing." Click it. 0:01:22 You see 32-bit and 64-bit editions. 0:01:34 As you can see, there are many installation medias. 0:01:38 All of these are the same but with different Desktop Environments 0:01:43 Such as Cinnamon, GNOME, KDE, MATE etc. 0:01:46 In this video, I will use Debian 8.2 GNOME Desktop. 0:01:54 As you can see I already downloaded installation media. 0:02:04 Second step is to create a virtual machine. 0:02:09 You can Click "Create a New Virtual Machine" or 0:02:12 go to file then Click " New Virtual Machine" 0:02:21 Click Installer disk image file and then click Browse. 0:02:27.100,0:02:29.300 Go to your installation media. 0:02:32 VMware Installer could not detect which operating system is in this disc image. 0:02:44 At Select Guest operating system screen, Choose Linux 0:02:51 Choose Debian 8 64-bit and then Click Next. 0:03:00 Give a name to your Virtual Machine. Let's say "debian8" and click Next. 0:03:11 Recommended disk size for Debian 8 is 20 GB but I want 40 GB virtual disk space. 0:03:22 I also want to store virtual disk as a single file. 0:03:27 I want to customize my virtual hardware. 0:03:32 I wan to change virtual memory to 2 GB 0:03:47 I want Bridge networking. My virtual machine can connect to my physical network directly. 0:04:10 Click Power on this virtual machine. 0:04:22 Choose Graphical Install and press Enter. 0:04:31 At select language page, choose language used during the installation. English is OK. 0:05:16 Give a name to your Debian. Let's say debian8 0:05:21 This is the hostname of your virtual machine. 0:05:38 Set your root password here and click Continue. 0:05:46 Let's create a new user! 0:06:06 Set username for this new user. 0:06:16 Set password for new user. 0:06:26 Configure your Time Zone. 0:06:35 At Partition disks, you can choose Guided - use entire disk or... 0:06:41 entire disk and set up LVM or encrypted LVM or Manual. 0:06:48 Let's use Guided entire disk. 0:07:06 Let's choose All files in one partition - recommended for new users. 0:07:16 We can finish partitioning and write changes to disk. 0:07:24 Write the changes to disk? Choose 0:07:36 Installation has just started. 0:07:56 It asks "Use a network mirror?" Choose Yes. 0:08:04 Choose the nearest location to you. 0:08:09 Choose a network mirror. 0:08:15 If you use HTTP proxy, set it here. 0:08:20 I don't have any proxy so I left it as blank. 0:08:35 It asks "Install the GRUB boot loader to the master boot record?" 0:08:42 Choose Yes! Otherwise your virtual machine cannot boot. 0:08:48 Choose the correct hard disk! 0:09:01 It's now finishing the installation. 0:09:28 Debian 8 Virtual Machine is booting up! 0:09:33 Login as user that we created during the installation. 0:09:47 We've just installed Debian 8.2 Jessie in VMware Workstation. 0:09:54 Let's go back to our notes and do some post installation tasks. 0:10:02 First, let's check open-vm-tools is installed or not! 0:10:16 Run "dpkg -l | grep open-vm-tools" 0:10:29 As you can see, Open VMware Tools is already installed. 0:10:43 Go to to View and then click Fit guest now. 0:10:56 You can also use file copy between the host and guest operating system. 0:11:03 Let's try to copy a file from host to this virtual machine.
Views: 27922 SysAdminsHowto
Oracle's Greg King describes the help features available from the Oracle VM command line interface.
Views: 680 OracleVirtualization
New to Oracle and .NET development? This video gives you everything you need to know to get up and running quickly! We walk you through downloading and installing the needed Oracle software and then connecting in Visual Studio and creating a simple C# application. The video starts at the Oracle .NET Developer Technology Center website at http://otn.oracle.com/dotnet We then download the "ODTwithODAC" package, extract it and run the installer. Note that ODAC version 12 works with Oracle Database versions 10.2 or higher. After installing we connect in Server Explorer and learn about the connection dialog features, including the Filters tab which by default filters out additional schemas you may have privileges on. We connect to the database using the easy to use EZ connect format. Finally we create a simple C# application and connect to the database using ODP.NET Managed driver and a EZ Config connect string. Prerequisites: 1) Visual Studio 2012 or 2013 -- any edition except Express Edition. Visual Studio Community Edition is supported. 2) An Oracle Database to connect to. You will need to know the hostname, port number and service name of the database. During the video we install: Oracle Data Provider for .NET Oracle Developer Tools for Visual Studio Oracle .NET Samples Oracle .NET Documentation
Views: 77300 Oracle .NET and Windows
Mike van der Velden, Product Manager at Simba Technologies, provides a step-by-step guide for configuring Microsoft Excel to connect with Oracle Database OLAP Option. Mike walks through the one-time set-up of Oracle's Transparent Networking Substrate (TNS), followed by the Data Source Name (DSN) and Office Data Connection (.odc). Once configured, Microsoft Excel connects easily to Oracle Database OLAP Option for ad hoc data query, data analysis and BI reporting.
Views: 163235 Simba Technologies Inc. a Magnitude Company
Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Grab your free 10-Point WP Security Checklist: http://bit.ly/10point-wordpress-hardening-checklist Error establishing database connection is a very common error that I bet every WordPress user has encountered at some point. Luckily the fix is very easy and there are two ways to fix it. Nearly every time this error is caused by incorrect or incomplete database information in your wp-config.php file or no linking the database user to the database. Let's tackle the first one first. Incorrect or incomplete database information in your wp-config.php All you have to do here is double check your MySQL database name, database username and the database user password. Make sure the credentials you have in the wp-config.php match exactly to the ones you created. If you're not sure where to find the ones you created, log into your cPanel account. Then click on MySQL databases. That will show you all the database in your hosting account. Find the correct on for the wp-config.php file you're working on. Make sure the db name matches what's in the file. Then find the db username you have linked to that database and what's in the wp-config.php file matches exactly what's associated with your database. If you don't remember the password, or have it noted somewhere, you can generated a new password for the user and put that into the wp-config.php. While you're here, you can make sure that the second possible reason for the error is taken care of. At the bottom of the MySQL database page you will be able to link the database user to the database. Make sure they are linked and the correct privileges are set. If you're unsure of the proper privileges, choose them all. Now save the db user to database association. Save the wp-config.php file you were updating. Then go to the page that was generating the error establishing database connection error and reload that page. Everything should be working normally now. Subscribe to this awesome channel here: http://www.youtube.com/subscription_center?add_user=wplearninglab
Views: 32024 WordPress Tutorials - WPLearningLab
Learn how to connect to a database cloud instance in Oracle Database Cloud Service. ================================= For more information, see http://www.oracle.com/goto/oll 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.
Views: 2399 Oracle Learning Library
SQl management studio provides lot of facilities to manage SQL processes. The “Activity monitor screen” which will show you some very useful and important information about SQL processes. It will show you all active processes, there status, number of open transactions for each process, the application by which the process is generated, Wait time CPU and memory utilisation, and the host name, means the host or the machine by which the process is initiated etc. If a process is hanging, it will show the process icon with an hour glass. Refresh it several times, sometimes the icon will turn to sleep mode if the process completes its execution. If the icon remains an hour glass, the process may be hanging. Use other info as well to decide if the process is really hanging. If you double click on the process ID it will show the SQL stamen subjected to the execution of the process. If a process is hanging you can identify which application has originated the process, which SQL stamen is hanging and even more from which machine or the host the process is initiated If some application users are complaining about uneven slowness, uneven timeouts etcetera, the reason behind may be one or more processors are hanging. What can you do now? You can restart the SQL server or the service which will disconnect all databases and all applications disturbing all the users. Or otherwise you can take the database to off line and bring it back to online. Or you can disconnect all connections to the database. The disturbance may be lesser than the previous case but still lot of applications and users can be disturbed, especially in an industrial setup. And still you do not know the real reason for the slowness or the malfunctioning as well. So what can you do? Go and examine the processors. Identify exactly which process is hanging. And most probably you will be identifying how and why. So you can find permanent solution. But the immediate solution is you can kill the troubling process or the few. It will solve the issue with minimum disturbance immediately. After identifying the correct process, you can right click on the process ID and click on ‘Kill process’ button. It will kill the selected process. You can kill processors using SQL statements and, using SQL commands you can kill all processors at once as well. Code for Killing Processes Individually USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' EXECUTE ('KILL 53') Code for killing all Processes USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE ('KILL ' + @spid) SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid @spid END
Views: 6983 Rohan Mehtha
Hello Everyone, In this tutorial, Let us Install Reset Root Password on Redhat Linux 6 or 7 -- 64Bit or 32Bit Note :- Watch Next Video on How to Reset Root Password in CentOS 7 https://www.youtube.com/watch?v=ljj3ebPUd8s&list=PLmMAzSMza_1c8iKqez6CJlvJ-AJEi1Rm4 Note :- Watch Next Video on How to Reset Root Password in Fedora 21, 20 https://www.youtube.com/watch?v=GIiXnpK_tO0&list=PLmMAzSMza_1c8iKqez6CJlvJ-AJEi1Rm4&index=15 Procedure….. Fix Broken Sudo....... Errors that you are getting.......... Error 1:- you may notice an error saying you're not in the sudoers file and the incident is going to be reported. Error 2:- sorry user usuario is not allowed to execute '/usr/bin/passwd root' as root on. Cause and symptoms :- the /etc/sudoers file has been altered to no longer allow users in the admin group to escalate privilege the permissions on the /etc/sudoers file are changed to something other than 0440 a user who should not have been has been taken out of the admin group. By above error and cause can be done by following steps..... To Reset Root Passwd step1 :- Restart your server or desktop step2 :- press continue shift untill boot menu show step3 :- select ubuntu generic second option press Enter step4 :- then select root shell press Enter step5 :- type mount -o rw,remount / step6 :- sudo passwd root or passwd root assign passwd and then repeat again the same passwd Note :- in place of root you can set your name,hostname any name that u assign during installation OR Login. You can also Create NEW USER step7 :- sudo adduser ubuntu and give new passwd ------------------------------------------------------------------------------- For Your Information Only I am Willing to Make a FREE or CHARGE Website, if YOU WANT ME TO MAKE A VIDEOS ON Different Technologies I WILL DO IT.. Share My Video, Like it, Watch Others Videos and Have any Quries Email me ([email protected]) ---------------------------------------------------------------------------------- NOTE :- For Any Clarification Please Comment Below Comment, Like and Share us and help us to spread. ####--------------------------------------------------------------------------------------#### Subscribe :- http://www.youtube.com/user/itcloudnet?sub_confirmation=1 Website :- http://www.cloudnetwork.in Facebook :- http://facebook.com/itcloudnetwork Twitter :- http://twitter.com/itcloudnet Pinterset :- http://pinterset.com/itcloudnet LinkedIn :- http://in.linkedin.com/pub/itcloudnet Google+ :- https://plus.google.com/u/0/107923552480070716949/posts Skype Id :- cloud.network1 E-Mail Id :- [email protected] ####----------------------------------------------------------------------------------------#### Thanking You Hope U Like it........
Views: 43481 Cloud Network
Vulnerability: SQLi Severity: High Owasp rank: (OTG-INPVAL-005) The Open Web Application Security Project (OWASP) is a worldwide free and open community focused on improving the security of application software. The ranking of all vulnerabilities on this channel are followed by Owasp Testing Guide version 4.0. https://www.owasp.org/images/1/19/OTGv4.pdf #TDWFB #TheDayWeFightBack
Views: 190 Vulnerables
Steps to install RHEL 7 or RHel Install Red Hat Enterprise Linux 7.0. After the system loads, select the language for installation process and hit on Continue. ... Select Language for Installation. ... Language System Support. ... Select Network Location. ... Select RHEL 7 Minimal Installation. ... Set System Hostname. ... Begin RHEL 7 Installation. ... Set root Password. User Creation After the installation finishes the installer will announce that everything completed with success so you should be ready to use your system after reboot.
Views: 17 shubh malviya
Guide step by step teach you how install CentOS 7 in VMware Workstation player in your PC or Laptop. ----------------------------------------------------------- How to install CentOS 7 in VMware ----------------------------------------------------------- 1)Download CentOS 7 ISO from https://www.centos.org/download/ - choose any download link near your country for faster download speed. 2)Download VMware Workstation player and install. 3)Launch your VMware Workstation player after install. 4)Create new VM, usually i will choose install the OS later. 5)To install CentOS7,select linux and other linux 3.x 64bit and next. (if you choose Centos 64bit, the installer will not detect any network devices) 6)Key any name for your VM name, and the location is store your VM file and virtual disk. 7)Disk size put any as you want. 8)Click Customize hardware, you may adjust your memory and VCPU here, and also mount the ISO file to the VM's DVD room for boot and install the OS. 9)Network adapter, usually i select bridge mode, directly connect to your physical network, if your network with DHCP, you can get the IP automatic and online after install. 10)Power on the VM you created and begin centOS installtion. 11)Select the language and continue -Date and Time, select your country. 12)Software selection: usually minimal install, you may select the program that you want to use. btw, i will install the server without GUI. 13)System -installation destination: create your disk partition. - choose i will configure partitioning and done -select standard partition and create them automatic. 14)Begin the installation and set your root password. 15)if you choose centos 64bit, this ethernet will not appear here. turn it on, if your network with DHCP, you u auto get the IP. 16)Hostname: any name you want. 17)Begin installation and wait it complete (set your root password) and reboot. 18) Login with your root and password, done !
Views: 3745 Kv IsMe
Hi Friends, Now We will discuss about MSSQL Connectivity and fetch data from SQL Table --------------------------------------------------------------------------- First Check the table available in MSSQL or not and create one sample table with two columns Create table sample(no int,name text); HostName: BALAJI-PC\SQLEXPRESS I am going to create above table completed successfully. let me check query the table select * from sample; Now we will create a bot to fetch data from table. For this we will insert dummy data 1. We will use Action stage and 'Data - SQL Server' VBO to configure the database details Using the set connection we need to configure the SQL Server details Server - BALAJI-PC\SQLEXPRESS Database - Robotics-DB For my database no username and no password I Created againt the table using IDE. updating the query with this SELECT * FROM [Robotics-DB].[dbo].[sample] So, those are empty 2. we will use Action Stage to query the data We have a Action called 'Get Collection' SQL - select * from sample Now we got the data. Let's do the insertion of records For this we need to use Execute Action in Data - SQL Server' VBO insert into [Robotics-DB].[dbo].[sample] values(4,'Manager') Now we got the data with inserted record into collection Thank you for watching video and output will be the collection and success & message 3. Let's link it and execute we got error saying that invalid object name 'sample' That means unable to identify the table name Let me solve it
Views: 9080 Reality & Useful
In this step by step project from the SAP HANA Academy, we illustrate a simple example of building an application using native development tools for SAP HANA. This video provides a basic introduction to the SAP HANA Studio tool components. To access the code snippets used in the video series please visit https://github.com/saphanaacademy/Live2 Connecting to the Server: Bob wants to connect SAP HANA Studio to the SAP HANA Once server and shows how to in 6 steps. 1. In SAP HANA Studio Bob clicks on the double windows in the top left corner to open a perspective. Bob chooses to leave the default SAP HANA Administration Console perspective. 2. On the left hand side Bob right clicks and selects add system. 3. Next, Bob goes to his folders and clicks on computer, then the C Drive, then the Windows folder, then the System 32 folder, then the drivers folder, then the etc folder, before finally right clicking and opening the hosts file in notepad. 4. At the bottom of the notepad Bob writes in the IP address of the Linux box that contains the SAP HANA One instance followed by the word hana and then clicks save. 5. Back in SAP HANA Studio Bob enters hana as the host name and 00 as the instance number before clicking next. 6. Next, Bob chooses the authentication by database user option, enters system as the user name and the password he created in the SAP HANA One management console and clicks on store user name and password in secure storage before clicking finish to establish the connection. Creating a Schema: Bob wants to create a new schema and shows how to in 4 steps. 1. On the left hand side above HDB System Bob clicks on the SQL button to open a SQL window. 2. Next Bob clicks on catalog. 3. In the SQL window Bob enters create schema live2 and clicks the green execute button. 4. Bob then right clicks on catalog and chooses refresh to see his created schema. Creating a Table: Bob wants to create a new table in his empty schema and shows how to in 3 steps. 1. Bob highlights the table folder in the Live2 schema and opens a SQL window. 2. In the SQL window Bob enters: set shcema live2; CREATE COLUMN TABLE "Members" "memberId" INTERGER NOT NULL "firstName" NVARCHAR (5000), "lastName" NVARCHAR (5000), "email" NVARCHAR (5000), "avatar" NVARCHAR (5000), "lat" DOUBLE "lon" DOUBLE PRIMARY KEY ("memberId") ); 3. Bob clicks execute to create his table in the live2 schema. More information about creating table can be found by entering SAP HANA tables into a search engine and at the SAP HANA Academy. Bob enters the SQL for three additional tables (connects, tweets, and timewindows) and clicks execute to add the tables to his schema. Bob gets the syntax for the tables from the HANA Live2! Project Overview. Creating a User with Selected Access: Bobs wants to create a user that has read only access rights and shows how to in 6 steps. 1. Bob opens the security folder and right clicks on users and selects new. 2. Bob names the user and creates a password. 3. Next, Bob opens the object privileges tab and clicks on the green plus sign. 4. Bob searches for Live2 and selects the schema. 5. Then Bob clicks to put a checkmark next to SELECT and chooses no for grantable to others. 6. Bob clicks execute to create the user. To test the user's rights Bob connects to the server with the new user and tries to delete the tables in the live2 schema but is denied access.
Views: 39168 SAP HANA Academy