Oracle

  Enhance Oracle Security 1. Prohibit sys from bypassing Password Authentication (Conflicts with Solaris clusters, use with caution) 1. CD/export/home/Oracle/orahome1/Network/admin/ If you do not know the installation path of Oracle, you

A ORA-01034: Oracle not available Larry! Help ORA-01034: Oracle not availableAfter oracle is installed and started, use sqlplus "/As sysdba" to log on. If you run any SELECT statement, an error occurs:Select * From dictionary*Error at line 1:A ORA-

Relationship between process, connection, and session Process: divided into user process, server process, and background process.The user process is a process in the client.Processes created with user process. For background processConnect

1 redo. LogIs a relatively large binary file. Stores the database operation records that the user executes. It can be used when the database suffers an abnormal power failure.RedologThere must be at least two groups for data recovery.  

Requirement. After one operation (Review operation), insert the two fields in Table A that meet the conditions into Table B in batches. When inserting these two fields, you also need to use a function to automatically generate an ID and a fixed

There is a need: Update a record in Table A. If a record is found and updated, write a record to table B. It seems troublesome to write an SQL statement. A small process is as follows: BeginUpdate a xxxx;If (SQL % rowcount 0) thenInsert into

Compared with Oracle 9, Oracle 10 Gb has changed a lot and is not suitable for use at the beginning. In use, enterprise managemer needs to be opened through a browser. Many management functions require host identity authentication. At first I want

How to repeat table structures and table data in Oracle 1. Copy the table structure and data: Create Table table_name_new as select * From table_name_old   2. copy only the table structure: Create Table table_name_new as select * From

1. log on with an oracle user If you want to install it again, you 'd better back up the data first. The script includes the user's login script, the script for automatic database startup and shutdown, and the script for automatic listener

Today, I plan to enable the Database Control for Oracle Database 11 GB and find that the database is not installed initially: [Oracle @ test126 ~] $ Emctl startEm configuration issue./opt/Oracle/product/11.1.0/test126.hurray.com.cn _ Dodd not found.

Http://doc.linuxpk.com/1198.html     An instance is the name used to manage the memory structure of relevant databases (consisting of SGA, PGA, server processes, user processes, and background processes) A database is a file (data file, log file,

Database development or management personnel often need to create a large amount of test data, and tens of thousands of data records are required. If one data entry is required, it will waste a lot of time, this article describes how to quickly

This section describes the architecture of oracle. Oracle Systems mainly include instance instances and database databases. Instance: it can be divided into PGA (process globe area) and SGA (system globe area ). PGA is divided into user process and

1. Determine the database Sid and db_nameSID = 'hsj'Db_name = 'hsj'2. Set the environment variable envOracle_base =/u01/APPORACLE_HOME = $ oracle_base/OracleOracle_sid = hsjPath = $ oracle_hoem/bin: $ path;LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $

Initialize related parameters job_queue_processes Alter system set job_queue_processes = 39 scope = spfile; // The maximum value cannot exceed 1000; job_queue_interval = 10 // The refresh frequency of the scheduled job is measured in

My computer suddenly crashes and I have to reinstall the system. However, my oracle is installed on the d drive, and all the files are still there. I believe it will be restored until the work is completed, I started to complete my database. It took

Recently, we need to reschedule the partitions of a large partition table. After reading the online materials, I found there are three methods.1. alter table table_name split PartitionAlter table table_name split partition seems to have a bug in my 1

When I installed Oracle for my classmates today, I found this error (SID already exists). The following is a solution:   1. Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services. 2. Start-> Program-> Oracle-orahome81-

Specify scale for numbers Includevelopers do not specify a precision for number columns. this may be in order to minimize the work that wocould be needed to increase that precision shocould the application's requirements change, but it is often just

Oracle databases consume too much resources. If you do not need to install it, it will consume too much resources. I only have to choose to start its database service as needed. Check that all Oracle service startup types are set to manual startup.