Yesterday I changed the win7 system, in the database oracle 10g, it was good to start the installation, but this error always occurred during the creation of the database: ora-12546 tns permission denied. This error occurs when the database configuration assistant is used to configure the database. This problem has always plagued me, but it is the error how many times I install it. I couldn't find the information on the Internet, and finally found a s
Topics: There are 10G integers in a file, which are ordered in random order to find the median. The memory limit is 2G. Just write the idea (memory limit of 2G means that you can use 2G of space to run the program, regardless of the memory of other software on this machine).About median: The data is sorted, the position is in the middle of the number. The data is divided into two parts, part of which is larger than the value, and part is less than tha
Votedisk whether it is for RAC (10g Clusterware, 11g GI) is very important, we call it an arbitration disk, when a node in the RAC cluster fails and off the wire off, it is determined whether to kick it out of the cluster, to ensure that the cluster is running properly, When the votedisk is damaged, it can cause the Cluster service to fail to start, the cluster resources cannot be loaded, and the final result is a strike. Then we usually pay attention
Oracle
Table space management has been significantly improved, which can be attributed to a sparser SYSTEM, support for user-defined default tablespace, new Sysaux, and even renaming
How many times have you been hurt by the user's creation of a non-SYS and system segment in the system table space?
Before Oracle9i Database, if you do not specify a default tablespace when you create a user, it defaults to the SYSTEM table space. If a user does not explicitly specify a table space when creating a
Oracle
This article will show you how to install the following contents:
-Oracle 10g (10.1.0) on Red Hat Enterprise Linux Advanced Server 3 (RHELAS3)
-Oracle 10g (10.1.0) on Red Hat Enterprise Linux Advanced Server 2.1 (RHELAS2.1)
-Oracle 10g (10.1.0) on Red Hat 9 (RH9)
-Oracle 10g (10.1.0) on Red Hat Fedora Core 1 (
Mysql|oracle
This is my comparison's installing and getting started with Oracle 10g, PostgreSQL 8 and MySQL 5. This is what I consider the comparison of the ' art for three categories to db:commercial vs. Academe vs. Internet Model. This is a comparison from the view of a new user wanting to install a database to learn. I ' m trying to keep the viewpoint of a home or small business user.Full disclosure:i am strongly biased towards Oracle and fully exp
We've talked about the construction of Oracle 11G Dataguard in the front, and the 10G build is similar. However, Oracle 10G does not support standby openEnvironment:
Role
Host Name
Ip
Database version
Operating system version
Primary
Fdb1
192.168.10.8
10.2.0.1
CentOS 5.11 x86_64
Standby
Fdb2
192.168.10.9
10.
How to import an Oracle 11g backup dat file into a 10g database workaround: Add the target database version number after exportingExport:Execute under SQL Plus: Create or replace directory File_path as ' e:\ ';--creating Export \ Import file storage path (my is on E-drive)Execute inside CMD: EXPDP username/password @ service name Directory=file_path dumpfile= Export Database file name. dat schemas= user name Logfile=baklog.log version= 10.2.0.1.0 (ver
Label:from:http://oracle-base.com/articles/10g/utl_dbws-10g.phpIn a previous article I presented a method for consuming Web Services using a basic SOAP implementation. This article provides similar functionality, but this time using UTL_DBWS the package, which is essentially a PL/SQL wrapper Over Jpublisher.First, download the latest copy of the Dbwsclient.jar file:
Pre 10g:dbws-callout-utility.zip (10.1.2)
10g:dbws-callout-utility-10r2.z
The last book, "Oracle 10g installation in Solaris 10," and now start using QT to compile the Oracle 10g driver! This allows the QT program to be linked to the Oracle database!Environment Variables for Oracle:
Oracle_base=/oracleOracle_home= $ORACLE _base/product/10.0.2
The path of the QT compilation file under Solaris 10:
/export/home/qt-4.3.1/qt-x11-commercial-src-4.3.1
Environ
Label:In 10g, when ORA-00020 occurs, Sqlplus will report "connected to an idle instance" From:Sqlplus Logon Reports ' connected to a idle instance ' when ORA-20 happens in 10g (document ID 1370000.1) Say the more classic, do not translate, direct reprint:Applies To:Oracle server-enterprise edition-version:10.1.0.4 to 10.2.0.5-release:10.1 to 10.2information in this document applies to any platform.SymptomsW
Tencent Micro Cloud Ordinary users more than 10G how to do?
Tencent Micro Cloud
Tencent Micro Cloud Ordinary users more than 10G how to do?
Tencent Micro Cloud yesterday night issued a notice that from January 16 next year, the average user's free storage capacity reduced to 10G, member storage capacity unchanged, the original storage files have more than
Installing Oracle under Linux is a daunting thing, much more complicated than installing the Linux operating system itself. If you are able to successfully install Oracle, you can also learn some Linux technologies. This article describes the method for installing Oracle 10g under Redhat Linux. Here is a description, Oracle 10g G is the abbreviation of grid, meaning for the grid, the current more cutting-ed
This article introduces the usage of different subquery brackets in oracle for 9i and 10g and 11g. if you need this, refer to the following.
This article introduces the usage of different subquery brackets in oracle for 9i and 10g and 11g. if you need this, refer to the following.
This article introduces the usage of different subquery brackets in oracle for 9i and 10g
The following articles mainly introduce the correct handline for Oracle 10g uninstallation. We are familiar with Oracle 10g, which can be called a regular visitor in practical applications, the following articles mainly explain the correct uninstall process. I hope you will get it after browsing.
(1) If the database is configured with Automatic Storage Management ASM, delete the aggregation Synchronization
Due to oracle version problems, the following error will be reported when the default exported tables for 11g cannot be imported to 10g: Connectedto: OracleDatabase10gEnterpriseEditionR
Due to oracle version problems, the following error will be reported if the tables exported by 11g by default cannot be imported to 10g: Connected to: Oracle Database 10g Enterpri
Application of single channel 10G Wavelength Division transmission SystemInternet has become an indispensable tool for Gaga households, because the network era, People's happiness index is more and more high, the rate of Internet broadband is more and more high, the trend determines the network needs to be reformed. In the early stage of the first set of fiber-optic networks, over time fiber resources have been very scarce, in this context, the emerge
Oracle
8.1.7
. 4. Upgrade Oracle 10.2
Oracle provides an update tool that allows you to upgrade the database from a lower version to a later version, and the 8i can be upgraded directly
10g
But 8i must be
8.1.7
. 4 (inclusive) or later versions, 8.1.7.0 is not supported. Oracle provides two upgrade Methods: Wizard upgrade and manual upgrade. The following describes the upgrade process respectively.
1. Wizard upgrade
1. First, you shoul
Contents
I. Hardware requirementsIi. SoftwareIii. System Installation notes4. system preparation before Oracle Installation5. install and configure Oracle6. Upgrade Oracle to patchset 10.2.0.47. Use rlwrap to call historical commands in sqlplus
I. Hardware requirements
1. Memory swap
Minimum: 1 GB of RAMRecommended: 2 GB of Ram or more
Check memory # Grep memtotal/proc/meminfo # grep swaptotal/proc/meminfo
2. Hard Disk
Since centos is installed almost 4 ~ 5 GB, plus Oracle an
Install DDL objects
Log on to sqlplus as an oracle user at the source end and execute the following script:
Run marker_setup
Make sure that the related process of goldengate is closed. Any application using Oracle is closed and no new session is generated. Run the following command:
[Goldengate @ gg1 ~] $ CD/opt/Gg/goldengate/[Goldengate @ gg1 goldengate] $ sqlplus/As sysdba
SQL> @ marker_setup
Marker setup script
You will be prompted for the name of a schema for the goldengate database objects.
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.