11.2.0.3.0-Production
Core 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0-Production
Nlsrtl version 11.2.0.3.0-Production
Create directory on the server:
SQL> create directory backup as '/u01/backup ';
Directory created.
SQL> grant read, write on directory backupto Dave;
Grant succeeded.
Configure tnsnames. ora in the client as follows:
DG =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.3.11) (Port = 1521 ))
)
(bottom) input join. This is the same effect as querying multiple tables with SELECT, so there are few internal connections.Another point to note is that join is inner join by default. So we can omit the Inner keyword when we write the inner connection.1.2 For example, the following is a clear connection:1.2.1 First create 2 test tables and insert the data:Sql> select * from Dave;ID NAME---------- ----------1 Dave2 BL1 bl2 DaveSql> select * from BL;I
the first (top) input join with the second (bottom) input. This is the same effect as using a select query for multiple tables, so there is little internal connection.
Another point to note is that the join defaults to the inner join. So we can omit the Inner keyword when we connect in writing.
2, the following examples of the connection in the Ming:
(1) Create 2 test tables and insert data first:
Sql> select * from Dave;
ID NAME
---------- ---
table is the base table for both the left and right outer joins, and the contents of the table are all displayed, followed by two tables that match the contents. If the data in the base table is not recorded in another table. Then the columns in the associated result set row are displayed as null values (NULL).For outer joins, you can also use "(+)" to represent them. Some things to note about using (+):1. The (+) operator can only appear in the WHERE clause and cannot be used in conjunction wi
(+):1. The (+) operator can only appear in the WHERE clause and cannot be used in conjunction with the outer join syntax. 2. When an outer join is performed using the (+) operator, if more than one condition is included in the WHERE clause, the (+) operator must be included in all conditions3. The (+) operator applies only to columns, not to expressions.4. The (+) operator cannot be used with the OR and in operators.5. The (+) operator can only be used to implement left outer and right outer jo
Category: Linux 2010-08-17 17:58 25443 people read Comments (0) Favorites Report Linux terminal user Oracle command FTP server
Today, my colleague asked me a question, access FTP under Linux, and upload the file. I've been using the WinSCP tool before. First file from Linux Copy to Windows, and then upload to FTP. Google a bit. Method is also relatively simple. This is only discussed through terminals, because it can also be done via IE or other tools.
1. Linux Terminal Connection FTP
[Oracle
This article mainly introduces the attributes and class methods of objects in Python surface object programming. Classes, objects, and methods are the basic content of the Surface object programming language, for more information, see
Attributes of python objectsNext, let's take a look at an instance to learn about the differences between classes, public attributes, private attributes, local variables, and global variables in python.
root@10.1.6.200:~# cat object.py
#! /Usr/bin/env python #
parameter is set as valid_for = (standby_logfile, *), when the compatible parameter is greater than 10.0, the LOG_ARCHIVE_DEST_n value is automatically selected.
(3) If LOG_ARCHIVE_DEST_n is not set, the default location is:
$ ORACLE_HOME/dbs.
However, the default values of the valid_for parameter are all_logfiles and all_roles. Therefore, if you set a local archive location, the remote archive file will also be placed under this directory.
5. Restart the master database with the new pfile
An example is provided to illustrate the object attributes and class methods in Python surface object programming.
Attributes of python objectsNext, let's take a look at an instance to learn about the differences between classes, public attributes, private attributes, local variables, and global variables in python.
root@10.1.6.200:~# cat object.py
#! /Usr/bin/env python # coding: utf8 class Dave (): var1 = "class atri.pdf, public atrri#var1" # class
A friend asked me on QQ that the pfile and spfile of his database were gone. I asked him whether the database was 10 Gb or 11 GB. He said 11 GB, so I asked him to use this syntax to create spfile:
SQL> Create spfile from memory;
This is a new feature of Oracle 11g. In my new features of Oracle 11g, we will introduce the following:
New Features of Oracle 11g-instructions for managing spfile
Http://blog.csdn.net/tianlesoftware/article/details/8225247
After a friend uses this method, the follow
most flexible.
The architecture of GG is: extract + Data Pump + replicat.
2.1 clear the previous Gg Environment
-- Target System
SQL> conn Dave/Dave;
Connected.
SQL> drop table pdba;
Table dropped.
Ggsci (gg2) 46> stop rep1
Sending stop request to replicat rep1...
Request processed.
Ggsci (gg2) 47> info all
Program Status group lag time since chkpt
Manager running
Replicat stopped rep1 00:00:00
Ggsci (
Before Oracle11g, if you want to set a table as read-only, you can grant select permission to some users. But for the table owner, it is still read/write.
Before Oracle 11g, if we want to set a table to read-only, we can grant some users the select permission. But for the table owner, it is still read/write.
1. Read only table description
Before Oracle 11g, if we want to set a table to read-only, we can grant some users the select permission. But for the table owner, it is still read/write.
SYSDBA and Oper permissions are saved in the password file, other users will also be affected.1.2ExampleHere we do a test on Oracle 10g, in order to avoid the impact of OS certification, we can disable OS authentication here.Oracle OS certified password file loss handlinghttp://blog.csdn.net/tianlesoftware/article/details/4698293Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise editionrelease 10.2.0.5.0-64biPL/SQL R
. You can view the control file through dump.
2.1 direct dump controlfile
Alter system set events 'immediate trace name controlf level 10'
2.2. Use alter database backup controlfile to filename
The dump file generated by the preceding two methods is unreadable and garbled. It is readable only after the trace is generated.
2.2. Use alter database backup controlfile to trace
The generated trace file is in the udump directory and can be determined by date.
SQL> show parameteruser_dump_dest
Today, my colleague asked me a question, access FTP under Linux, and upload the file. I've been using the WinSCP tool before. First file from Linux Copy to Windows, and then upload to FTP. Google a bit. Method is also relatively simple. This is only discussed through terminals, because it can also be done via IE or other tools.
1. Linux Terminal Connection FTP
[Oracle@dave ~]$ FTP 10.85.7.97
Connected to 10.85.7.97.
Serv-u FTP Server v6.4 for WinSoc
Properties of the Python objectTo get to the point, take a look at an example of the differences between classes in Python, public properties in objects, private attributes and local variables, and global variables.
#!/usr/bin/env Python#coding:utf8 class Dave (): var1 = "Class Atribute,public Atrribute var1" #类属性, public properties var1 __ VAR2 = ' class self atribute __var2 ' #类的私有属性__var2 def fun: self.var2 = ' object public atrribute va
----------------------------------------
Sys true
Dave1 true
SQL> conn dave1/Dave;
Connected.
SQL> conn dave2/Dave;
Connected.
SQL> conn dave1/Dave;
Connected.
SQL> conn dave1/dave1;
Error:
ORA-01017: invalid username/password; logondenied
Warning: you are no longer connected tooracle.
It can be seen from this that the password in Oracle 10 Gb is case-inse
: ' D ', 2: ' B ', 3: ' B ', 4: ' E ', 5: ' A '})
[1, 2, 3, 4, 5]
2 Key parameter/function
Starting with python2.4, the List.sort () and sorted () functions add a key parameter to specify a function that will be invoked before each element is compared. For example, a function specified by key ignores the case of a string:
Copy Code code as follows:
>>> sorted ("This is a test string from Andrew". Split (), Key=str.lower)
[' A ', ' Andrew ', ' from ', ' was ', ' strin
The database instance name is dave. Because it is made into RACstandby, the database's db_unique_name is changed to dave_st. This is no problem in a single instance,
The database instance name was originally dave. Because it was made into RAC standby, db_unique_name of the database was changed to dave_st. This is no problem in a single instance,
I. Question 1
The following error is found in the alert log
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.