Label:First, the appearance of symptoms 1, using Sqlplus connection Normal 2, C # Use 10g odp.net connection, report the above error Second, the reason 1, oracle11g before the password is case-insensitive, starting from 11G default password case-sensitive 2, the use of 10G odp.net, will automatically convert the password into uppercase Iii. Solutions 1. Enclose the password in the connection string with quotation marks so that the password does not tu
Tags: style io strong ar for art SP on CBefore Oracle 11g it was a bit of a hassle, after 11g, it was very simple. Now has the function business is, has a test table records is the document approval information, the ID is the approval information primary key, SHEET_ID is the foreign key, is the document Id,remark for approves the content, on the front-end list page, wants to see this document all approval i
The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered that the PL/SQL developer does not recognize the Oracle Hom and OCI Libaray. To enter PL/SQL
by the system after the user's operation, so there is no need to adjust the temporary table space, but when the concurrent users are very much and the operation is more complex, There may be a shortage of temporary table space. At this point, the database administrator can add temporary files to increase the temporary table space.If you need to add temporary files, you can use the Add tempfile clause.If you need to modify the size of the temporary file, you can use the Resize keyword.You can al
-Firewall-1-INPUT -m state –state NEW -m udp -p udp –dport 177 -j ACCEPT
:wq! #Save exit
Service iptables restart #restart
Gdm-restart #restart
Shutdown -r now #restart the system
Second, install Xmanager on the Windows client system
1. Download and install Xmanager Enterprise 3
Http://www.onlinedown.net/soft/32684.htm #英语原版
Http://www.downxia.com/downinfo/19164.html #汉化包
2. After downloading the installation software, open Xmanager Enterprise
3, then open Xbrowser, as shown below:
I
Oracle 11g-oracle Startup and shutdownTarget:1. Understand the sequence of reading parameter files in oracle-11g startup;2. understand four states of Oracle;3. Master the method of State transformation. 1. Read the parameter file in startup9i before, only static parameter file Pfile file;9 I started with the introduction of the dynamic parameter file SPFile file. 11g
Label:The following statements can be used to query the 11g alarm log storage path:--Show the location of the Diagnostic_dest1.show parameter diagnostic_dest; --Querying the directory of XML files2.select value from V$diag_info where name= ' diag Alert ';--Querying the directory of text files3.select value from V$diag_info where name= ' diag Trace ';4.show parameter background_dump_dest; 5.select value from V$parameter where name= ' background_dump_de
Label:About audits: 11g By default, the auditing option is enabled, and the default value of the Audit_trail parameter is DB, which indicates that the audit data will be recorded on the sys.aud$ Audit Dictionary base table in the database. In Oracle 10g, the default value of this parameter is none, which means that auditing is not enabled. Oracle claims that the audit logs enabled by default do not adversely affect the performance of most product data
Oracle EM Grid Control is a centralized monitoring and management tool for Oracle databases, operating systems, and other applications. His developers gradually extended it into an Enterprise Console, or even replaced the network operation console.
We have encountered many strange problems in the installation and use of the 10g version. By now, it has grown to 12c.
Here we select the 11g version for installation to manage the operating systems and dat
Before Oracle 11g, adding a column to a large table and setting the default value would be a tragedy. sometimes you have to select the online redefinition function to achieve this requirement. adding new columns and setting the default values in 11 GB only allows you to modify the data dictionary to achieve this function, greatly improving the efficiency.Add 10g columns (default)
SQL> select * from v$version;BANNER----------------------------
Installed Ubuntu 12.04 64bit, want to install Oracle 11GR2 on the above, find a lot of documents on the Internet did not succeed, and finally fully reference the Mordicusetcubitus article.Key points for a successful installation: Install additional packages, which handles the wrong method during link.Original: Http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bitsBefore startingSince Release 11.10 It is mo
spaces around the equal-to (=) character.after we set the Ingroecase parameter here, the ORAPWD command does not work. So, as you can see, IgnoreCase is a truly new feature in Oracle 11g that can be used in Oracle 11g. This parameter is used to set whether the SYSDBA or Sysoper permissions are case-sensitive when logged on through a password file.two. Oracle 11g2.1Description2.1.1 Sec_case_sensitive_logonP
The ORA-00845 is prompted when the database is started: MEMORY_TARGETnotsupportedonthissystem (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle11g
The ORA-00845 is prompted when you start the database: MEMORY_TARGET not supported on this system (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle 11g
1. The ORA-00845: MEMORY_TARGET not supported on this system is prompted when the database is start
In the use of Oracle databases, Backup recovery is the most critical. When the database fails, it can be restored in a timely manner to reduce unnecessary losses. Next I will briefly introduce the import and export of databases, solutions, tables, and the role of things in the Process of use.1. Export data tables[Oracle @ CentOS ~] $ Exp scott/system tables = t file = '/home/oracle/t. dump 'Log = '/home/oracle/t. log'; -- export t table data in scott (tables = can write multiple tables, full = y
How to handle EM key garbled characters in Oracle 11g
Today, I used a Mac to connect to the VMware Fusion virtual machine database. I suddenly wanted to use EM and suddenly found that the buttons were garbled. For example:
Analysis: To solve the problem, find the correct font.
Solution:
1. Find a font file such as simsun. ttc on Windows machine c: \ windows \ fonts.
2. Create a folder named fallback in the $ Oracle_home/jdk/jre/lib/fonts directory.
[
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.