Database Administrator

ORA-28000: the account is locked resolved In Oracle, if the account fails to log on for ten consecutive attempts, the account will be locked ). When you log on with a locked account, the system reports an error: ORA-28000: the account is locked.

DataGuard: troubleshooting of non-real-time update small problems in the logical standby database of the DG Series I. Overview DataGuard is increasingly becoming an important tool for disaster recovery and pressure-sharing in databases. As the

Configure IP address access restrictions for Oracle 11g For data security considerations, make some restrictions on the IP address of the Oracle database. Only a fixed IP address can be accessed. Modify the $ JAVA_HOME/NETWORK/ADMIN/sqlnet. ora

New Features of Oracle 11g virtual column partitioning There is a need: a document table should be partitioned by month. If it is on Oracle 10 Gb, only one field can be added. It will be different after the Oracle 11g. You can use virtual column

An error occurred while starting Mysql Data migration. mysql migration I don't know why after work today, mysql has never been able to start. After a long time, I decided to reinstall it. My local server uses wamp. During the reinstallation, data

SQL EXISTS usage and SQLEXISTS usageFor example, a query in the Northwind database isSELECT c. CustomerId, CompanyName FROM Customers cWhere exists (SELECT OrderID FROM Orders o WHERE o. CustomerID = c. CustomerID)EXISTS is used to check whether a

Use the kettle component to import an excel file to the database, kettleexcel Use the kettle component to import an excel file to the database 1. Goals Import the excel file content to the target table. Then, use java to call kettle conversion. The

Oracle-stored procedure exercises, oracle-Stored Procedure -- ==================================================== Stored Procedure = ========================================================== =======/ ** scm_iss.test_imit_pro1 * No parameter Stored

Summary of methods for detecting ORACLE data block corruption, and oracle Summary 1: Use initialization parameters You can use the initialization parameter db_block_checksum \ db_block_checking to set the database's physical consistency and logical

Oradebug promotes scn and oradebugscnSometimes we encounter the following errors: ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00600: internal error code, arguments: [2662], [0], [5685940], [0], [5685970], [4194432], [], [], [], [],

Splunk meeting Review: The Key to big data is machine learning. splunk Review Jonathan Allen, author The Splunk User Conference is coming to an end. During the three-day conference, over 160 topics were discussed, covering security, operation,

Introduction to Neo4j database, neo4j Database As the world's advanced graph database, Neo4j has become the first choice for many Internet companies. Neo4j is an open source graph database developed based on java and also a NoSQL database. While

What is the difference between sqlplus logon and plsql logon? sqlplus logon to plsql The following two logon methods are available: If the local SQL * Plus is used to connect to the local database, the "host string" can be blank. To remotely

Process, port, oracle11grac, which must be used to install oracle11g db or RAC firewall in windows1. Firewall Exceptions for Oracle Database For basic database operation and connectivity from remote clients, such as SQL * Plus, Oracle Call Interface

MySQL add user and authorization (dbforge studio mysql) graphic details, remote access, mysqldbforgeFor Windows 7 32-bit systems, you can use dbforge studio mysql to add users to mysqlMySql, create databases, authorize users, delete users, and

What is the difference between Oracle index unusable and invisible? unusableinvisible Extracted from the 11g Official Document: UNUSABLESpecify UNUSABLE to mark the index or index partition (s) or index subpartition (s) UNUSABLE. the space

Oracle 12c agent install for linux, oracle12c  Install Agent During EM11g, the agent is installed by downloading and installing the agent on the monitored host. In EM12c, you can run the agent on the EM12c server, the "push" method is used to

Data migration and data transfer1. Software Support 1.1 download migration tool: Navicat_Premium_11.0.101.2 connect to the database 1.2.1 open Navicat and click Connect. Create a MySQL connection and an oracle connection. The specific steps are as

PostgreSQL traverses the simple tree, postgresqlYesterday I used MySQL to implement the ORACLE recursive statement CONNECT BY, which looks a little complicated. Today, let's take a look at how POSTGRESQL implements oracle connect.We still use the

Rac_grid self-check prompts that the cvuqdisk package is missing, and rac_gridcvuqdisk Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will