Database Administrator

ORA-12154: TNS: unable to resolve the specified connection identifier resolved I believe that people who have used Oracle databases must have encountered the "ORA-12154: TNS: unable to resolve the specified connection identifier" error, I would like

Install Oracle database management software SQL Developer in Ubuntu 14.04 This is the second article about building Oracle Development Environment logs. Article 1: Build a PHP5 + Apache2 + Oracle environment in Ubuntu 14.04 This article will install

Full and incomplete Oracle database recovery and user management Backup Recovery Comparison between full recovery and Incomplete recovery: 1. Full recovery: restores the database to the latest status, including all submitted data changes until the

Alter table tablename add (column datatype [default value] [null/not null],...); Alter table tablename modify (column datatype [default value] [null/not null],...); Alter table tablename drop (column ); Alter table is used to add, delete, and

Install the Vbox extension package and the Vbox extension package **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please

Oracle local management comparison data dictionary management tablespace, oracle dictionary Locally vs. Dictionary Managed Tablespaces Organized from: http://www.orafaq.com/node/3. When Oracleallocates space to a segment (like a table or index), a

11 Database Design Guidelines and 11 database guidelines I have followed Author Shivprasad koirala, a former MVC engineer from Microsoft ASP/ASP. NET, is now a CEO in India. If you have any questions about the first translation, please kindly advise.

Oracle 11g PL/SQL function result cache, oracle11g Two experiments have been conducted to simulate the Oracle Performance Diagnosis art. The book says that if you don't need RELIES_ON, then the changes to the objects on which the function depends

We also encountered the Oracle database sequence problem, so we can simply back up and restore the entire database. As follows: Imp/exp Method Table mode backup: Oracle @ sencloudServer: exp dhoffice/dhoffice rows = y indexes = n compress = n buffer

[Course sharing] This article introduces how to transplant and develop an embedded linux system (Environment setup, uboot porting, and embedded Kernel configuration and compilation), and how to implement uboot. Embedded linux system porting and

Remember a bizarre TNS-12545 TNS-12560 TNS-00515, tns-12545tns-12560 Recently, reportDB listeners cannot be started with the system, which is a strange phenomenon. Because the listener of another instance on the server can be started normally, it is

10 things you should know about NoSQL Databases Since the 1/4 century, relational databases (RDBMS) have been the mainstream database models. But now non-relational databases, "Cloud" or "NoSQL" databases, are gaining an increasing share as an

Stored Procedure Overview The commonly used operating database language SQL statements must be compiled and then executed before execution. The Stored Procedure (Stored Procedure) is a set of SQL statements for specific functions, after compilation,

The earthdistance () function in postgreSQL is used in the project to calculate the distance between two points on the earth. There is too little Chinese information. I found a good English article, hope to help those who will use earthdistance in

DB2 does not exist in the explain table of the SQL Execution Plan by default. Therefore, you need to create an explain table as needed during use. How can you create it? In fact, DB2 still provides a variety of methods for you to use. The first

Recently, when sorting out content related to the test environment, students often ask the following terms: Database Name, Instance name, database domain name, Global Database Name, service name, This is a few confusing concepts for many beginners.

Computer Management-database system principles-database management and database system principles Definition: DBMS monitoring of databases is called database management or database protection. **************************************** ** The

When dbca deletes OracleserviceXXX in windows, the following error occurs: dim-00014 Cannot open the Windows NT Service Control Manager, cadmanagercontrol When dbca deletes OracleserviceXXX in windows, the following Error occurs: dim-00014 Cannot

Oracle Support (oci8) and oracleoci8 enabled for PHP in Linux A common problem with using php is: I forgot to add an extension when compiling php. I want to add an extension later. But I didn't want to delete the Directory and reinstall it because I

Memory Database In traditional database tables, due to the limitation of the physical structure of disks, the structure of tables and indexes is B-Tree, which makes such indexes very weak in the highly concurrent OLTP environment, although there are