oracle database firewall ports to open

Failure phenomenon:How do I make a cold backup of an Oracle database in case of an emergency, without opening the Oracle log archive?Solution: A cold backup of the Oracle database, sorted as follows: When do I have to use cold backup? 1.

1. The first is to turn off monitoring (so that remote clients can no longer connect);2. Issue a system checkpoint to unify the system modification number of the data file and the control file; (alter system checkpoint;)3.shutdown Immediate shutdown transactional;If it is a busy database, may be executing a lot of transactions, issued a shutdown command, there will be rollback, it may wait a long time, generally can be killed in 2 steps before these

Label:An Oracle database instance under Windows does not automatically open database problemNote: This article applies to the premise that Oracleservicelei in Windows Services is automatically or manually initiated.In daily operations, if you encounter an Oracle

In the past, I heard from others on the website that the open source version of QT cannot connect to the Oracle database. Normally, I can compile a driver to connect to the Oracle database. Today I want to say yes. First of all, we need to prepare for it. We have installed

According to foreign media reports on Monday, Sony Online Entertainment, which is mainly engaged in online games, recently signed an agreement with the open-source database vendor EnterpriseDB to buy a large number of database products and support services. Sony Online said it would replace some Oracle databases with E

and background process to turn off.Browser We do not have to live every day, and shut down the main program will not have a background process, so our goal is not it, Java process and eclipse every day open also inseparable from them, so also can not be a black hand to them; Hey, Oracle, I'm sorry, I can only kill you. Because we have a framework like hibernate, we don't need to know what

approach, so we need to use our brains from the software, which requires us to turn off services that are not often used and background processes.Browser We do not have to live every day, and shut down the main program will not have a background process, so our goal is not it, Java process and Eclipse open every day is inseparable from them. So you can't have a black hand on them. Hey, Oracle sorry, just c

and background process to turn off.Browser We do not have to live every day, and shut down the main program will not have a background process, so our goal is not it, Java process and eclipse every day open also inseparable from them, so also can not be a black hand to them; Hey, Oracle, I'm sorry, I can only kill you. Because we have a framework like hibernate, we don't need to know what

November February 15 (Dai xunyan compiled): according to an external report, Oracle announced the acquisition of open source database vendor Sleepycat on Tuesday. This is the re-acquisition of open source database companies after the acquisition of Innobase in Finland in May

Three steps of Oracle Database startup: nomount, mount, and open Three steps of Oracle Database startup: nomount, mount, and open Conn sys/sys as sysdbaShutdown abort;Startup nomount;Select instance_name, status from v $ inst

Case 3: (Recover tablespace, database open state) --database Recover data files in open state (except system tablespace) (1) Simulation Environment: 06:10:52 sql> INSERT INTO scott.t01 values (4); 1 row created. 06:13:12 sql> INSERT INTO scott.t01 values (5); 1 row created. 06:13:13 sql> INSERT INTO scott.t01 va

forcedORA-01405: fetched column value is NULLProcess ID: 5270Session ID: 10 Serial number: 3Undo initialization errored: err: 1405 serial: 0 start: 3126020954 end: 3126020954 diff: 0 (0 seconds)Errors in file/s01/diag/rdbms/asmme/ASMME/trace/ASMME_ora_5270.trc:ORA-01405: fetched column value is NULLErrors in file/s01/diag/rdbms/asmme/ASMME/trace/ASMME_ora_5270.trc:ORA-01405: fetched column value is NULLError 1405 happened during db open, shutting dow

oracle| Data | database A data file corruption, how to open the database? System environment: 1, operating system: Windows Server, machine memory 128M 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, Installa

A friend's company's database encountered an exception and there was no backup. After the database is opened, crash will be quickly cleared. The following alert log information:Tue Jul 08 22:53:03 2014SMON: enabling cache recovery[2, 13803] Successfully onlined Undo Tablespace 2.Undo initialization finished serial: 0 start: 7751194 end: 7751284 diff: 90 (0 seconds)Verifying file header compatibility

This article address: http://blog.csdn.net/kongxx/article/details/7107683 After installing the cx_oracle and Oracle Instant client packages, the following problems occur when importing packages using import Cx_oracle Importerror:libclntsh.so.10.1:cannot open Shared object file:no such file or directory This is because Python needs to use some Oracle librarie

1. Modify Listener.ora and Tnsnames.ora filesFile path is: C:\Oracle\Instanclient_11_2\network\admin　　# Listener.ora Network Configuration file:c:\oracle\instantclient_11_2\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener=(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home= C:\app\Administrator\product\11.2.0\dbhome_1) ( P

, from the library to take over the main library, complete identity changes. Can be a master library, up to 9 from the library. It is also divided into logical standby and physical standby here we are talking about physical standby.Once created and configured as standby, DG is responsible for transmitting the primary database redo data to the standby database, and standby the

Oracle Log File loss (ORA-O1109: the database is not open) solution after deleting the oracle11g tablespace file by mistake, the database is not open the cause of the above problem is mistakenly put 'f: \ ORADB. DEF 'the data file is deleted. This deletion method is not norm

only short names ("s" for short, shorter) %~a0 -Will%0 File attributes that are expanded to a file ("A" is attribute, that is, attributes) %~t0 -Will%0 Extended to File Date/time ("T" times) %~z0 -Will%0 Expand to file size (size) %~ $PATH: 0 -Find the directory that is listed in the PATH environment variable and add%0 Expands to the first fully qualified name found. If the environment variable name is not defined, or if no fi

Label:--SDE User Login Execute the following statementGrant INSERT, UPDATE, delete on sde.table_registry to public; Grant INSERT, UPDATE, delete on sde.column_registry to public; Grant INSERT, UPDATE, delete on sde.geometry_columns to public; Grant INSERT, UPDATE, delete on sde.layers to public; Grant INSERT, UPDATE, delete on sde.spatial_references to public; Grant INSERT, UPDATE, delete on sde.st_spatial_references to public;Open permissions SQL sta