Database Administrator

I have always been used to learning C ++ through source code. Last month, I made a fuss about the SGI's STL source code. After all, the configuration process was smooth under Win, you can refer to the STL source code of Hou Jie. I will go deep into

Linux:[Root @ rac1 ~] #Lsb_release-LSB Version: core-4.0-amd64: core-4.0-ia32: core-4.0-noarch: graphics-4.0-amd64: graphics-4.0-ia32: graphics-4.0-noarch: printing-4.0-amd64: printing-4.0-ia32: printing-4.0-noarchDistributor ID:

Finally solved the Mysql garbled problem! The system is Fedora 15. After using sudo yum install mysql-server mysql-client, modify/etc/my. cnf Add default-character-set = utf8 under [mysqld], restart mysql, and report an error. view the log, I

Database creation script:   Drop TablePerson Create TablePerson ( IdVarchar(32)Not Null Primary Key, NameVarchar(20)Not Null, PasswordVarchar(20)Not Null, SexVarchar(20 ), EmailVarchar(30)

1. log on to and unlock the account with the dba role. First, set the specific time format to view the specific time.SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss ';Session altered. 2. view the lock timeSQL> select username, lock_

OCCI(Oracle C ++ Call Interface):C ++Program andOracleThe database implements interactive application interfaces, which are provided to users in the form of dynamic connection libraries.OCCIPairOCIImplements object-level encapsulation, and its

Oracle beginners, start oracle service on Windows: net start OracleServiceOrcl, and then open pl/SQL to connect to oracle, but an error is displayed, cannot connect. Later I found that the listening service was not started, so I started the

Environment: CentOS 5.6X64 Oracle 10G Clusterware database This step has been tossing for a long time. First After a long time I finally found the reason. I thought that the rsh service is not required for as5 or later versions. Therefore, the

I am reading the Oracle 10 Gb documentation today and have noticed Irreversible Compatibility. Starting with Oracle Database 10g, the COMPATIBLE initialization parameter becomes irreversible; that is, it cannot be set to a value that is less than a

1. Clone Process Oracle@www.bkjia.com ~ $ Dbca 1. After running DBCA, select "manage template ". 2. Select "create from existing database (structure and data" 3. Select the name of the instance to be cloned. 4. Enter the Template Name and

Create a connection >>> Import pymongo>>> Connection = pymongo. Connection ('localhost', 27017)Switch Database >>> Db = connection. test_databaseGet collection >>> Collection = db. test_collectionDb and collection are created in a delayed manner.

I plan to play with RAC on a virtual machine. I made a google call and found that most of the information is based on this post (). I used VMware Server to create shared storage based on bare devices, oracle official information

Install Oracle 9 in WindowsIMany services will be installed, and some of them are configured to start at Windows startup. When Oracle runs in Windows, it consumes a lot of resources, and some services may not always be required. You will find it

In Oracle, if you want to view the current date and time, use select sysdate from dual; So is there a system table like dual in oracle in db2? The answer is yes at the time, that is, sysibm. sysdummy. The schema of the front edge must be added;

In other words, download mysql-python-1.2.3.win32-py2.7.exe Is: Free in http://linux.bkjia.com/ The username and password are both www.bkjia.com The specific download directory is/pub/2011/12/07/access the MySQL 2.7 database on the Python 5.0

For a long time, masters have told us that Oracle's NULL and 0 are different. What is the difference. When I practiced it, I forgot the warnings. Yesterday I made a report. The customer said how to add the details differently from the value of the

(UR) UNDO_RETENTION in seconds(UPS) Number of undo data blocks generated per second(DBS) Overhead varies based on extent and file size (db_block_size) UndoSpace = [UR * (UPS * DBS)] + (DBS * 24) In the above formula, 1st and 3 parameters can be

AdditionSelect sysdate, add_months (sysdate, 12) from dual; -- add 1 yearSelect sysdate, add_months (sysdate, 1) from dual; -- add JanuarySelect sysdate, to_char (sysdate + 7, 'yyyy-mm-dd HH24: MI: ss') from dual;-- Add 1 weekSelect sysdate, to_char

1. The Assigned primary key is generated inside the database without Hibernate intervention. 2. hilo requires additional database tables to save the Historical Status of the primary key generation. 3. increment maintains a variable in the instance

ERROR-ORA-12541: TNS: No listener 1. If it is on this machine, it means that the Oracle client and the oracle server are on one machine. This problem occurs because the service and listener are not started. Computer --- management ---- Service