how to use sqlplus

In linux, when oracle deletes a tablespace, an error occurs. Due to insufficient tablespace capacity, the tablespace capacity needs to be increased. Therefore, a new tablespace is created in the original tablespace and added to the original

Solution to oracle initialization or shutdown in SS error in oracle Database 1. First, the cause of the problem, this error occurs when a file under oracle \ oradata \ oradb is deleted by mistake. 2. symptom: SQL * Plus cannot be connected, the

Oracle instant client is installed in Linux on the PL/SQL Dev Virtual Machine and Oracle is installed. Since PL/SQL Developer is used in Windows physical machines to connect to Oracle on the virtual machine, but I don't want to reinstall Oracle on

Oracle12c installation, connection, and usage 1. oracle12c Installation See the following link: Http://www.bkjia.com/database/201503/380453.html 2. A ORA-12514 error occurred while connecting to the database. For more information about the solution,

Install the Oracle11g server in LinuxInstallation environment Linux Server: SuSe10 sp2 64-bit Oracle Server: Oracle11gR2 64-bitSystem Requirements Requirements for installing Oracle in Linux System Requirements Description

With the advent of ArcGIS10.1, especially after the default direct connection to ArcSDE10.1, a requirement for direct connection is to install the database client software. For example, we use ArcGISServer10.1 to connect to the data source of ArcSDE1

Oracle BASICS (4) pl/SQL PL/SQL is also a program Language called Procedural Language/SQL ). PL/SQL is an extension of SQL statements in Oracle databases. The features of the programming language are added to the use of common SQL statements.

In Oracle11GR2RAC, modifying the location of the DATABASEspfile file is not the original $ ORACLE_HOMEdbsinitORACLE_SID.ora file. If we modify this file manually, it will still take effect when sqlplus is used to manually start the database, however,

Oracle entry-level knowledge I.Oracle Basics 1. When should I use the Oracle database? SQL SERVER claims to be a million-level data (data in one table), but it actually does more than 0.2 million pieces of data Oracle is used for over 0.2 million

Environment: Oracle11gR2 + PLSQLDeveloper + SQLPlus problem: Oracle master service and listener service has been started, use SQLPlus can be connected normally, use PLSQLDeveloper connection reported error: ORA-12514: TNS: the listener cannot

I wrote a blog titled "error in logging on to new users using sqlplusassysdba. csdn. netbisalarticledetails9285087 today I happened to see a recommended post "create a user (non-oracle). Operating System verification is not available if dba is not

Oracle sqlplus login. SQL settings, sqlpluslogin. SQL Sqlplus automatically runs two scripts at startup: glogin. SQL and login. SQL. The execution order is 1. The glogin. SQL file is searched for and executed in the $ ORACLE_HOME/sqlplus/admin path

1. Download the necessary resource package and download the installation package from the official Oracle website. Select Version10.1.0.5. Www. oracle. comtechnetworktopics 1. Download the necessary resource package from the official Oracle website

After installing oracle11g in VMware7.14, sqlplus cannot be started. I searched the internet. It is estimated that the environment variable is not set. Current oracle Installation After installing oracle 11 GB in VMware 7.14, it was found that

LinuxOracle9i maintenance personnel reflect that the database cannot be connected. The phenomenon is: tnsping can be connected, but sqlplus cannot be connected. If no error is reported, it is always on there. Linux Oracle 9i maintenance personnel

After the database is created, because the sid of the two databases is different, the default sid is used by default in the Oracle configuration file during system installation, that is, the started database is After the database is created, because

When using sqlplus to execute an SQL script, parameters are often passed to the script. Similar to passing parameters in shell scripts, we can also pass parameters to SQL scripts. When using sqlplus to execute an SQL script, parameters are often

Resolved an error reporting ORA-01034 and ORA-27101 when connecting Oracle11g Resolving ORA-01034 and ORA-27101 errors when connecting to Oracle 11g My local database version installed is Oracle 11G R2, when using plsql connection, the

1. Common ports opened for NMAP scanning. nmap4.9 supports oracle tns detection to conveniently know the oracle version information.2. Find the sid information. You can access isqlplus and log on to the account dbsnmp/. Here, the isqlplus design in

Recently, there have been issues with access to sysdate return error times in some RAC environments, which often occur when database links are created through listener, and in most cases are related to time zone settings. In this article we will