Discover oracle developer suite 10g, include the articles, news, trends, analysis and practical advice about oracle developer suite 10g on alibabacloud.com
As we all know, it is not easy to migrate a database from a higher version of Oracle to a lower version of oracle. If you directly use the SQL developer tool, you may not be able to complete the migration successfully (errors may occur more or less in the middle ).
Exp and IMP are applicable to Oracle data copy and bac
to Scott/tiger login on it can be .....User name/password for Oracle 10g default installationUsernamePasswordDescriptionSee AlsoCtxsysCtxsysThe Oracle Text accountOracle Text ReferenceDbsnmpDbsnmpThe account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the databaseOracle En
1. Start to install and configure Java. If Java is not installed on your computer, you can download the Java installation file from Sun Developer Network.
(1) install JavaC:/> java-versionjava version "1.6.0 _ 13" Java (TM) SE Runtime Environment (build 1.6.0 _ 13-b03) Java HotSpot (TM) client VM (build 11.3-b02, mixed mode, sharing) sets JAVA_HOME and CATALINA_OPTS environment variables C:/> echo % JAVA_HOME % C:/Program Files/Java/jdk1.6.0 _ 13
(2)
Instant Client
Download "Instant Client package-basic".On Linux, you should also download the "Instant Client package-sdk".
Apache HTTPD Server
The PHP community still recommends Apache 1.3
Php-php Hypertext Processor
version 4.3 or higher
Enable the PHP OCI8 extension on Windows
The Instant Client binary is a complement to PHP's Windows pre-built binary file.
Download the PHP binary compressed file (not the installer version) and Apache. Inst
When Oracle database is created, a series of default user and table spaces are created
User name/password for Oracle 10g default installation
Username
Password
Description
See Also
Ctxsys
Ctxsys
The Oracle Text account
Through all kinds of hardships, finally the work of 32 Oracle 10g loaded to 64-bit windows7 on the. Do not ask me why I do not install 64 Oracle or Oracle 11g, which is the only reason for the job needs.
Encountered a variety of problems, bypassing the detour will not wordy, directly to the success of the steps.
Oh ~ ~
support Oracle 9i
Error: text. The table or view does not exist. Select owner, program_name from all_scheduler_programs. Some similar errors. Oralce9i does not support the method of creating a new job by right-clicking "new" in PL/SQL developer 8.0 jobs.
The following text comes from the network information:
PL/SQL developer 8.0 only supports new jobs cre
Label:http://blog.csdn.net/pan_tian/article/details/8016318 Oracle Developer Suite (ODS) 10g was developed prior to Windows 7/vista, and some of the problems, common problems, and workarounds in the installation process under Win7/vista are as follows: Issue 1:checking operating system version:must be 5.0, 5.1 or 5.2.
Oracle Database 10g Performance Tuning tips and techniques is recommended. For Oracle performance test, diagnosis, analysis, and optimization, see!
Chapter 2 Basic index principles (beginner developer and beginner dBA). For Oracle index optimization, refer!
Chapter 4 t
Summarize and organize yourself:
1. Check the registry, Oracle_Home under HKey_LocalMachineSoftwareOracle. If not, change it to correct;
2. uninstall ODP. net (or uninstall ODT. net, ODT contains ODP, ODT is. net is an integrated plug-in for connecting to and browsing oracle databases, and provides drag and drop operations on oracle databases, similar to. net for the resource manager of SQL Server );
3.
the requirements, perform the following steps to check the installed Linux version and the installed suite.
Review Project Command/method recommendation values
Linux version #cat/etc/issue ES 3
Packages Installed #rpm-Q package_name installation required (listed in the table above)
Here we have a comprehensive review of the hardware and software environment required to install Oracle
1. Because oracle 10g is not compatible with win7 for the moment, we can modify some files in the installation software to achieve the installation goal.A) open the path "\ ORACLE10G_client \ stage \ prereq \ client \", find the refhost. xml file, open it, add the following code to it, and save it.Copy codeThe Code is as follows: B) Open the "\ ORACLE10G_client \ install" path, find the oraparam. ini file,
Because I do not have Oracle installed locally, using PL/SQL Developer Remote Connection server requires the following configuration:1. Software PreparationOracle Client: Instantclient-basic-win32-11.2.0.1.0.zipPL/SQL Software: Pl/sql_developer.zip2.oracle client decompression, placed in the D:\OraclerProgram\instantclient_11_2,Also new file D:\OraclerProgram\ins
1. Because Oracle 10g does not have a Win7 compatible version for the time being, we can achieve the installation target by modifying some files in the installation software.
A) Open the "\oracle10g_client \stage\prereq\client\" path, locate the Refhost.xml file, open it, add the following code to it, and save it.
Copy Code code as follows:
B Open the "\oracle10g_client\install" path,
I installed oracle9 first and PL/SQL Dev again. Then I enter the user name and password to connect to the server.
Then I installed odac 11.2 release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio. When I joined PL/SQL Dev, an error was returned.
Oracle 10g ORA-12154: TNS: cocould not resolve the connect
1. Because oracle 10g is not compatible with win7 for the moment, we can modify some files in the installation software to achieve the installation goal.
A) open the path "\ ORACLE10G_client \ stage \ prereq \ client \", find the refhost. xml file, open it, add the following code to it, and save it.
Copy codeThe Code is as follows: B) Open the "\ ORACLE10G_client \ install" path, find the oraparam. ini file
addition, you can also use the following job (the job should be created under the same user as the table ):Create or replace procedure syncIsBeginExecute immediate'Alter index myindex rebuild online' |'Parameters (''sync '')';Execute immediate'Alter index myindex rebuild online' |'Parameters (''optimize full maxtime unlimited '')';End sync;/
[2]The ORACLE tutorial is: Oracle9i full-text retrieval technology devel
1 GB, we do not recommend 11 GB memory,
Get a 10g or 9i game by yourself,
Software Platform
The Oracle 11gr1 database is used,
Visual Studio 2008,
Then Oracle Developer Tools for Visual Studio. NET,
OS: win7 flagship edition (preferably server or XP)
It is installed with the latest version compatible with
command:
1) svrmgrl start the Service Manager
2) connect internal logs in as internal
3) startup open the database6. ORA-12560: TNS: protocol adapter error (stubborn)
Cause: unknown.
Solution: Go to "Windows Task Manager", kill oracle.exeand oradim.exe processes, write your own ora_startup.bat, and execute it!
PS:
1. My ora_startup.bat:
Net start OracleOraHome81TNSListener
Net start ORACLESERVICEORADB
Svrmgrl is generally not used, but sometimes it is indispensable. For detailed steps, see ste
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.