It took me a week to install rac, and I had a lot of detours. I hope to help people who encounter similar problems in the future. First of all, I would like to thank Lei Yu for following his steps. You can install it according to his subsidy, and he wrote very well. My main problems Are: Problem 1: Specified Nodes Are Not Clusterable. Solution to this problem: 1. cd $ HOME2. mkdir ~ /. Ssh3. chmod 700 ~ /.
Discover Navicat as a database-connected tool that really works well, the visual interface looks a lot more comfortable, here are some of the issues I have today when connecting to the Oracle database:1, after the installation of Oracle directly with Navicat is not connected, will appear as the error; When you use Navicat to connect to Oracle, you must first down
This article attempts to provide a common diagnosis method for CPU consumption problems through a case adjusted in the actual business system. In most cases, system performance problems are caused by poor SQL code. As a DBA, how to discover and solve these SQL problems is particularly important.
In this case, the platform is UNIX, so it is inevitable to apply som
oracle| problem everyone in the application of Oracle may encounter a lot of seemingly difficult problems, especially for beginners, today I simply summed it up, released to everyone, hope to help everyone! And we discuss together, progress together!
There is no need to look at Oracle Masters.
1.
server.C:/>; tnsping orcl
TNS Ping utility for 32-bit windows: Version 10.1.0.2.0-production on 16-8 months-09:36:08 2005
Copyright (c) 1997,200 3, Oracle. All rights reserved.
Used parameter files:E:/Oracle/product/10.1.0/db_2/Network/admin/sqlnet. ora
Used tnsnames adapter to resolve the aliasAttempting to contact (description = (address_list = (address = (Protocol = TCP)(Host = 127.0.0.1) (Port = 1521)
Java Oracle Stored Procedure Problems
PL/SQL is an extension of Oracle's standard database language. ORACLE has integrated PL/SQL into ORACLE servers and other tools, in recent years, more developers and DBAs have started to use PL/SQL. This article describes basic PL/SQL syntax, structures and components, and how to d
$ database; check whether the database is on or on.
OPEN_MODE
----------
READ WRITE
#-----------------
Example of using hostname to access the database rather than tnsname
Using tnsname to access the database is the default method, but it also brings about some problems, that is, the client needs to configure the tnsnames. ora file. If the address of your database server changes, you need to re-edit the file on the client. Accessing
. But I used the netca command to re-create the listener and then tested the expdp to find the same problem.
2. Final Solution:Su-oracle users can view the listening file and find the following problems:[Oracle @ linuxtest admin] $ cat tnsnames. oraCat: tnsnames. ora: Permission denied
The prompt is that the permission is insufficient. It was previously viewed un
the current information obtained, if you need to query Metalink to get help, then should be limited to consider the Rman problem, because the Rman problem contains a large number of clear information, both Rman error information, there is also a command to cause error information, So it's easy to find the most relevant description of the problem. For Racgmain check process issues, Racgmain check itself is a good query keyword, it is easy to find the relevant information in Metalink. For job
The Oracle installation and configuration process is closely related to the operating system, storage, and network. Especially in Linux and AIX environments, the configuration process is relatively complex. A link error may cause a series of faults in the future.In addition, the steps and methods for executing the same installation project vary greatly with the Oracle version. For example, Data Guard has th
Today, I want to install the personal version of Oracle, But I have encountered many problems. Problem 1: The network configuration check fails because the company has not set a domain for the employee's computer. For example, James. The user name on his computer is zhangsan and the domain name is node. When the administrator logs on, the domain option is (zhangsan. Actually, no
Today, I want to install the
Common Oracle commands and recently used Problems
[Problem and background]1. delete a table? A library?Drop table table_name;Drop table database_name;2. Delete all data of a user?It is best to stop the database first and shutdown immediate; startup to ensure no user connectionOr select Sid, serial # from V $ session where username = // 'username // '; query the connectionSid serial #--------------
oracle| Solve | The problem
Most of the time, the technical problems of most it classes can be solved by themselves, and we need a method more than the answer. Here is an example of a solution to the Oracle problem (approach?). If you can say so).
Ask:
Questions about the X$ktuxe table??
I see this statement in the E-magazine (note: Www.itpub.net's electronic m
components of the files in the file, there is no problem, then you can choose to abort the installation. When there is a way to continue Setup.exe installation, the same can be installed successfully. The above is the first problem and the file cannot be found. The second problem, found in the abort after the installation, after installation, through the browser access to the EM failure, the browser reported that this site's security certificate expired issue. When you enter CMD, Input, EMCTL s
Http://www2.ccw.com.cn/02/0224/c/0224c05_1.asp
Character Set problems during Oracle Data dumping
Wang quanhai, Northeastern University, Qinhuangdao Branch
As an Oracle database user, there is no stranger to the export and import commands, because these two commands are often used by us.Tools for data backup and recovery. However,
Analysis of Character Set problems in Oracle databases
I often see some questions about Oracle character sets. I 'd like to introduce them in an iterative way.
First iteration: master the basic concepts of character sets.Some may think that this is an option, but in fact it is precisely because of the unclear understanding of the basic concepts that lead to many
Tags: plan rom set str condition Eve for Art Idle--1) SQL statement for querying and locating database problems--oracle Common Performance Monitoring SQL statements. sql --1 Query Lock table information Select VP. SPID,Vs. P1,Vs. P1raw,Vs. P2,Vs. EVENT,Vsql. Sql_text,Vsql. Sql_fulltext,Vsql. sql_idFrom V$session vs, V$sql Vsql, v$process VPWhere vs. sql_id = Vsql. sql_idand vs. PADDR = VP. ADDRand vs. Wait_
Tags: parsing data through Access database HTTP LOB ges logs minor issuesProblem Description: Export from Access via ODBC to Oracle ora-24801 illegal value error and Ora-01401 value too large errorProblem Analysis: The field type in Access is "Memo", and importing to Oracle automatically turns into a CLOB type, and there may be some strange errorsWorkaround: Change the field type to "Memo" to "text" and the
Label:Navicat visual create a table, but just can't find! Why is this? select * from user; If we add double quotes to the user, we can find SELECT * from "user"; Conclusion: 1. Oracle tables and fields are case-sensitive. Oracle defaults to uppercase, and if we enclose them in double quotes it is case-insensitive, and if not, the system will automatically turn into uppercase. 2, when we use Navicat to c
Yesterday, a RedHatLinux5 + Oracle version was installed in the middle of the night. Several things were encountered during the installation, and the statement is as follows. You need to configure kernel parameters before installation. For more information, see Oracle
Yesterday, a RedHat Linux version 5 + Oracle was installed in the middle of the night. Several t
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.