If you run the Telnet command in win7, the system prompts no:
C: \ Users \ administrator. David Dai> Telnet 192.168.3.100 3306
'Telnet 'is not an internal or external command, or a program or batch file that can be run.
Google: It turns out that
Compiling invalid objects is one of the common tasks of DBAs and database developers. The following two methods are provided to capture errors during compilation.
I. Current Database Version Information and invalid objects
1. view the current
The new environment has not been launched yet. Today, a warning is reported in the script deployment and RMAN backup. The content is as follows:
RMAN-06207: Warning: 1 objects cocould not bedeleted for disk channel (s) due
RMAN-06208: To
(1) listener. ora
In this experiment, static listening is configured to listener L1, and the project sid_list_l1 is the static listening configuration of L1:
L1 = (description_list = (description = (address = (Protocol = TCP) (host = PC1255-201105
On Weibo, we saw a training session on dbsnake, because it was held in Beijing and never used. So I asked if dbsnake could pass the relevant documents to me. When dbsnake sent me an email, he said something was not written to the document. This
Select any dictionary and select_catalog_role
Similarities,With one of the two, you can query the data dictionary.
Differences:
1. Select any dictionary is a system permission (system privilege), while select_catalog_role is a role (a role ).
2.
In the event you cannot mount your ASM disk groups, you will be unable to start any databases using those disk groups. Here is a possible error reported when mounting ASM disk groups:
SQL> startup Mount
ORA-15032: not all alterations saved
ThissqlWhat should I do?
The two tables have the same structure. Most of the data is duplicated, and a small part is different;
Requirements:
1.IfaSame Column data, ComputationbResult of column Subtraction
test1:
a b
xxx 1
yyy 2
zzz 3
test2
In a single asm_diskstring parameter we can have 255 characters and this excludes the asterisk (*), comma (,) and single-quote ('). this is limited by V $ asm_disk.path column's datatype length.
In an ASM instance we can have multiple
Editplus is a powerful text editor with unlimited Undo/Redo (UNDO), spell check, automatic line feed, column number tag, search replacement, multi-file editing at the same time, full screen browsing function. It also has a good function, that is, it
How to Create physical standby database with 11g RMAN duplicate from active database [ID 747250.1]
Modified15-feb-2011TypeHowtoStatusPublished
In this documentGoalSolution
Applies:
Oracle Server-Enterprise
The ONS process in the RAC environment of a friend in the DBA group cannot be started. The platform is RedHat 5.3 64bit.
ONS log is as follows:
09:42:11. 384: [racg] [3041022624] [16815] [3041022624] [ora. rac1.ons]: clsrcexecut: ENV
ORA-16032 can not start instance via srvctl but via sqlplus is fine [ID 1062071.1]
Modified07-oct-2010TypeProblemStatusPublished
In this documentSymptomsChangesCauseSolution
Applies:
Oracle
In the Mid-Autumn Festival morning and in sleep, the alarm clock is set. I dreamed about it. I went back to the junior high school classroom. Then, I checked my English knowledge by the English Teacher Liu Ping. I first asked me what I had
In the morning, a group of friends said that the index was not completed in half an hour on a million table, and it was a bit abnormal. They discussed how to reduce the index creation time and used nologging + parallelism, but the effect is not
A strange problem occurred when importing data from a database. Chinese characters are garbled. First, you can confirm that the data in the database exists in Chinese, and that the data is also in Chinese when you use toad for connection query.
The following prompt is displayed when the VM network encounters a problem today:The Network Bridge on device vmnet0 is not running. The virtual machine will not be able to communicate with the host or with other machines on your network. Virtual
'Folder folders. vbs 't0nsha '2017/20 '. Obtain the current directory of the script file. Function getcurrentfolderfullpath set FSO = Createobject ("scripting. fileSystemObject ") getcurrentfolderfullpath = FSO. getparentfoldername (wscript.
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