Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ sqlplus connect to Oracle     - Compile and install LNMP under CentOS 6.5 (Server)

- Adjustment expand VMDK format VirtualBox disk space (Linux)

- KVM add virtual disks (Linux)

- How to update the ISPConfig 3 SSL Certificates (Server)

- MySQL remote connection settings (Database)

- Fedora 20 Installation and Configuration (Linux)

- Redhat 7 can only be read after installation Samba service catalog approach could not be written (Server)

- Install Websphere MB required system rpm package under Linux (Linux)

- Django url () function Detailed (Programming)

- Tmux create the perfect terminal management tool under CentOS (Linux)

- Simple steps allows you to build a more secure Linux server (Linux)

- Install MATE desktop environment adjustment tools Mate Tweak 3.3.6 (Linux)

- Java annotations entry automatically generates SQL statements (Programming)

- Security: set limits on password (Linux)

- Installation and configuration of phpMyAdmin under CentOS (Database)

- How to view the Linux QPS (Linux)

- How to prevent page five invisible killer (Linux)

- MongoDB Study Notes (1) - Install MongoDB on Windows systems (Database)

- Ubuntu 14.04 Install WordPress on Nginx (Server)

- Getting Started with Linux: CentOS7 Install Mono with the yum command (Server)

 
         
  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:      
 
- Nonstandard IMP-00010 error processing one case (Database)
- Through the source code to install MySQL 5.6.26 under CentOS6 (Database)
- How to choose the first programming language based on the life you want (Programming)
- findmnt- Looking mounted file system (Linux)
- Linux operating system security management skills (Linux)
- Introduction and MongoDB CRUD (Database)
- There are three ways to run a Linux operating system from a USB stick (Linux)
- Linux directory configuration (Linux)
- Creating and extracting archives 11 tar command examples in Linux (Linux)
- ARM platform compiler installation Golang (Linux)
- Ubuntu arm-none-eabi-gcc compiler treated with STM32F10x (Linux)
- Linux dynamic libraries and Guide (Programming)
- Based on Google Cloud Storage Mirroring open Maven Central Repository (Server)
- CentOS install pip (Linux)
- MySQL high availability cluster fragmentation of deployment uses Cobar (Database)
- Vagrant build LNMP environment (Server)
- printf PHP string operations () built-in function usage (Programming)
- Linux performance optimization tools perf top (Linux)
- RHEL7.0 configuration CD-ROM to the local YUM (Linux)
- Based Corosync + Pacemaker + DRBD + LNMP Web server to achieve high availability cluster (Server)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.