Oracle

After the IP address of the oracle server is changed, the following error is reported when the listener is started after the IP address of the oracle server is changed: TNS-12542: TNS: address already in use TNS-12560: TNS: protocol adapter error

The installation is oracle9i, and the platform is 2000 windows. You can use SQL plus, but PL/SQL developer 6.0, Login error: ora-12541 TNS no listener. It is useless to re-add it in the Listener Configuration. Start OracleOraHome90TNSListener

The cold backup data must be that the database is not in the open state. The detailed process is shown in the following steps: ◆ (1): Shut down the database: shutdown immediate; ◆ (2): copy all files under the oradata directory, including data

Software environment: Operating System: Windows 2000 Advanced Server. Database: Oracle 9.0.1.1.1 Enterprise Edition. Recently, when Browsing BBS, we often see "in a hurry! How to start OMS ?" To address these problems, I want to share some of my

Example of creating and using oracle Stored Procedure 1. Create a stored procedureCreate or replace package pk_1 as // statement for creating a packageTYPE cur is ref cursor; // declare a pointerProcedure p1 (cr out cur );End; / Create or replace

Apart from significant technical differences between SQL Server and Oracle databases, there are also significant differences in implementation costs. I will share some of my views on this topic and hope to communicate with you. I. Oracle is

The methods for deleting all objects under an Oracle user may not be available to everyone. The following describes two common methods for deleting all objects under an Oracle user, we hope this will help you learn how to delete Oracle users.

Problem description: ORA-01658: unable to create INITIAL extent for segmnet in tablespace DATA01 Cause: Data cannot be inserted because the tablespace DATA01 space is insufficient. Solution: Redefinition of the tablespace size:Alter tablespace

Batch deletion of massive data is usually complicated and slow, and there are many methods, but the general concept is: Batch deletion and successive submission. The following is my deletion process. My data tables can be deleted through the primary

ORA-01403: no data found solution twoSolution 1: add an exception to handle the exception Exception when no_data_found then ....   Solution 2: Change the select statement, for example: Select count (*) field into var from table where .... Add a

Any database may have certain security risks during its long-term use. For database administrators, a complete set of database backup and recovery mechanisms should not only be intended for the secure operation of computer operating systems. When

3.6 Wordlist attributes The wordlist attribute of Oracle full-text search is used to set fuzzy queries and root queries. The wordlist attribute also supports For subqueries and prefix queries, the oracle wordlist attribute is only basic_wordlist

Flash back is the biggest new feature of oracle10g. Most of the flash back content has been sorted out before, including flash back database, flash back Delete table, delete table, and Flash back version query, this topic describes how to ensure the

Case 1 of Oracle online Log Recovery: it is a good solution to the loss of a single member in a multi-path log. You only need to copy the intact online log to the bad log. Case 2: All members of non-current online logs lose the simulated environment:

"The cost of configuring the query optimizer is expensive, but it is worth the effort ." (Note 1) In fact, I have seen many sites that underestimate the importance of good configuration. Sometimes, I even had a heated discussion with some people who

Common Oracle script-uninstall Grid Control [Plain] #! /Bin/bash #0. stop some service su-oracle-c "\ $ AGENT_HOME/bin/emctl stop agent" su-oracle-c "\ $ OMS_HOME/bin/emctl stop oms" #1. delete user oracle's content echo "" echo "delete user oracle'

64 win7 + 64 Oracle + 32plsql installation 1) install Oracle 11g 64-bit 2) install 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0) download instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not download the wrong version.

How to cache tables in oracle to memory because some static data tables are frequently accessed in the database, you can consider caching these tables with a small amount of data to the memory. There are two methods: for example, cache the fisher

ORACLE 11g rac Listener Configuration (instance sharing) after a user RAC installed on QQ last two days, how to configure the listener? Below I will share an instance Environment Information cat /etc/hosts192.168.1.11 racdb1 192.168.2.2

The performance problem of querying the maximum and minimum values of a column in a single table is that in oracle 10 Gb, there is an SQL statement for querying a single table. It does not have a where clause, but simply calculates the maximum and