Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ sqlplus connect to Oracle     - DupeGuru- find and remove duplicate files (Linux)

- Linux system font color change (Linux)

- Java to achieve local fileCopy (Programming)

- Ubuntu users to install Gnome-Pie 0.6.5 (Linux)

- How to contribute code to the GNU Project (Linux)

- How to enhance the Nagios server security (Linux)

- Bootable ISO image using GRUB (Linux)

- Linux SU command security Suggestions (Linux)

- Traffic monitor Linux Python Version (Programming)

- C ++ 11 feature: decltype keywords (Programming)

- Linux environment Duplex (multi-machine) automatic mutual backup scheme (Linux)

- Android studio multi-channel ultra-compact version of the package (Programming)

- extundelete: the Linux-based open source data recovery tools (Linux)

- Ubuntu users to install voice switch instructs the applet (Linux)

- wget command Walkthrough (Linux)

- Some common regular expressions (Linux)

- Merge Sort (Programming)

- Introduction Linux namespace (Linux)

- Linux, security encryption to transfer files between machines (Linux)

- TCP network communication Java Programming (Programming)

 
         
  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:      
 
- IronPython and C # to interact (Programming)
- Oracle how to assess the true concurrent session (Database)
- Linux desktop system using the remote server in clear text ssh password (Server)
- Redmine Installation (Linux)
- Setting Hibernate connection MySQL database connection pool coding (Database)
- Oracle study notes view (Database)
- Linux System Getting Started Learning: Linux in the last command (Linux)
- How to Install Winusb in Ubuntu 14.04 (Linux)
- Java abstract class instantiation (Programming)
- Java threads in the life cycle (Programming)
- How to build a container cluster (Server)
- PL / SQL how to make the program every few seconds to insert a data (Database)
- RedHat Linux 7 build yum source server (Server)
- Comparison of sorting algorithms (Programming)
- Source MongoDB 3.2.1 installed on CentOS6.5 (Database)
- MySQL uses Federate engine mapping table to achieve operation of the local remote operation table (Database)
- EXP-00091: Exporting questionable statistics Processing Method (Database)
- How to use SVN to manage our source code (Server)
- MySQL Slave synchronization problem solving (Database)
- Git Advanced Tutorial (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.