select command in oracle

(I) lsof application instance ① Find the program occupying the specified port: [root@temp ~]# lsof -i :80COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEhttpd 10278 root 3u IPv6 37812 0t0 TCP *:http (LISTEN)httpd 10280

Abstract: This article describes how to install the oracle9.2.0 database in the RedHat Linux9 environment. Keyword: oracle9i RedHat Linux9 Kernel Parameter environment variable Oracle817 is always used in the RedHat linux7.1 environment. Sort out

Oracle9i was released on Oracle Open World in October 2000, introducing many new features for Oracle databases, application servers, and development tools. Oracle9i is the industry's first complete and simple software infrastructure for a new

Oracle basic concepts and comparison with informix I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user

When importing data from IMP in Oracle, hybriddb for MySQL prompts that the character set is inconsistent. The imp import and exp export functions of Oracle are often used in the production environment for data migration. The character set is

1. Oracle startup and Shutdown1. In a single-host environmentTo start or shut down the Oracle system, you must first switch to the Oracle user, as shown below:Su-Oracle A. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr>

When the database needs to recover the media, in order to ensure that the database can smoothly perform the recovery process, restore the database to the current state. All we need to do is verify! What is verification? Of course, it is to verify

Summary : Description: Linux server operating system: CentOS 5.8 32-bit (note: Please separate partition/data for installation of Oracle database) Linux Server IP address: 192.168.21.150 Oracle database version: Linux_11gr2_database wind

Install Oracle 11g in CentOS 6.5 I recently started to learn how to use CentOS and make some records. References: Install Oracle 11g in Cent OS 6_5 (x86_64) I. Hardware requirements 1. Memory & swap Minimum: 1 GB of RAMRecommended: 2 GB of RAM or

The racle database system is a complex software system. Without understanding its internal structure principles and relationships, it is impossible to design and Compile High-Quality application software systems or manage a complex application