Oracle

In Windows, Oracle 11g cannot be started normally after a shutdown and cannot be started to the mount state: ORA-03113: end-of-file on communication channel Process ID: 4276 Session ID: 1286 Serial number: 2 Find the trc file of the corresponding

This means that the system cannot log on, and no user can log on. If you suspect that the database is faulty, you can log on to the server and run sqlplus username/password. If you do not enter the database, you are prompted to enter the username.

Take the 11g Official document as an example:Today, let's talk about how to quickly get the required knowledge from the official documentation. Official online documentation address: http://tahiti.oracle.com/almost includes the oracle documentation

crs_stat -tName Type Target State Host ------------------------------------------------------------ora.DATA.dg ora....up.type ONLINE ONLINE node1 ora....ER.lsnr ora....er.type ONLINE ONLINE node1

Functions of L1, L2, and L3 blocks:-facilitates the query of data blocks. L1 has a pointer to L3, L2 has a pointer to L3, and L3 has multiple data block pointers and States.1. Each L3 contains multiple L2 addresses (the first L3 is the segment

In Procedure, p_receiver is the recipient address. Multiple recipients are separated by commas,P_sub is the mail title, and p_txt is the mail content (HTML is supported ). The Code is as follows: Copy codeThe Code is as follows:Create or replace

1. SQL SERVER variables must start. 2. You do not need to write a semicolon Terminator after the SQL SERVER statement. 3. oracle variable type number can be changed to decimal of SQL server 4. The oracle variable type varchar2 can be changed to

Oracle patch is also an Oracle patch. Oracle patches include several other types. Small patches are hard to count and are confusing. However, Oracle patches are still sequential. In addition, the opatch tool provided by Oracle is very convenient for

1. Preface Recently, due to project requirements, the employee's working group needs to be returned to the front-end. However, in the database, the employee's working group Id is included in a field (separated by commas ), this does not meet the

The installation of the oracle client is very simple. The key lies in the tns configuration. The rpm installation package I used here is that oracle itself is not open source, which is the easiest to install with rpm. 1. to remotely use oracle,

Solutions for EXP-00008 & ORA-06550 & ORA-00904 during expSymptom: exp returns an error as follows:[Oracle @ cicgo1 oracle] $ exp system/pass owner = cicgo file =/tmp/cicgo. dmpExport: Release 8.1.7.4.0-Production on Tue Apr 23 15:07:17 2013(C)

1. Disable all oracle services Close the windows Service Manager (Windows + R, and enter services. msc to quickly open the Task Manager) (if you have not enabled oracle tasks, skip this step !) 2. Delete oracle information in the Registry Windows +

1. Create a tablespace with a block size of 2 kb create tablespace tbs_2k datafile 'C:\APP\ADMINISTRATOR\ORADATA\HXL11G\hxl01.DBF' size 128m blocksize 2k;If an error is reported, run the following statement: alter system set db_2k_cache_size=50

Version: 11.2.0.1.0-64bit After the local machine is installed with Oracle, the link test shows the following situations: Sqlplus scott/tiger Login Sqlplus scott/tiger @ orcl Login Failed, prompting ORA-12514 error, it should be unable to recognize

TO_DATE format (take time: 13:45:25 as an example) Year: Yy two digits two-year value: 07yyy three digits three-year value: 007 yyyy four digits four-digit annual value: 2007 Month: Mm number two-month display value: 11mon abbreviated Character Set

1. Use SQL * PLUS to stop a database $ Sqlplus/nolog SQL> connect/as sysdba SQL> shutdown [immediate] SQL> exit 2. Stop Listener $ Lsnrctl stop 3. Stop the HTTP service # Service httpd stop 4. Use su or log on to the root again (if you want to

I. DescriptionThe oracle exp/imp command is used to export/import databases; The exp command is used to export data from a remote database server to a local machine to generate a dmp file; The imp command is used to import the dmp file of the local

-- Add by biao.chen@hand-china.com -- 10:15:56 PROCEDURE done (p_party_id NUMBER, p_contry VARCHAR2, 1_varchar2, p_provice VARCHAR2, p_city VARCHAR2, timed OUT VARCHAR2, x_msg_count out number, x_msg_data OUT VARCHAR2) IS wrongly formed;

Problem description: A listener is created, and the listener service in the service is opened, but in the listener folder (app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN) does not generate the correct listener file listener. ora

A sudden power failure occurs during Oracle shutdown, and the database cannot be connected when SQL/plus is used for startup. The specific description is as follows: Connection can not permitted, shut in progress. Enter: c: \> sqlplus/nolog