Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ sqlplus connect to Oracle     - Use of the storage-level replication technology will quickly clone a ASM database to the target environment (Database)

- Generators and iterators in Python (Programming)

- CentOS6 5 source compiler installation Hadoop2.5.1 (Server)

- Linux partition command (Linux)

- Add local search to your Android app (Programming)

- ORA-38856: Unable instance UNNAMED_INSTANCE_2 (redo thread 2) marked enabled (Database)

- Fast Learning Clojure (Programming)

- Installation CD audio file extraction tool Flacon (Linux)

- Hibernate Search and Lucene quick introduction (Linux)

- Ubuntu installed Gimp 2.6.11 (stable version) with PPA (Linux)

- CentOS 6.5 set under Oracle 12c at startup (Database)

- Android Send HTTP POST requests (Programming)

- Installation and Configuration ISC DHCP server on Debian Linux (Server)

- MySQL High Availability plan several options (Database)

- Linux Mint 17 set up the Ruby environment (Linux)

- Linux disk and File System Concepts (Linux)

- LaTeX Getting Started Tutorial (Linux)

- LVS + Keepalived the DR mode (Server)

- Java static code analysis tool Infer (Programming)

- C # and JavaScript arrays to re-summary (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:      
 
- 25 Git Usage Tips (Linux)
- Github Getting Started Basic Course (Linux)
- Oracle table space create large files (Database)
- The difference between statement and preparedStatement of the jdbc (Database)
- PuTTY Xming achieve the X11 forwarding ssh (Server)
- Copy files between two Linux hosts (Linux)
- How to Install Foreman under Ubuntu (Server)
- Nginx + Tomcat static and dynamic load balancing and separation configuration essentials under Linux (Server)
- CentOS 6.4 Python 2.6 upgrade to 2.7 (Linux)
- Five programming fallacy (Programming)
- Linux environment MySQL master-slave synchronization (Database)
- XenServer Virtual Machine Installation --- first ISO image file storage expansion (Linux)
- pureftpd basis: Install, configure, implement, anonymous logon (Linux)
- Install FFmpeg compiling from source in Mac OS X environment (Linux)
- Linux environment has been running Tomcat how to deploy the new Tomcat (Server)
- CentOS 6.5 installation and deployment SVN 1.8.10 (Linux)
- How to install Linux Kernel 4.0 On CentOS 7 system (Linux)
- Ubuntu and derivatives installation Atom 0.104.0 (Linux)
- Ceph tuning --Journal and tcmalloc (Server)
- Linux system - The understanding cpu load (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.