Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ sqlplus connect to Oracle     - Linux regex sed detailing (Linux)

- Getting Started with Linux system to learn: how to install the kernel headers on Linux (Linux)

- nginx.conf Optimization (Server)

- CentOS 6.4 of cron scheduled task configuration (Linux)

- Ubuntu deployed under regular tasks with crontab (Linux)

- Ubuntu 14.04 Boot Repair (Linux)

- When Linux virtual machine to another copy of the operating system, a static IP NAT mode Invalid (Linux)

- Ubuntu How to install and upgrade Linux Kernel 3.15 (Linux)

- Linux Getting Started tutorial: Experience Xen Virtual Machine chapter (Linux)

- numpy and SciPy installation under Python for scientific computing package (Linux)

- Import and export myloader accelerate mydumper (Database)

- 12 novice Linux command must learn (Linux)

- iostat command Detailed (Linux)

- Embedded Linux to solve the problem in the time zone (Linux)

- View and modify Linux machine name (Linux)

- Linux Mint brightness adjustment --xrandr command learning (Linux)

- To install Samba server on CentOS 6.6 (Server)

- How to Install Focuswriter 1.4.5 (Linux)

- Oracle PLS-00231 error analysis (Database)

- Shell script to delete empty folders recursively (Linux)

 
         
  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:      
 
- Linux System Getting Started Tutorial: How to find the maximum memory your system supports (Linux)
- Linux command Detailed chpasswd bulk edit user password (Linux)
- Oracle RMAN backups of the control file backup (Database)
- A detailed introduction to the Hadoop ecosystem (Server)
- Package the Python script file into an executable file (Programming)
- About Python default character set (Linux)
- MySQL Tutorial: About checkpoint mechanism (Database)
- iTerm - let your command line can also be colorful (Linux)
- Docker knowledge base (Server)
- Ubuntu uses the / etc / profile file to configure the JAVA environment variable (Linux)
- Let's Encrypt with semiautomatic into Nginx configuration https (Server)
- JavaScript basic types and type conversion (Programming)
- Configure the Linux kernel and use iptables to do port mapping (Linux)
- Use LVM partition on Ubuntu and easily adjust the snapshot (Linux)
- MySQL to recover the data through binlog (Database)
- Ubuntu 14.04 Nvidia proprietary drivers for install two graphic cards (Linux)
- Subquery Oracle study notes (Database)
- Ubuntu PPA install SMPlayer 14.9 (Linux)
- How SSHfs mount a remote file system on Linux (Linux)
- Ubuntu install Eclipse for C / C ++ and related configuration (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.