Sqlplus local connection is not a server error as follows: SQLgt; connhailianghailiang @ DBNetSpiderERROR: ORA-12154: TNS: couldnotresolvethe
Sqlplus local connection is not a server error as follows: SQLgt; conn hailiang/hailiang @ DBNetSpiderERROR:
MongoDB provides the Replicapairs mode to start a database. After the database is started in this mode, the database automatically negotiates who is the master and who is the slave. Once a database server loses power
MongoDB provides the Replica
By default, MongoDB does not need to enter the User and password, so the client can log on. This security problem is serious. There are also many examples on the Internet, but there are also a lot of details
By default, MongoDB does not need to
Create and manage Oracle partition tables
Create and manage Oracle Partition tables
-- Note that subpartitions 2 does not specify that the number of subpartition must be 2. In fact, the number of subpartitions in each partition can be
The summary in this document is very comprehensive, but there are several errors (such as fal_server and fal_client instructions) or some are not clear enough, I made some corrections to distinguish network connection strings
The summary in this
To ensure that the instance is down but the listener is not down, all the listeners need to be dynamically registered and the service names configured statically are not allowed. when the instance goes down due to Dynamic Registration
To ensure that
Check spfilesqlgt; showparameterspfileNAMETYPEVALUE if one of RAC instances is abnormal.
Check spfilesqlgt; show parameter spfile name type value if one of RAC instances SGA is abnormal.
One instance of RAC is found to be abnormal. view the
There are three types of SCN in a data block of Oracle, namely the block header SCN, CSC (cleanoutSCN) and commitSCN recorded in ITL. If you want to view
There are three types of SCN in a data block of Oracle: The Block header SCN, the CSC (cleanout
-- Oracle paging statement description -- number selectt1. * for each record, rownumrnfrom (select * fromemp) t1; -- extract the first 10 records selectt1. *, rownum
-- Oracle paging statement introduction -- for each record number select t1. *,
How to sort fields in Oracle in the form of Chinese characters and numbers: for example, orderbyNLSSORT (field name,
How to sort Chinese and numeric fields in Oracle in a hybrid manner: for example, order by NLSSORT (field name,
How to sort
The main purpose of setting master-slave replication for Mysql is as follows: 1. If the master server crashes, the slave server can be directly enabled as the master server. 2. The slave server table can be directly locked.
The main purpose of
Oraclebug ORA-00600 [LibraryCacheNotEmptyOnClose]
Oracle bug ORA-00600 [LibraryCacheNotEmptyOnClose]
Help a customer shut down the database. When the instance is closed, alert displays
Reference
Fri May 14 01:08:49 2010System State dumped to
The memory structure of Oracle consists of SystemGlobalArea (SGA) and ProgramGlobalArea (PGA ). SGA: When an instance is started
The memory structure of Oracle consists of System Global Area (SGA) and Program Global Area (PGA ). SGA: When an
1. Set up oinstall, dba, Region group 2, oracle user 3, and system parameter optimization (aio has been dynamically applied to AIX6L and does not need to be configured. Run rootpre
1. Create oinstall, dba, Region group 2, oracle user 3, and system
Back up archive logs-view the archive logs generated in the past day at the first archiving location. dest_id indicates the location where archive logs are stored, corresponding to 1 ~ in v $ archive_dest ~ Des of 10
Back up archive logs-view the
After oracle10.2.0.1 is upgraded to 10.2.0.4, an error occurs in the EM console.
After oracle 10.2.0.1 is upgraded to 10.2.0.4, an error occurs in the EM console.
After Oracle 10.2.0.1 is upgraded to 10.2.0.4, an error occurs in the EM
When I was working on two sets of AIX5.3 + 10.2.0.4RAC recently, I didn't find the AIXToolboxforLinuxApplicationsforPOWERSystems disc. To make it simple, I used RSH as the far
Recently, when I was working on two sets of AIX5.3 + 10.2.0.4 RAC, I
When phpadmin converts the generated SQL statement into PHP code, it will find that the field attribute is changed to 'CC _ user' instead of single quotation marks. Because the single quotes in PHP are strings
When phpadmin converts the generated
First, you need to understand the requirements for installing oracle: RedHatEnterpriseLinuxASES3.0 (Update4orlater) Red
First, you need to understand the requirements for oracle Installation: Red Hat Enterprise Linux AS/ES 3.0 (Update 4 or later)
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service