Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ sqlplus connect to Oracle     - How to monitor network usage by nload in Linux (Linux)

- Talking about modern programming language syntax and standard library tightly bound phenomenon (Programming)

- NET Developers need to know some Linux commands (Linux)

- Shell for loop (Programming)

- CentOS boot image to achieve semi-automatic installation (Linux)

- JavaScript prototype and the prototype chain (Programming)

- A step by step teach have to install multi-node cluster configuration Hadoop (Server)

- How to track performance issues when using the Unity Game Development Android (Programming)

- QBit development of micro-services (Server)

- Java annotations entry automatically generates SQL statements (Programming)

- CentOS 6.6 compile and install phpMyAdmin configuration PostgreSQL9.4.1 (Database)

- LAN in Ubuntu shared folders to Windows (Linux)

- Linux System Getting Started Tutorial: How to Force Change your password at next logon Linux (Linux)

- Linux kernel VLAN study notes (Programming)

- The Linux OOM Terminator (Server)

- Oracle rebuild index script (Database)

- Windows 8.1 and Ubuntu 14.04 dual system uninstall Ubuntu Tutorial (Linux)

- Java inner classes (Programming)

- Batch download files using the explorer under Windows Server 2008 R2 (Server)

- Boot automatically remove Linux operating history records (Linux)

 
         
  sqlplus connect to Oracle
     
  Add Date : 2018-11-21      
         
       
         
  SQLPlus when connections are typically three ways

1. sqlplus / as sysdba

Operating system authentication, the database server does not need to start listener, the database server does not need to be available. For example, we want to start the database can be used this way to enter the sqlplus, then started by startup command.

2. sqlplus username / password

Connect the machine database listener process does not require a database server, but due to the need to authenticate the user name and password, and therefore require a database server in a usable state job.

3. sqlplus usernaem / password @ orcl

Through a network connection, which is required for the database server listener in a listening state. This time to establish a connection roughly as follows:

a. query sqlnet.ora, look at ways to resolve the name, the default is TNSNAME

b. query tnsnames.ora file, from the inside looking orcl records, and find the host name of the database server or IP, port and service_name

c. If the server listener process is not a problem, the process of establishing a connection with the listener.

d. According to a different server models such as the dedicated server mode or shared server mode, listener goes on to take action. The default is dedicated server mode, there is no problem if the client to connect to the database server process.

e. At this connection has been established, you can operate the database.
     
         
       
         
  More:      
 
- C ++ Learning Notes: references (Programming)
- Google open source TCP team repaired the Linux kernel TCP flaw (Linux)
- Shell script on the variables with double quotation marks grep small problem (Programming)
- Setting Derby as Linux / Windows running as a service from the start (Server)
- CoreCLR compiled in Linux CentOS (Linux)
- Differences Shell scripting languages and compiled languages (Programming)
- Lenovo Ultrabooks Ubuntu system can not open the wireless hardware switch solutions (Linux)
- Debian (Wheezy) Install Java environment / replace OpenJDK as the SUN JDK (Linux)
- Let your PHP 7 faster the Hugepage (Linux)
- Java class loading order (Programming)
- Servlet life cycle code examples (Programming)
- Dom4j change XML coding (Programming)
- Use backup-manager system backup on Linux (Linux)
- installation of Piwik under Ubuntu (Programming)
- impdp error ORA-39001, ORA-39000, ORA-31619 (Database)
- Oracle 11g to create a second instance on Linux (Database)
- How to install Linux on a MacBook Pro Retina (Linux)
- Ubuntu 14.10 users to install Audio Recorder 1.5.7 (Linux)
- Linux platform host to prevent hacking skills (Linux)
- Usage Linux device tree (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.