Home
Search results “Sid oracle set”
How to know your oracle SID name
 
07:15
...................................................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: 23417 Mahfujur Rahman
How to find out the SID and DB Home in Oracle Database by Manish Sharma
 
05:10
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: 1183 Manish Sharma
How to find Oracle Service Name by sql command
 
01:40
If you have an Oracle database on your network which is able to connect to with Oracle SQL Developer, using hostname, port, username, password and the SID. you need to connect another application, however it uses the Service Name instead of the SID. it is the way for to you to determine the SERVICE_NAME of the database when you am connected in SQL Developer via the SID thanking you... just share this video to your friends...
Views: 17056 w3h
Oracle DBA Justin - How to set the Oracle environment on a Unix or Linux system
 
28:22
How to set the Oracle environment on a Unix or Linux system
Views: 49195 jbleistein11
How to Rename an Oracle Database Name Manually steps by steps | Oracle Tutorial
 
06:53
Hello Friends in this video i'm going to demonstrate you how to rename oracle database manually step by step. #renameoracle #database #ocptechnology Oracle Interview application https://play.google.com/store/apps/de... My Facebook page https://www.facebook.com/ocptechnology My Second Channel https://www.youtube.com/4usupport My Instagram https://www.instagram.com/ocptechnology/ My Website http://ocptechnology.com/ My twitter https://twitter.com/ocptechnology
Views: 1513 OCP Technology
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 191759 Chris Ostrowski
Create new connection with new user in Oracle SQL Developer
 
10:28
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: 360477 Chitu Okoli
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
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: 282422 Manish Sharma
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 
06:44
This video will show you How to fix "MSVCR100.dll missing from your computer" error which comes for various application when you try to run the application like Visual studio 2008, 2010 or 2012, wamp or php server, some popular games etc. Follow the steps that i have showed in this video. For that i have used the following link to download MSVCR100.dll file. Use this link to download the dll file http://jhelioviewer.org/libjhv/Microsoft.VC100.CRT-x86-32/msvcr100.dll
Views: 52757 Bangalore Techie
How to Connect SQL in Oracle | Listener does not know of SID given in connect descriptor | ORA-12505
 
01:49
How to Connect SQL in Oracle | Listener does not know of SID given in connect descriptor | ORA-12505 ---------------------------------------------------------------------------------------------------- In this tutorial i'm going to demonstrate you how to configure oracle network environment step by step. Database Configuration Assistant,DBCA Oracle 12c,DBCA Command Line,DBCA-Silent 12c,Oracle 12c,database configuration assistant, database, oracle database (software), sql, sql developer, sql tutorials, dbca, how to create database using dbca, how to create database in oracle, how to create schema in oracle, how to create oracle database, how to create database, silent mode database, database tutorial, create new database, create database, silent, mode, creation, in oracle, oracle tutorial, steps by steps, oracle in easy mode, oracle 12c (windows 10),database connection, how to configure oracle listener,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner,ORA-12505: TNS:listener does not currently know of SID given in connect descriptor, The program can't start because MSVCR100.dll is missing from your computer, The program can't start because MSVCR100.dll is missing, msvcr100.dll is missing wamp server error, msvcr100.dll is missing wamp server download, msvcr100.dll is missing apache, apache exe msvcr100 dll missing, msvcr100.dll is missing while installing php, easyphp msvcr100.dll missing, oracle, sql, database, installation, TNS Please Subscribe My Channel
Views: 1367 Learning With Mahamud
How to set bash profile for ORACLE HOME environment
 
02:26
Bash profile for Oracle Home
Views: 5567 oracleora
Oracle Developer 10g  Installation Problem in Windows 7 and Solution
 
03:07
Oracle Developer 10g Installation Problem in Windows 7 and Solution by Russel Ahasan
Views: 6267 Russel Ahasan
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor |Eclipse(solved)
 
02:02
You can see this error while the DB service is down. Try this: Run - services.msc then search for your service and start it.
Views: 8062 Rishabh Raj
Set Up a new Connection in Oracle SQL Developer
 
02:23
https://www.databasestar.com/introduction-oracle-sql-course/ In this video, I’ll show you how to set up a connection in SQL Developer. SQL Developer is Oracle’s free IDE for working with your SQL database. It’s one of the best tools available, and used by a lot of people. As part of my Introduction to Oracle SQL series of videos, I use SQL Developer to set up the data and explain the concepts. The first step once you have downloaded the application is to set up a connection. What is a connection? A connection in SQL Developer lets you connect to a database. You enter in a set of data once for your database, and SQL Developer remembers this and lets you connect to the database. You provide the following data: - Connection name - Username - Password - Server details (e.g. server, port, SID) The connection can have a name to help you remember it in the future. Connections can also be colour coded to make it easier to see which connection you’re working on! So, to find out how to set up a connection in SQL Developer, watch this video! Let me know in the comments if you have any questions.
Views: 3947 Database Star
Oracle Database 11g XE (Express Edition) Install guide and connect with SQL Developer
 
18:16
Welcome to MyOnlineEdu.com's video tutorial. In this video you will learn how to install Oracle Database 11g XE (Express Edition) and then connect the database using Oracle SQL Developer IDE tool. You can avail an instructor based live class from MyOnlineEdu.com. To enroll click the lick: https://www.myonlineedu.com/course/view/6/oracle-sql-and-plsql-11g-fundamentals
Views: 366190 MyOnlineEdu.com
Oracle: fixed errors 17002 and 12505
 
02:52
Oracle Database 11g XE: sqldeveloper new connection, fixed errors IO Error: The Network Adapter could not establish the connection Vendor code 17002; ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Views: 48923 Integral
Change SID on Windows 7
 
03:30
Change SID on Windows 7 join domain.
Views: 11719 Happy Ghost
How connect Oracle SQL Developer to a local Oracle database
 
06:25
This video shows how to set up a local Oracle database and connect to it with SQL developer. LINKS: Oracle 11g database: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Oracle SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 6400 MineIsPolo
How to unlock HR sample user in Oracle Database 18c by Manish Sharma
 
14:03
RebellionRider.com presents how to unlock sample schema/user in Oracle Database 18c by Manish Sharma. Timestamps ( 01:12 ) Step 1: Find out the container ID ( 02:10 ) How do we get to know whether we are connected to a CDB or PDB ( 04:41 ) Step 2: Find out the service name ( 05:49 ) Step 3: Create an entry in TNSNAMES.ORA ( 09:13 ) Step 4: Switch from Container DB to Pluggable DB ( 11:04 ) Step 5: Unlock the HR user ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/unlock-schema-in-18c Previous Tutorial ► How to Install Oracle 18c on Windows https://youtu.be/kptbJ22kfqA ►TNSNAMES.Ora file at GIT https://github.com/RebellionRider/Oracl18c/blob/master/tnsnames.ora ------------------------------------------------------------------------- ►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
Views: 4965 Manish Sharma
SQL Developer: Install and configure SQL Developer on windows | How to install SQL Developer
 
15:52
How to install Oracle SQL Developer in Windows 7 Oracle 11g Express & SQL Developer Install How to Download and Install Oracle SqlDeveloper Install and Configure Oracle SQL Developer on Windows Follow me: https://www.facebook.com/munir.du https://twitter.com/munir_du https://www.linkedin.com/in/md-munir-hussain Contact me: [email protected] How to configure SQL Developer on windows ----------------------------------------------------------------------- Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. SQL Developer supports Oracle Database 10g, 11g, and 12c More details: http://www.oracle.com/technetwork/developer-tools/sql-developer/what-is-sqldev-093866.html Requirements for SQL Developer: a. Oracle database 10g or 11g or 12c b. JDK8 or above To download and synchronize SQL Developer 4.1.3 on windows using the following steps: At first, Install JDK8 Download required (32/64 as per your system) JDK8 from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html Extract sqldeveloper-4.1.3.20.78-no-jre Download SQL Developer from: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Now, copy this folder named sqldeveloper Then copy to Oracle home directory Open this folder Create shortcut for SQL Developer: Right click on sqldeveloper.exe Then send to desktop(create shortcut) To configure: Run SQL Developer by double clicking You need to a connection: Click on green plus (+)sign for connection Enter following information: Connection name: your connection name like HR Username: hr (your username) Password: hr (your password) Click on Save Password check box Hostname: localhost (my database is install in this machine only, so my host name is localhost.) Port: 1521 (default port number) SID: xe (global database name or your ORACLE_SID) Click on Test button for testing and debugging above information Click on Save than Connect button for connection, if your test status is success. That’s it. Thanks for linking, commenting, sharing and watching more of our videos.
Views: 20032 Leen's Tech
How to install sql developer on Windows 10 Pro 64 bit
 
07:47
How to install sql developer on Windows 10 Pro 64 bit, and also in this video I will show you how to access oracle database (software) 11g r2 using sql developer thanks for watching. Subscribe for more: ---------------------------------- https://goo.gl/oL45FT SWE.Safaa Al-Hayali - saf3al2a TAGS: #How_to_install_sql_developer_on_Windows_10_Pro_64_bit ----------------------------------------------------------------------------------------------------
Views: 112532 Safaa Al-Hayali
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 
01:49
solution of error: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Views: 87613 INNo MATHs
how to configure listener and database in oracle 11g on windows platform
 
05:12
In this video i'm going to demonstrate you how to configure listener and database in oracle 11g on windows platform step by step.
Views: 2028 OCP Technology
How to Create,delete,Start,Stop Oracle  Services-ORADIM Utility
 
13:01
ORADIM Utility in Oracle ==================================== Stopping database instance and Services =============================================================== C:\ oradim -SHUTDOWN -SID CDB -SHUTTYPE srvc,inst Start the database instance and Services =============================================== C:\ oradim -STARTUP -SID CDB -STARTTYPE inst -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA C:\ oradim -STARTUP -SID CDB -STARTTYPE srvc -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA OR net start oracleservice sid Delete an Instance ============================= oradim -DELETE -SID CDB Creating an Database Instance ============================= C:\ oradim -NEW -SID CDB -STARTMODE auto -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA Creating an Database Services ==================================== C:\ oradim -NEW -SRVC OracleServiceCDB -STARTMODE auto -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA ============================================ Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 1148 ANKUSH THAVALI
Oracle DBA Justin - How to change the name of an Oracle database # 1 of 2
 
16:11
How to change the name of an Oracle database
Views: 10167 jbleistein11
How2Find Username and Password of User Account in Oracle Database
 
04:46
In This Video How To Know The Username and Password of Newly Created User Account in Oracle Database 10G. With This Video You Will have knowledge on How To Find How many Number of Users are present in Your Oracle Database.
Views: 19005 Cecret Point
Oracle SQL developer Connection
 
03:47
Oracle SQL developer Connection
Views: 97986 Just Channel
Install and configure Sql Developer on Windows | Oracle Tutorial
 
05:12
How to Install SQL Developer on Windows 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 341633 TechLair
Change SID.avi
 
00:47
changer sid -niit-thanglong.edu.vn
Views: 3076 Le Quan
Oracle Database Tutorial 70: IO ERROR: The network adapter could not establish the connection
 
03:34
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: 157425 Manish Sharma
How to change of oracle database | Steps to change the database name using dbnewid or nid tool
 
16:40
This video describes the steps used for changing the db name using dbnewid tool . This utility is also known as nid
Views: 6457 Wysheid Wysheid
SQL DEVELOPER IO ERROR: The network adapter could not establish the connection | SID error
 
04:53
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: 13386 srikanth
Oracle userName and password reset
 
01:41
Reset your Oracle user password .
Views: 59845 brijesh kumar
How to Implement TDE for Oracle 12c2 Container and pluggable databases
 
19:36
Setup Wallet: Modify the sqlnet.ora file ENCRYPTION_WALLET_LOCATION= (SOURCE= (METHOD=FILE) (METHOD_DATA= (DIRECTORY=Directory location\))) --set password based keystore - container level ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --set auto login keystore - container level ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --open the keystore in root container ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --set master key at root container level ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; --open the keystore in pdb ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --Set database master key in pdb ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; CREATE TABLESPACE encrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\encrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT); CREATE TABLESPACE unencrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\unencrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K; CREATE TABLE TEST_ENC (TEXT VARCHAR2(100)) TABLESPACE encrypted_ts; CREATE TABLE TEST_UNENC (TEXT VARCHAR2(100)) TABLESPACE unencrypted_ts; insert into TEST_ENC values ('This is a secret'); insert into TEST_UNENC values ('This is a secret');
Views: 717 SQL JUNKIESHARE
Oracle 12c Installation Complete Process || SQL Developer Setup || How to create the first new user
 
16:09
Description of this video: == Oracle 12c Installation Complete Process == SQL Developer Setup == How to create the first new user ===================================================== Link for downloading Oracle 12c software: http://www.oracle.com/technetwork/database/windows/downloads/index.html ===================================================== Errors: INS-30011: The string password entered does not conform to the Oracle recommended standards. Cause: Oracle recommends that the password entered should be at least string characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Action: Provide a password that conforms to the Oracle recommended standards. ===================================================== Username : system Password: Manager123 Create user command: CREATE USER *username* IDENTIFIED BY *password*; Example:CREATE USER swapnil IDENTIFIED BY swapnil; Command 2: alter session set "_ORACLE_SCRIPT"=true; Command 3: If you two different sid and you want to change the sid then at the time of login you can connect via below command: ==system/[email protected] Here system is username Manager123 is password and sidwind is SID. ===================================================== Do reach out to me on GMAIL: [email protected] INSTAGRAM: swapnil_g_thaware FACEBOOK: https://www.facebook.com/swapnilthaware SKYPE: swapnilgthaware Tags: #oracle #installation #Developer #SQL #new user #Oracle 12c #SQL Developer Setup #12c #Process #swapnil #thaware #oracle #oracle12c #software #engineer #install #process #database #complete #simple #video #sql #sqlplus #sqldeveloper #achiever
Views: 124 Achiever
How to set Environment Variables in Oracle Database XE 11g in Linux?
 
07:52
Let use get started using our newly installed oracle database XE 11g and see how to set environment variables.
Views: 1265 itasworkshop
How to connect HR sample user with Oracle Database 18c by Manish Sharma
 
08:33
How to connect to your pluggable database using HR or OE Sample user through SQL*Plus in Oracle Database 18c and solve ORA-01017 Invalid Username/password; logon denied error by Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/connect-18c-with-sqlplus Previous Tutorial ► How to unlock HR user https://youtu.be/maLrgeY0InA ------------------------------------------------------------------------- ►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
Views: 3228 Manish Sharma
How to change DBID (Database ID) in oracle
 
07:05
How to change DBID in oracle ================================== Change DB ID in Oracle ================================================= nid target=/ logfile=change_dbid.log oracle change dbid to specific value oracle change dbid 12c change database name oracle 11gr2 oracle nid how to change database name in oracle 10g how to change oracle sid name in 11g what is dbid in oracle alter system set db_name
Views: 183 ANKUSH THAVALI
The tnsnames ora file
 
03:57
#Oracle ##tnsnames Client Connectivity to Database Server Instance
Views: 8056 Hemant K Chitale
FIX: ORA-01034 | Oracle Not Available | ORA-27101 | IO ERROR
 
02:05
Please watch: "How to Rank Videos at #1 in Urdu/Hindi 2017, Using Tube Rank Jeet | SEO | Complete" https://www..com/watch?v=65dqd_lNpoc -~-~~-~~~-~~-~- For More Videos, Please Subscribe my Channel: https://www..com/channel/UCimOZdmTEByzJCpU6ARkuFg?sub_confirmation=1 How to connect to a Oracle Database? This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7/Linux computer, steps to connect to oracle database through command prompt.....!!!!, In this video you are able to resolve the following oracle database error: 1) ORA-01034: Oracle not available, 2) ORA-27101: Shared memory realm does not exist, 3) IO Error: The network adaptor could not establish the connection, solution of error: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor, - Oracle: TNS Error | Protocol Adaptor Error | No Listner, https://www..com/watch?v=s4C5ZBRzJLQ Website: http://mohammadzohaibsplixed.blogspot.com Emails: [email protected] [email protected] Facebook: https://www.facebook.com/SplixeD (Profile) https://www.facebook.com/MohammadZohaibSplixed (Page) Twitter: https://twitter.com/Mr_Zobi Skype: mohammadzohaibsplixed Song: Dread Pitt - Pyro
Installing SQL Developer | How to set Java JDK Path for Installing SQL Developer
 
02:26
Installing SQL Developer. How to set Java JDK Path for Installing SQL Developer. Do subscribe our channel to get more knowledgeable videos like this on computer science languages and concepts.
Using Oracle to read data from SQL Server
 
10:47
Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle. Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across. This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today The plan is also to add more data to the SQL Server table and show this new data back in Oracle. To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases. You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence. Before we start we need to make some changes to the standard Easysoft config files. cat /etc/odbc.ini Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer. Easysoft supports all SQL data types from the version of SQL Server from version 7. Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones. If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up. Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change. As you can see, VarMaxAsLong says "Yes" We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file. cat $ORACLE_HOME/hs/admin/initsqlsrv.ora Please note that HS_NLS_NCHAR must be set to UCS2 Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters. So that's the link between DG4ODBC and the datasource setup correctly. Next we need to set up the Listener entry The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora cat $ORACLE_HOME/network/admin/listener.ora The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC. The ENVS=LD_LIBRARY_PATH tells Oracle what library to load Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier. cat $ORACLE_HOME/network/admin/tnsnames.ora The Oracle Listener now needs to be restarted. lsnrctl stop lsnrctl start OK, that's now started the Listener up again. So we have ensured that all the configuration files are set up correctly. The Listener and tnsnames.ora both set up OK. The final step is to create a link from the Oracle database to the "tnsnames.ora" entry. CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr'; Right, that's all done. Let's access the data in SQL Server now. select * from [email protected]; Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name. OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server. Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle. quit; /usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv insert into demo values (2,'Easysoft') select * from demo select * from [email protected]; And there is the new data. Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com Be sure to let us know if you have any comments or questions. Until next time, thanks again and we'll see you again soon.
Views: 16684 Easysoft Limited
SQL tutorial 36: how to create database using database configuration assistant DBCA
 
12:11
Step by step process of creating oracle database using DBCA database configuration assistant, how to unlock user account of sample schema WATCH FULL VIDEO TO KNOW HOW TO UNLOCK HR SCHEMA Tutorial Consist: How to create general purpose transaction database using DBCA database configuration assistant in Oracle 11g, Links How to create database detail blog: http://bit.ly/how-to-create-database-using-dbca What is archiving and archivelog mode: http://bit.ly/what-is-archiving-in-oracle-database Video Tutorial 1 How to install oracle 11g database http://youtu.be/0NLsJQCvKXY Video tutorial http://youtu.be/-13SbeDavwk 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: 63053 Manish Sharma
Oracle SQL  - Connecting as a SYSDBA - Lab
 
02:07
Use this video as a Lab for connecting as a SYSDBA to your Oracle Database.
Views: 8569 Sam Dhanasekaran
sql developer - connect to oracle 12c database using sql developer with tnsnames.ora
 
06:14
sql developer - connect to oracle 12c database using sql developer with tnsnames.ora Connect to oracle database - how to connect to oracle database using sqlplus in windows: https://youtu.be/8GK4RQuCx_8 In this tutorial "sql developer - connect to oracle 12c database using sql developer with tnsnames.ora" will show you how to configure tnsname.ora in sql developer for oracle database connection, create table in sql developer, insert data in sql developer, and select result in sql developer. You can find me: Facebook: https://www.facebook.com/HingTipi Instagram: https://www.instagram.com/pi_sapphire/?hl=en Linkedin: https://www.linkedin.com/in/tipi-hing-93080261/ Google plus: https://plus.google.com/u/0/115396916707479934437 Twitter: https://twitter.com/TiPiHing photo credit: CREDIT PHOTO https://www.flickr.com/photos/[email protected]/10614978976/in/photolist-hb1xqU-4A4jrh-fPduyd-rcmbAc-fPcRfU-r8Jbhv-5gAYFx-bqrToM-dRFrZg-fNVyov-62Yv2h-nQug-9h8PzA-5aZeqx-9h5FM4-7H6iUU-9h8PrQ-9h5FAc-b78rj-9h5Fv8-fJt9Ex-kqoVuF-jcK5w5-hEoyms-9h5FJ8-Ro3Xc9-9h5FGK-8b8puq-9h5FBR-dfUthv-agLG6c-9h5Fz8-pSbCPg-5A8zDb-jC4vYX-RT31DE-9h8Pqm-4VMqsw-SCqtuw-4VMpCo-bofeWo-fPrqnP-aznTRJ-8vh3ny-7heoWE-jC5rn8-bTzxkx-gYu6fR-9GywxF-fNUJjF Subscribe. Like. Share. Comment. Thanks, sql developer connect to oracle 12c database using sql developer
Views: 2729 Junior Geek
PL/SQL tutorial 25: How To Uninstall Oracle Database 11g From Windows 10 64 bit
 
07:52
Learn How To properly Uninstall Oracle Database 11g From Windows 10 64 bit manually without formatting your computer By Manish Sharma at RebellionRider.com Path For Start Menu Entry C:\ProgramData\Microsoft\Windows\Start Menu\Programs ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/uninstall-oracle-11g-from-win-10 How To Write Killer LinkedIn Summary http://bit.ly/write-killer-linkedin-summary Previous Tutorial ► How To Install 11g on windows 10: https://youtu.be/d_CyuCLC3Ls ► How To Install 12c On Windows 10: https://youtu.be/vAUNgaYJSw0 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 89126 Manish Sharma
How to change Port number of Oracle Data Base
 
04:29
by kumar This video is going to tell you how to change your port no of oracle data base ,default port 8080.(oracle)
Views: 19194 brijesh kumar