This article describes how ASP. Net cannot be connected.OracleIn this case, an old system developed by vs2003 has no problem in local debugging. After being released to the server, it is found that the database cannot be connected. The following error is reported during the Open process:
System. Data. OracleClient requires Oracle client software version 8.1.7 or greater.
I have read a lot on the Internet, but it is said that the permission settings of the Oracle directory are incorrect. Therefor
Tora is an Oracle toolkit designed to help DBAs or database application developers. Features PL/SQL debugger, SQL work orders highlighted by syntax, DB browser, and a comprehensive DBA tool set. TOra also supports MySQL and PostgreSQL. Similar to toad in windows. Tora Project address: http://tora.sourceforge.net/install and use Tora on fedora8to install oraclec
Tora is an Oracle toolkit designed to help DBAs or database application developers. Feature
1. Download
: Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
This is the homepage for downloading Oracle Instant Client. There are many versions available for downloading.
However, note that third-party tools such as PL/SQL developer and toad must correspond to 32-bit oracleinstant client. Do not download 64-bit tools because the system is 64-bit, note This.
Ii. Configuration
Decompress the downloaded instantclie
already exists, but the project is too tight to update the control now. Toad data modeler Library: After case studio is sold, it is replaced by the toad data modeler library. After reading the materials, it has changed a lot and its functions have been improved a lot. I am afraid to use it immediately. After the project is finished, I will try again. Finally, db4o: The last o is the object. It is an object
= exp_2013-1-19.log SCHEMAS = bv
Date
2. Create an export directory:
The exp target directory is stored locally or in which directory? Create directory?
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
SYS DATA_PUMP_DIR/Oracle/product/10.2/db/rdbms/log/
SYS DATA_PUMP_DIR1/exp
SYS ORACLE_OCM_CONFIG_DIR/oracle/product/10.2/db/Cr/state
Create directory data_pump_dir2 as '/exp20130118 ';3. Export the dmp File
Find a busy time and execute the export script.
Ii. Import process
?
Author: Prince I Toad I reply dated: 21:59:13
Mac is a hardware address, and a NIC has an address, which is burned out at the factory.
Author: Prince I Toad I reply dated: 22:05:06
If you buy a cheap home router, you don't need to dial it. You can share it.
Author: hsc
A database version used to change the password of an Oracle user: 9.2.0.5)
Sometimes we may not know the password of a user, but we need to perform some operations with this user, and we cannot modify the password of this user. At this time, we can use some tips, to complete the operation.
If UNIX is used, it must be transferred to the Oracle user environment variable, provided that the operating system is used for verification.
The procedure is as follows:
SQL * Plus: Release 9.2.0.5.0-
://searchdatabase.techtarget.com.cn/tips/498/2059498.shtml
3. An experienced book
Tom's good book, after several years of oralce development, you may be able to really appreciate the benefits of IT, basically covering all the issues that are often considered in development, proof and answer are provided.
4. A good development tool. To do good deeds, you must first sharpen your tools.
The development tools provided by Oracle are not very user-friendly. SQL plus and sqlplus worksheet are too simp
through the pipeline:
1. Create a pipeline through mknod-p
$ Mknod/home/exppipe p
2. Import the generated compressed file
$ Imp test/test file =/home/exppipefromuser = test touser = macro
Gunzip
3. delete an MPS queue
$ Rm-fr/home/exppipe
4. General steps for full-Database Import
Note: During export, you must use toad or other tools to extract scripts for creating primary keys and indexes in the source database.
1. Add rows = n to the full database
A dblink is being built today ORA-00911: Invalid character error,Syntax isCreate Public database link TmsdbConnect to User1 identified by User1Useing ' (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.110) (PORT = 1521))(Connect_data =(SERVER = dedicated)(service_name = ORCL)))‘;Result hint ORA-00911: Invalid character error, with toad, PL/SQL developer tried or soI used to use the phrase many times, no problem, today is really god. There i
here. I directly use toad to copy the statement for creating a user, and even the encrypted password is available for convenience.
Copy the creation table space and user script to Toad and paste them directly for initialization preparation. The tablespace mainly refers to the tablespaces related to users, which can be queried using SQL statements. Users have to read them one by one.
1. 1. Create a pa
. 3, inquisitive of the spirit of quality management, to special emphasis on breaking the sand pot ask the end, and constantly go to ask questions, constantly seeking to find the source, you can make big things, so no research analysis of the spirit is not. 4, Teamwork team spirit to do things do not have a team, the time for individuals to play the world is long gone. 5, the generous spirit of active dedication to a large number of popular, can not be preoccupied with trivial matters. Do not
The previous introduction of some sql*plus knowledge, I already know, note: Autotrace can only run on Sql*plus, run on Toad, the actual bottom is also run on Sql*plus.AUTOTRACEAutotrace is easy to display, but it's easy to omit some important information, such as partition information, binding variables, and so on.The direct use of the command explain can not omit the partition information, the operation method is:Explain plan for Select ... (Note tha
Paip. Oracle10g DMP File Import Summary
Author attilax, email: 1466519819@qq.comSource: attilax ColumnAddress: http://blog.csdn.net/attilax
The tool I used is ..Toad for Oracle version 8.6.1
DBA> data import/export> Import utility wizard. You can select the DMP file as needed, but the following message is displayed:
Right... it's actually OK... this is probably the toad bug...
Data dump import wizard,
I. Insert the single quotation marks (single quotation marks) and the Symbol in Oracle
When importing a batch of data to Oracle today, I encountered a problem: toad prompts me to assign a value to a custom variable amp. At first I was wondering that data is a series of insert statements, how can I have custom variables? Then I searched for the keyword "amp" and found that it was because the content of a field in the inserted data was as follows:
From: http://www.cnblogs.com/william-lee/archive/2010/12/08/1900176.html
1. You have written Multiple SQL statements in the SQL window. If you click "execute", all the statements in the window will be executed. If you want to execute the statements, You must select them.
So, is there any SQL statement that executes the cursor position like toad?
Yes. See the following settings:
2. Can keywords be automatically capitalized in addition to aut
/exppipe gzip Export Scripts: # # #UNIX下 Oracle database is backed up via pipe pipe ###### using "export" and "tar" command to bakup Oracle datebase #######trap "" 1 #no Huplogfile=/opt/bakup/log/bakup_ora.logexport logfiledumpdir=/archlog_node1export DUMPDIRexec > $LOGFILE 2 >1echoecho ' Begin at ' date ' echo# clear Old result Filecd $DUMPDIRif [-F exp.dmp.z]thenecho "Clear old result file" rm exp.dmp.zfi# Make Pipemkfifo exp.pipechmod a+rw exp.pipe# gain the DMP. Z filecompress to import
Python Django environment setup tutorial (MAC + pycharm + Django ++ postgreSQL), djangopycharm
Setting up the Django environment seems to be a very simple task. In fact, it is not the case that I have struggled for more than half a day, so I would like to summarize the entire setup process here, at the same time, we also hope that our new entry peers will face fewer detours ~
Now, the required tools are as follows:
MAC
Python 2017 for MAC
Jdk1.8
Python3.6
PostgreSQL 9.6.6
In actual applications, sometimes we do not know the Oracle user password, but if we need to perform some operations with its users, however, you cannot modify the password of this user. At this time, you can use some tips to complete the operation.
The procedure is as follows:
SQL*Plus:Release9.2.0.5.0-ProductiononCopyright(c)1982,2002,OracleCorporation. Allrightsreserved.
SQL>connectsys/oracleassysdba
Connected.
SQL>selectusername,passwordfromdba_users;
USERNAME PASSWORD
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.