Home
Search results “Tns path in oracle”
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 196065 Chris Ostrowski
confrigure tnsnames file on oracle 11g client
 
02:54
confrigure tnsnames file on oracle 11g client
Views: 14080 Jamaal Khan
The tnsnames ora file
 
03:57
#Oracle ##tnsnames Client Connectivity to Database Server Instance
Views: 8563 Hemant K Chitale
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: 3095 Junior Geek
1 FINDING TNSNAME FROM TNS ORA FILE
 
01:02
HERE IAM PROVIDING OBIEE10G VIDEOS FOR MORE DETAILS VISIT www.onlineexamsforu.org
Views: 2952 yugandar chandragiri
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora
 
06:22
pl sql developer - connect to oracle 12c database using pl 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 "pl sql developer - connect to oracle database using pl sql developer with tnsnames.ora" will show you how to configure tnsname.ora in pl sql developer for oracle database connection, create table in pl sql developer, insert data in pl sql developer, and select result in pl 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, pl sql developer connect to oracle 12c database using pl sql developer
Views: 26590 Junior Geek
#TNS Configuration in #D2k|SET Path In# Registry Edit|Connect Your D2k Application|
 
21:45
नमस्कार दोस्तों , इस विडियो मे मै आपलोगों को ये बताया हूँ की How to Set or Configure of TNS names in Oracle forms and report or Oracle D2k.how to set path in registry edit,how to Start or Stop Services,how to connect your application ,how to run application ,how to set password to run application automatically ,set password and form default, Please see full video and Learn. ====================================================================== About “Technical Aashique” मै अपने चैनल मे SQL,PL/SQL ,Oracle Database,Oracle Forms & Reports ,Online Earnings ,YouTube tips,और Software और Hardware से Related Video Upload करता हूँ । आप को मेरे चैनल पे ये सारे topics के विडियो मिल जाएंगे । तो आप मेरे चैनल के Playlist पे Visit करें और अपने मनपसंद टोपिक्स का विडियो देखे । If you want to be a good learner stay here and learn something Special. I want to say all of the viewers and visitors on my channel Please Subscribe my channel and Click on Notification bell icon. For more updates about SQL,PL/SQL,Oracle forms and Reports tutorials. For SQL Playlist click on link: https://www.youtube.com/watch?v=LdwMFu0E9jQ&list=PLis8Xc0Ehx1bPIVx8QgEVeTsMXM_K5oup For Oracle forms and reports Playlist: https://www.youtube.com/watch?v=JG7EmUUKgnU&list=PLis8Xc0Ehx1bagSFjdtYvOuh06-5ihz5Z Also see here: https://www.youtube.com/watch?v=-jnoel8gX7I&list=PLis8Xc0Ehx1YxiQK3tNCmPg4P9Z8trVNJ अगर आप हिन्दी मे कम्प्युटर पढ़ना चाहते हैं तो आप मेरे वैबसाइट पे visit कर सकते हैं। http://www.aashiquetechsolutions.com/ Excel Playlist: https://www.youtube.com/playlist?list=PLis8Xc0Ehx1b9pXsaiXvH9rP_Q3Td9iEH Oracle D2k Tutorials Link: https://www.youtube.com/playlist?list=PLis8Xc0Ehx1YxiQK3tNCmPg4P9Z8trVNJ Like , Comment & follow on Instagram : https://www.instagram.com/aashiquetechsolutions/
Views: 24 Technical Aashique
Oracle full table scans, direct path reads, object level checkpoints, ORA 8103s (old videos)
 
02:19:18
As the name says, in this hacking session I'll demo how full table scans (and full segment scans) work and related stuff too, like direct path read checkpoints and ORA-8103 errors.  It's an old video from 2011 so not with the best recording resolution, but should still be fun. As direct path reads go, some things have changed and should be clarified, perhaps the best explanation is here: https://blogs.oracle.com/smartscan-deep-dive/when-bloggers-get-it-wrong-part-1 https://blogs.oracle.com/smartscan-deep-dive/when-bloggers-get-it-wrong-part-2
Views: 839 Tanel Poder
How to create connection oracle toad to oracle 10g database
 
02:38
#oracletoad #toad #database israrengineer, israr engineer israr engineer video, israr engineer channel OC4J configuration issue || Unable to open java form | oc4j testmod https://www.youtube.com/watch?v=X3tr3UO0D_E How to install oracle 10g developer shuite. abnormal program termination https://www.youtube.com/watch?v=l0axgW6IM4M P2p Cycle in hindi https://www.youtube.com/watch?v=czH0vr8BcdU P2P Cycle AP To Gl in hindi #VID002 https://www.youtube.com/watch?v=DXZJE8WJYzQ How to create supplier in Oracle apps | create Vendor in oracle apps in hindi https://www.youtube.com/watch?v=-MBrqpVnhPY How to create supplier in Oracle apps | https://www.youtube.com/watch?v=-MBrqpVnhPY P2p cycle in Hindi | P2P cycle | procure to pay cycle with table joins in hindi https://www.youtube.com/watch?v=TZ-FYdk50k4 PL/SQL Procedure Report | PL/SQL Procedure Oracle Report in hindi https://www.youtube.com/watch?v=6ijV9HxfWJo How to install Oracle toad in Windows 7,8,10 https://www.youtube.com/watch?v=rMOcm3pXOWo How to install oracle 10g developer suite | create connection for toad with TNS https://www.youtube.com/watch?v=YjRpXQUXRg4 How to create connection oracle toad to oracle 10g database https://www.youtube.com/watch?v=smKCBuND7EM How to install bi publisher in MS office | bi publisher https://www.youtube.com/watch?v=t3sf7Z0zRKY p2p cycle in hindi | P2P Cycle with joins | Procure to pay cycle in oracle apps https://www.youtube.com/watch?v=uyQC42WHGbs p2p cylce | Procure to pay cycle | p2p cycle step by step https://www.youtube.com/watch?v=7nm-7QwnVYw Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism,comment, news reporting, teaching, scholarship, and research, any course. Fair use is a use permittedby copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favour of fair use Please Like, Share, Subscrbe :- Subscribe Youtube Channel https://www.youtube.com/channel/UCRH_t1BcoMZO_CtrTEq803w Israr engineer Blog https://israrengineer.blogspot.com/ Instagram : https://www.instagram.com/israr.engineer/ Email id:- [email protected] Thanks & Regards Israr Engineer TNS Path C:\DevSuiteHome_1\NETWORK\ADMIN
Views: 168 Israr Oracle
Navicat to Oracle error ORA-12737 or TNS solved
 
04:33
Hi, lets solve navicat to oracle connections error ORA-12737 ERROR or TNS ERROR You have to update instantclient_10_2 folder with dll files. Default folder location: C:\Program Files\PremiumSoft\Navicat Premium 12\instantclient_10_2 Update download from http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html and choose your download x64 or 32bit: 1. download Instant Client Package - Basic (1st one :D) 2. unzip, copy whole instantclient_12_2 and past it to C:\Program Files\PremiumSoft\Navicat Premium 12 3. download Instant Client Package - ODBC 4. unzip, open unziped folder ...\instantclient-odbc-windows.x64-12.2.0.1.0-2\instantclient_12_2, select all, copy and paste to C:\Program Files\PremiumSoft\Navicat Premium 12\instantclient_12_2 (((directory from step 2 ))) 5. run odbc_install.exe 6. open navicat 7. go to Tools|Options|Enviroment and set OCI library (oci.dll) to: C:\Program Files\PremiumSoft\Navicat Premium 12\instantclient_12_2\oci.dll 8. restart navicat If TNS error persits use this directory structure for update C:\oracle\instantclient_12_2\network\admin also change this in step 7. Directories network and admin are empty. have a fun :D
Views: 766 vlad ypsilon
ORA-12560: TNS:Protocol Adapter Error | Oracle | Oracle Sql Developer | Oracle 12c | Oracle 18c
 
02:49
ORA-12560: TNS:Protocol Adapter Error | Oracle | Oracle Sql Developer | Oracle 12c | Oracle 18c ----------------------------------------------------------------------------------------------- protocol adapter error, ora-12560, error ora-12560, error 12560, oracle error, tns protocol error, how to solve tns protocol adapter error of oracle database, database error tns, oracle 10g adapter error, oracle10g, oracle11g, protocol error, adapter error, sql developer, tns protocol adapter error of oracle database, oracle 10g protocol adapter error, oracle oracle arena my oracle support oracle virtualbox oracle stock yes no oracle oracle sql developer oracle definition oracle meaning oracle careers oracle apex oracle jdk oracle 11g oracle vm virtualbox extension pack oracle linux oracle jobs oracle vm oracle reading oracle client oracle download oracle to_date oracle certification lbcc oracle oracle erp oracle ebs oracal 651 oracle decode oracle substr oracle sql developer download oracle 12c oracle university oracle metalink oracle nvl oracle ceo oracle open world oracle of delphi oracle rac create table oracle oracle database download oracle login oracle case alter table add column oracle oracle date format oracle netsuite oracle layoffs oracle instr insert into oracle oracle listagg oracle merge oracle rownum oracle trunc Please Subscribe My Channel
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: 1469 itasworkshop
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: 50282 jbleistein11
How to Set ORACLE_HOME & ORACLE_SID on Windows Server
 
07:19
How to Set ORACLE_HOME & ORACLE_SID on Windows Server ==================================================== C: Set ORACLE_HOME=C:\Oracle\product\11.2.0 Set ORACLE_HOME=DBNAME Set PATH=C:\Oracle\product\11.2.0\bin ================================================= 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: 8585 ANKUSH THAVALI
Tips on Protection from Oracle TNS Poisoning Zero Day Vulnerability
 
36:47
Protect Your Oracle Databases from the Oracle TNS Poisoning. With Josh Shaul, CTO at Application Security. More info at http://www.appsecinc.com
Views: 1710 appsecinc
Parameter files in Oracle- Pfile & SPFile
 
07:50
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] Please visit my official website for oracle database training and hadoop blog. https://www.orcldata.com/ Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 parameter file in oracle 11g what is parameter file in oracle parameter file definition pfile parameters in oracle 11g list of initialization parameters in oracle 11g static and dynamic parameters in oracle init.ora file location in oracle 12c spfile in oracle
Views: 1442 ANKUSH THAVALI
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: 348840 TechLair
Install oracle 11g database / weblogic / forms and reports without errors
 
32:52
In this tutorial I'll install: - Oracle database 11g r2. - Oracle weblogic server 10.3.6 - Oracle forms and reports 11.1.2.2 And how to avoid common errors like: - INS-13001environment does not meet minimum requirements. - WFMLRSVCApp.ear file missing during Installation - couldn't find jvm.cfg. - Unable to find java virtual machine. - ora-28000 – the account is locked. - unlock user hr. - SQL developer JDK path - Java_home variable - Environment variables path - Oracle 11g installation stuck at step 14 - Oracle forms and reports step creating domain failed. - Oracle forms and reports step 15 stuck. - Oracle forms and reports setup hang. - Oracle forms and internet explorer – crash - Oracle forms internet explorer blank page. - Oracle forms web browser blank. - Oracle 11g installation problems. - Weblogic for windows 64 – Generic. - oracle database 11g missing file. - em.ear file not found. Fusion middleware Sqldeveloper port Tnsping - Oracle forms checking operating system certification. - Tnsnames.ora - My pc become slow after install oracle ......................................­.................... لو عندك اى سؤال خش على الجروب : https://www.facebook.com/groups/oracle.askgad ......................................­.................... لمتابعة كل ماهو جديد من خلال صفحتنا https://www.facebook.com/askgad
Views: 27255 Ask Gad
Alert log file in Oracle
 
07:34
Check Alert File Location in Oracle ================================================= DB is upp & Running ================== show parameter dump; select value from v$parameter where name='background_dump_dest'; DB is Down ===================================== find / -name alert_newdb.log 2 )/dev/null
Views: 4129 ANKUSH THAVALI
Configurar listener y oracle sqldeveloper
 
07:15
Configurar listener y oracle sqldeveloper
Views: 502 Gabriel_ITD
Getting rid of  tnsnames.ora to connect to Oracle database.
 
10:10
How to connect to Oracle database without using tnsnames.ora. In this video we will try connecting to Toad for Oracle, SQL Plus for windows and PLSQL Developer without using tnsnames.ora file using connection string instead.
Views: 4011 Subhroneel Ganguly
How to Fix ERROR:ORA-12560: TNS:protocol adapter error
 
06:30
How to Fix ERROR:ORA-12560: TNS:protocol adapter error Any Problem - Comment Below https://maheshkarandeprojects.wordpress.com/
Views: 4596 Mahesh Karande
How to set bash profile for ORACLE HOME environment
 
02:26
Bash profile for Oracle Home
Views: 5962 oracleora
ORACLE instant client installation for Windows 7 x64
 
05:02
Latest version: 18.5.0.0.0 https://www.oracle.com/technetwork/topics/winsoft-085727.html Basic Package ODBC Package Do the same like on video For Windows 10: you need to install Visual C++ Redistributable Packages for Visual Studio 2013 (x84) https://www.microsoft.com/en-us/download/details.aspx?id=40784
Views: 138915 Igor Tereshchenko
How to fix ORA-12560 Error in Oracle DBMS. TNS: Protocol Adapter Error
 
02:59
How to fix ORA-12560 Error in Oracle. TNS: Protocol Adapter Error. Oracle dbms main 12560 error ko kaise solve kre. https://www.facebook.com/R0212B https://twitter.com/RGHU021294
Views: 204 Raghu Aryan
How to Solutions ORA 12541 TNS no listener (AS Tuhin)
 
02:55
How to Solutions ORA 12541 TNS no listener (AS Tuhin)
Views: 1045 JAJABAR
How to Reset Oracle Password: Oracle 12C SYS User using Password File
 
11:18
if you forgot sys user password in oracle 12c. check the path where oracle is install using command in command prompt: tnsping orcl after this move to the file file where orapwd file is store, delete check the name of existing password file and remember that name, delete or rename the existing password file. write the following command for creation of password file. orapwd file=name-of-file password=password
Views: 11572 Data Science Center
How to resolve the ora 12154 error
 
07:03
In this tutorial you will learn how to resolve the ora 12145 error.
Views: 116915 DBA Pro
Oracle 11g - Listener Configuration
 
05:17
In this video i have shown the configuration of listener in oracle 11g . Listener is created at the time of installation so we only need to reconfigure it. Path to listener.ora and tnsnames.ora file: the path where installation data is store it usually start with \oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN in this above path u will find both this file.
Views: 18 HashTech Coders
how to configure and connect oracle 12c database for the first time
 
06:31
how to configure and connect oracle 12c database for the first time, add pluggable database services in tnsname.ora file, connect sys as sysdba, alter session set container = pdborcl, startup open; alter user name_of_user identified by password account unlock;
Views: 7090 Data Science Center
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: 14127 srikanth
Oracle Database tutorials 2:How To install SQL Developer on windows 7
 
06:15
How To Setup and install SQL Developer on windows 7 This SQL tutorial and Oracle database 11g tutorial for beginners will show how to Setup and install SQL Developer. YouTube Video on How to create database http://bit.ly/create-database-using-DBCA Oracle BLOG on SQL Developer http://goo.gl/ej4ku7 Direct Link To Download SQL Developer http://goo.gl/hfsjuY Link for downloading Java JDK http://goo.gl/kZ95rl Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Wishlist: http://bit.ly/wishlist-amazon 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.
Views: 461425 Manish Sharma
How to reset java exe path on sql developer
 
08:12
In this tutorial you will learn how to reset the java.exe path in sql developer.
Views: 35437 DBA Pro
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 187605 Abbasi Asif
oracle location of alert log file
 
01:11
http://dbacatalog.blogspot.com
Views: 1990 dbacatalog
Top 3 way | How to find Alert log file location in ORACLE 10g | ORACLE 11g
 
03:18
Hello friends in this video i'm going to show you how to find alert log file location if you are new on server, this video is useful to all of you, if you like my video so please subscribe my channel and like & share my video.
Views: 2017 OCP Technology
Connect to Oracle 12c DB in the same machine with Oracle express and E business suit
 
08:06
in this video you will see how to connect to Oracle 12c users like sys and hr ... in the same machine with oracle express (Oracle apex) and oracle e business suite (Oracle Apps) ... by sql plus , sql developer and toad ..... and you can use this way to add any other database you need and this is what I did in the video =================================== 1- The go to the file tnsnames in the path (D:\app\gaid2\product\12.1.0\dbhome_1\NETWORK\ADMIN) And this part (D:\app\gaid2) different from your one this is which you put you database in while installation 2- Open this file you will find this code ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 3- Copy this and past it blew but make a little change like this PDBORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) ) 4- Then save and take this 2 blocks of code copy and go to this file tnsnames in the path in the partition where you installed your oracle express DB Which in my case (C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN) 5- Open this file and past the 2 blocks of code 6- Then save 7- Then Open sql plus from start menu 8- Write username : sys as sysdba 9- The write the password which you entered while installation of Oracle 12c DB 10- The write ALTER SESSION SET CONTAINER = PDBORCL; Then enter 11- Then write SHOW CON_NAME; Then enter You will find that the con_name became pdborcl 12- Then run this statement to see if the status of pdborcl open or not SELECT NAME , OPEN_MODE FROM V$PDBS; If it in MOUNTED status then we need to open it by this statement ALTER PLUGGABLE DATABASE OPEN 13- Then we need to unlock user hr by one of this statements ALTER USER HR INDENTIFIED BY HR ACCOUNT UNLOCK; ALTER USER HR ACCOUNT UNLOCK; 14- Then go to toad and sql developer to check like I do. Thanks Ahmed Gaid Please subscribe :)
Views: 36 Ahmed Gaid
oracle_home.avi
 
01:12
Views: 5924 life
how to create directory in oracle 12c, 11g
 
02:52
Use the CREATE DIRECTORY statement to create a directory object. A directory object specifies an alias for a directory on the server file system where external binary file LOBs and external table data are located. You can use directory names when referring to BFILEs in your PL/SQL code and OCI calls, rather than hard coding the operating system path name, for management flexibility. All directories are created in a single namespace and are not owned by an individual schema. You can secure access to the BFILEs stored within the directory structure by granting object privileges on the directories to specific users. You must have CREATE ANY DIRECTORY system privilege to create directories. When you create a directory, you are automatically granted the READ and WRITE object privileges on the directory, and you can grant these privileges to other users and roles. The DBA can also grant these privileges to other users and roles. WRITE privileges on a directory are useful in connection with external tables. They let the grantee determine whether the external table agent can write a log file or a bad file to the directory. For file storage, you must also create a corresponding operating system directory, an ASM disk group, or a directory within an ASM disk group. Your system or database administrator must ensure that the operating system directory has the correct read and write permissions for Oracle Database processes. Privileges granted for the directory are created independently of the permissions defined for the operating system directory, and the two may or may not correspond exactly. For example, an error occurs if sample user hr is granted READ privilege on the directory object but the corresponding operating system directory does not have READ permission defined for Oracle Database processes. ---------------------------------------------------------------------------- Default directory is DATA_PUMP_DIR.Below command is to get directory name and directory path. SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR' DIRECTORY_NAME DIRECTORY_PATH --------------- ------------------------------------------------------- DATA_PUMP_DIR /u01/app/mohammad75/product/12.1.0/dbhome_1/rdbms/log/
Views: 2439 Oracle DBA World
windows could not start the oracledbconsole on local computer error code 2
 
10:16
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: 3686 Dhamaliya dot Net
sql developer java error
 
01:53
This Error mainly occur because of 64-bit java Sql developer does not support java 64-bit install 32-bit java and browse the location to it and Run
Views: 5031 Anilkumar M
How to configure / identify Oracle client on Windows - Demo1
 
02:43
How to configure / identify Oracle client installation on Windows. This is Demo1 from the presentation http://www.slideshare.net/KirillLoifman/from-my-pc-to-oracle-remote-database. http://www.dadbm.com
Views: 2886 DaDBm
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: 21684 Leen's Tech
Configuración de Oracle para instalación de DataBase(oracle)
 
26:46
-- Modificar hosts -- /etc/hosts -- Librerías -- # yum install oracle-rdbms-server-11gR2-preinstall -- Parámetros de kernel -- /sbin/sysctl -a | grep param-name --Agregar parámetros -- /etc/sysctl.conf -- Para detectar los cambio en el kernel -- /sbin/sysctl -p -- Agregar a este archivo -- /etc/security/limits.conf oracle soft nproc 16384 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 oracle soft stack 10240 -- Parámetros en "/etc/security/limits.d/90-nproc.conf" -- * - nproc 16384 -- Parámetros en "/etc/selinux/config" -- SELINUX=permissive -- Directorios -- mkdir -p /u01/app/oracle/product/11.2.0/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01 -- Variable en .bash_profile -- # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=tuNombre.localdomain; export ORACLE_HOSTNAME ORACLE_UNQNAME=nombreDeBaseDeDatos; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=nombreDeBaseDeDatos; export ORACLE_SID PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH Facebook: https://www.facebook.com/telumsoft Twitter: https://twitter.com/telumsoft Pagina: http://www.telumsoft.com/
Views: 841 TelumSoft
how to connect with oracle database 12c|bash_profile|first time
 
02:15
In this video we are going to see how to connect with the oracle database using oracle user for first time. ------------------------------------------------------------------------------------------------------- export PATH umask 022 PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib ORACLE_BASE=/u01/app/oracle ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1 ORACLE_SID=orcl2 PATH=$ORACLE_HOME/bin:$PATH export PATH LD_LIBRARY_PATH export ORACLE_BASE ORACLE_HOME ORACLE_SID
Views: 81 EBS STUDIO ORACLE