Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ sqlplus connect to Oracle     - SSH configuration under Linux (Linux)

- Ubuntu / Fedora / CentOS system how to install Plex Media Server 0.9.9 (Linux)

- Linux disk quota-related instruction (Linux)

- Three minutes to teach you to easily grasp the grep command regular expression (Linux)

- Java Class file format parsing (Programming)

- How to download apk file from the Google Play store on Linux (Linux)

- CentOS6 install Redis (Database)

- CentOS 6.5 minimal installation and configuration VMware tools (Linux)

- Xtrabackup creates a slave node without downtime (Database)

- Linux, C programming language library file handling and preparation of Makefile (Programming)

- Disk partition MBR (Linux)

- MySQL thread cache thread_cache_size parameter optimization (Database)

- Linux operating system security management skills (Linux)

- Deployment Kubernetes manage Docker example cluster on Ubuntu (Server)

- Linux kernel update error, update-initramfs: failed Solution (Linux)

- MySQL high availability cluster fragmentation of deployment uses Cobar (Database)

- Merge Sort (Programming)

- Fragment Android developers learning to resolve (Programming)

- Learning how to teach safety system to prevent your own IP leakage (Linux)

- Java memory model subclasses (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:      
 
- Oracle procedure or function Empty Table (Database)
- Talk about Java EE Learning (Programming)
- Linux, modify the fstab file system can not start causing solve one case (Linux)
- IntelliJ IDEA common list of shortcuts (Linux)
- The SVN installation, configuration and start - up under Linux (CentOS 6.5) (Server)
- CentOS set up FTP server (Server)
- VSFTPD Security (Linux)
- Linux boot the system does not display a progress bar setting method (Linux)
- Lua and C ++ (Programming)
- RealVNC Server 5.2.3 Installation and Configuration In Fedora (Server)
- Android project using the command to create and install the package (Programming)
- Linux firewall settings instance (Linux)
- Root of AVL Tree- achieve balanced search trees AVL tree (Programming)
- ActionContext and ServletActionContext Summary (Programming)
- Linux kernel source code analysis (Linux)
- Install Websphere MB required system rpm package under Linux (Linux)
- To use yum install VLC under CentOS (Linux)
- JSON Introduction and Usage Summary (Programming)
- Customize the 404 error page Nginx (Server)
- Ubuntu 14.04 installed NVIDIA graphics driver (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.