Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ sqlplus connect to Oracle     - Comparison of one-time transaction and CTE insert data (Database)

- Help you make Git Bisect (Linux)

- Linux Network Programming --TCP and UDP datagram type Explanation (Programming)

- Cross server / client backup command: rsync use (Server)

- Using Java program determines whether it is a leap year (Programming)

- Linux beginners should know 12 commands (Linux)

- Use Epoll develop high-performance application server on Linux (Server)

- Getting Started with Linux: Learn how to install and access CentOS 7 Remote Desktop on a VPS (Server)

- MySQL 5.5 on master-slave copy filter (Database)

- About enhanced Linux / Unix server system security program (Linux)

- Simple to use multi-threaded programming under Linux mutex and condition variable (Programming)

- Use value type build better applications Swift (Programming)

- CentOS 7 Configure logging (VirtualBox) (Linux)

- Ten best plug surge Emacs Productivity (Linux)

- On the design of Oracle database backup (Database)

- MySQL concat function is SQL injection (Linux)

- Copy files between two Linux hosts (Linux)

- CentOS 6.6 installation certification system based on the ftp service (Server)

- Usage sed some of the parameters (Linux)

- Machine Learning: Classification of the curse of dimensionality (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.
- Oracle Bug caused by the collection of AWR Snapshot fault (Database)
- Install apr support for Tomcat on Linux (Server)
- Java Adapter Mode (Programming)
- Haproxy multi-domain certificate HTTPS (Server)
- Install Apache streaming media services on CentOS 6.4 (Server)
- Rman Oracle database backup and recovery plan (Database)
- Linux Telnet access Windows 7 configuration procedure (Linux)
- List Leaves (Programming)
- Select helps secure the system network management tools (Linux)
- Let CentOS6 yum upgrade to support more source rpm package (Linux)
- How to back up Debian system backupninja (Linux)
- Oracle create a temporary table space group (Database)
- MongoDB 3.2 to upgrade from 3.0.7 (Database)
- Slow update statement Performance Analysis (Database)
- Using 30 seconds to write a detailed analysis of garbage removal system (Linux)
- Ansible module Know (Linux)
- Red Hat Linux mount U disk (Linux)
- Use regular expressions to check whether the input box to enter a URL (Programming)
- How to install Nginx on FreeBSD 10.2 as an Apache reverse proxy (Server)
- Linux Shell Scripting multithreading (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.