Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ sqlplus connect to Oracle     - Linux System Getting Started Learning: modify environment variables in Linux PATH (Linux)

- Linux Getting Started tutorial: How to backup Linux systems (Linux)

- Java NIO1: I / O model overview (Programming)

- Python is not C (Programming)

- Python Flask environment to build (Linux)

- MySQL Online DDL tools of pt-online-schema-change (Database)

- To configure Samba to share files with Windows under CentOS (Linux)

- How to use the command line to obtain Freely RSS source on Linux (Linux)

- Hadoop 1 and 2.x installation notes (Server)

- Supervisor Installation and Configuration (Server)

- Linux system Passwd file detailed analysis (Linux)

- Spring Data JPA call a stored procedure examples (Programming)

- Installation on the way to the root source Ubuntu Server 14.04 LTS version Odoo8.0 (Server)

- Ubuntu Live CD by updating Grub resume boot the Boot Menu (Linux)

- Firewall Configuration Red Hat Enterprise Linux 4 (Linux)

- Java proxy mode (Programming)

- Oracle 12c R2 new feature dbca command to create a standby database (Database)

- Ubuntu 15.04 and CentOS 7 to deploy .NET, Mono and DNX (Server)

- Mounting kit under Fedora Linux (Linux)

- Using Java to build micro-services (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.
- PHP 7.0 Upgrade Notes (Linux)
- Linux server is how to do after the invasion (Linux)
- About the replication of JavaScript (Programming)
- How to merge two pictures in Cacti (Linux)
- Local port forwarding using iptables under linux (Server)
- How to install the NVIDIA 358.16 driver in Ubuntu 15.10,14.04 (Linux)
- Oracle Character Set Summary (Database)
- Linux firewall settings -DNS server articles (Server)
- Java regular expression syntax (Programming)
- Jigsaw project will solve the problem of Java JAR hell Mody (Programming)
- Timing task Crontab under Linux system (Linux)
- Heartbeat (v1, v2, pacemaker) cluster components Overview (Server)
- Oracle 10g in the unique and index problems (Database)
- How to modify the SQL Server auto-increment value and the corresponding solution (Database)
- SecureCRT in Python scripting study guide (Programming)
- Oracle Database asynchronous IO cause slow query response (Database)
- CentOS iptables firewall configuration (Linux)
- Linux dd command applies amplification SWAP partition (Linux)
- RPM package fabrication method (Linux)
- Mumble installation source VoIP application on Ubuntu (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.