oracle learning - Go lay out the classroom teacher network First, part of the database language 1. SQL language: the standard language for relational databases 2. PL / SQL: Procedural language Procedural Language 3. SQL * Plus: simple statements, the
Recently many netizens proposed monitoring configuration related issues, the customer terminal (Client) can not connect to the server side (Server). This is configured on the listener to make a brief introduction, and Tichu some customers connect to the s
In Windows, install Oracle 10g, in the WINDOWS service after the installation of 5 service items, as follows: The following services in these five items do an analysis: 1. OracleDBConsoleorcl service is to start em, if OracleDBConsoleorcl not start, oracl
In the Oracle database is running, DBA should run the database log and table space usage monitoring, early detection of problems in the database. One, Oracle log file monitoring warning Oracle in the running, in the warning log file (alert_SID.log) record
Format SQL> set line 120 SQL> col PROGRAM for a20 SQL> SET PAGESIZE 25 1. Find ORACLE background process SQL> select spid,username,program,background 2 from v$process 3 where background='1'; SPID USERNAME PROGRAM B ------------ ----------
Oracle database maintenance In the Oracle database is running, DBA should run the database log and table space usage monitoring, early detection of problems in the database. One, Oracle alert log file monitoring Oracle is running, in the warning log file
Solve the "local computer oracleorahome92managementserver service started and then stopped" problem Bahrain Oracle, has also been equipped with the local Oracle Management Server, but in My Computer - Control Panel - Administrative Tools -
Uninstall oracle9i methods: In win2000 Enterprise Edition operating system, uninstall Oracle 9i: 1, stop all Oracle services 2, delete all the registry entries for Oracle (1) HKEY_LOCAL_MACHINE \ SOFTWARE, delete the Oracle directory (2) in the HKEY_
SQL> Select count (*) from v $ session where status = 'ACTIVE'; COUNT (*) ---------- 20 SQL> Select count (*) from v $ session; COUNT (*) ---------- 187 SQL> show parameter processes; NAME TYPE VALUE ---------------------------------
top oracle linux platform not start automatically, you need to manually, as follows (A) In command mode following the first start the listener: #> Lsnrctl start This command runs longer need to wait, after the success of such a message will appear
Format SQL> set line 120 SQL> col PROGRAM for a20 SQL> SET PAGESIZE 25 1 Find the ORACLE background processes SQL> select spid,username,program,background 2 from v$process 3 where background='1'; SPID USERNAME PROGRAM B ------------ -----
Oracle database maintenance DBA Eight Points for Attention Note: This article is from the hopes of finding the Internet, only to be recorded in this Description: DBA should run the database log and table space usage monitoring, early detection of problems
In the Oracle database is running, DBA should run the database log and table space usage monitoring, early detection of problems in the database. One, Oracle alert log file monitoring Oracle is running, a warning will be in the log file (alert_SID.lo
Windows on the end use orakill thread oracle session oracle in the windows platform as a single process using multi-threaded implementation, unix / linux on the server process on the windows is actually a thread. We know that in the unix platform, so
In the actual work, the database administrator (DBA) requires frequent connection to the database regularly to inspect, view the number of sessions established with the database is not normal, if the establishment of too many connections, it will con
oracle dba 命令集合，非常的多啊，好东西。 1 运行SQLPLUS工具 sqlplus 2 以OS的默认身份连接 / as sysdba 3 显示当前用户名 show user 4 直接进入SQLPLUS命令提示符 sqlplus /nolog 5 在命令提示符以OS身份连接 connect / as sysdba 6 以SYSTEM的身份连接 connect system/xxxxxxx@服务名 7 显示当然用户有哪些表 select * from tab; 8 显示有用户名和帐户的
For some reason, need to change the server machine name, reboot, modify the oracle listener configuration file, but still can not start service on google to find the N kinds of programs, were unsuccessful. Wu Nai, had to reinstall the oracle, install
1, JDK1.4 environment variable configuration: CLASSPATH: .; C: \ j2sdk1.4.2 \ lib \ dt.jar; C: \ j2sdk1.4.2 \ lib \ tools.jar; JAVA_HOME: C: \ j2sdk1.4.2 Path: d: \ oracle \ oracle90 \ bin; d: \ oracle \ oracle90 \ Apache \ Perl \ 5.00503 \ bin \ msw
Acquaintance oracle11g The first use of oracle, use the following simple steps: 1 install oracle Just install the oracle client version of the service, if you install both oracle server and client versions, note that the environment variable path, whose p
Double click a button to install - Java installation program production Title: A double-click the Run button to install - Java installation program made of: Jason Du Time: 2009-3-23 Original: http://www.blogjava.net/javapro/archive/2009/03/24/JavaApp
Running program in the background: 1. Nohup <command> &; eg  + Stopped startWebLogic.sh [oracle@oardc-vm15 admin]$ nohup startWebLogic.sh & 2. <command>, Then interaction with <command> such as provide user and password.
Because Oracle is very large, I use the green version of the Oracle PL / SQL, Tools -> Export table -> oracle sql, but that point of the Export button is not gray, Checked, that is: Above the export file with an input box Export Executable not
正在看的ORACLE教程是:Oracle9i在Win2k环境下的完全卸载。1、删除Oracal在注册表中的主项： regedit.exe->LocalMachine->Software->Oracle 2、删除Oracal服务： regedit.exe->LocalMachine->System->CurrentControlSet->Service->Oracle 3、删除Oracle事件日志： regedit.exe->LocalMach
nmefwmi.exe stopped working and was closed http://pkca400.blogspot.com/2009/06/nmefwmiexe-stopped-working-and-was.html I installed Oracle 11g last week on my laptop (Windows Vista Business Edition) and had no issues except a reduction in my machine's
oracle 10 services start TNSLSNR.exe will occupy a 8080 port, when, what needed to change the port: Package provided with the oracle: - The HTTP / WEBDAV port from 8080 to 8081 change SQL> call dbms_xdb.cfg_update (updateXML (dbms_xdb.cfg_get (), ...
Running asp.net in IIS when the show can not run the application view event viewer found error: aspnet_wp.exe (PID: 908) stopped unexpectedly by the Internet, said the need to install IIS and then install. Net or IIS group will be as relevant Parts a ...
[Size = medium] target: as the installed package has been installed next qq can be as simple as can be unloaded, claims process starts automatically, no separate installation of JRE, Just writing this solution, I really hate every means Microsoft. Hey hel
For Java for desktop applications, the more annoying is to install the deployment, the client is installed jre, jre version of the problem, jre where to download, how to start your Java application jre? Do not say that people new to computers, even more f
Today, I start their own native ORACLE. After unexpectedly found himself TNSListener started automatically stopped. Did not quote any error. Later thought, these days the only change is to change the machine name. In the original ORACLE D: \ soft \ o
oracle 10 services start TNSLSNR.exe will occupy a 8080 port, this time, ports need to change it: Oracle package provided by: - The HTTP / WEBDAV port from 8080 to 8081 change SQL> call dbms_xdb.cfg_update (updateXML (dbms_xdb.cfg_get (), '/ X
Today start their own native ORACLE. Actually found TNSListener started automatically stopped after himself. Not reported any errors. Was thought, these days the only change is to change the machine name. In the original ORACLE D: \ soft \ oracle9i \
oracle 10 services a start TNSLSNR.exe will take 8080, when, what needed to change the port: Oracle package provided by: - The HTTP / WEBDAV port from 8080 to 8081 change SQL> call dbms_xdb.cfg_update (updateXML (dbms_xdb.cfg_get (), '/ Xdbcon
Executive stmt.execute (sql); when walk, has been parked, probably due to the operation of Oracle database need to submit, if not submitted before the operation, then the operation may lead to the back has been waiting for.
TNSListener service failed to start, in the service console to start after the refresh, then automatically return to the stop state, and no reports of any errors. And that SPL PLus also normal use. http://www.mscto.com Solution: Method 1. Directly mo
Today launched Oracle TNSListener services stop automatically refreshed to the Internet to find to find a cause, it was my turn over the machine name. Although not a big problem, but write down or record what ah. Want to encounter the same problem wi
On the ora-12505 ORACLE error, and connectivity solutions and related information Recently, I use jdbc to connect oracle 9i database, the following error occurred: Error occured while trying to connect to the database Error connecting to database: (using
This assumes Oracle817 installation files are copied to the directory% ORACLE_INSTALL% When the direct double-click the directory setup.exe, found it impossible to start the installation process. The following is a solution: Modify the following two ...
These days in the windows virtual machine tossing rac, there were many problems. Oh, what a first record. administrator must set the password, note that setting the screensaver time longer, vmware version select gsx, or not to cluster. Crs bottles and pai
Eclips prompted by installation oracle jvm version is too low after the issue today is installed on your machine oracle9i Restart eclipse when prompted JVM version is too low, the installation was no problem before the oracle, and, this machine is al ...
JDK with which tool is written in JAVA, which itself also needs to run a JRE, such as C: \ Program Files \ Java \ jdk1.5.x \ directory under the JRE. The C: \ Program Files \ Java \ directory under the JRE is used to implement our own programs written in
In the $ ORACLE_HOME / jdk / jre / lib and $ ORACLE_HOME/jre/1.4.2/lib / directory has a variety of character sets the font configuration file, the Chinese character set replace the default font.properties Then clean up cache, cache directory where $ ...
1 to 2 NT's Administrator login through Control Panel - "service stopped all ORACLE services 3, open the registry (REGEDIT command), delete the HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE 4, open registry in the HKEY_LOCAL_MACHINE \ SYSTEM \ Curr ...
Want to write about in WINDOWS7 RTM 7600 X64 install the oracle client and the successful experience of the past few days PLSQL DEVELOPER installed WIN7 X64, because the work needs to be installed JAVA, ORACLE CLIENT, PLSQLDEV the like 2 days, and ha ...
If the installation, our system environment variable set in Chinese environment, then there would be no problem. The root of the problem is that installation, JDK / JRE automatically select the character set. In the $ ORACLE_HOME / jdk / jre / lib and $ O
In this paper, an Oracle Job task and case diagnosis, analysis of its causes and solution process, from the inside reveals the Oracle Job Scheduling and internal timing mechanism. R & D personnel, and the environment received the report, the database
First, connect to the MySQL database 1. Download mysql's jdbc driver, http://dev.mysql.com/downloads/ 2. Extracting zip file (I downloaded version is mysql-connector-java-5.1.5), we have to use the mysql-connector-java-5.1.5-bin.jar file. / ** Method
Original: http://samwong.javaeye.com/blog/847936 1, the Administrator Login 2, through the Control Panel - "service stopped all ORACLE services 3.Universal Installer uninstall all Oracle products (or the installation disc to install when there a
oracle learning - Go to the classroom teacher set out road network First, part of the database language 1. SQL language: the standard language for relational databases 2. PL / SQL: Procedural language Procedural Language 3. SQL * Plus: simple stateme
1. Install JDK http://java.sun.com (1) after downloading the BIN file can be directly executed # Chmod 755 jdk-1.6.0_23-linux-i586.rpm.bin #. / Jdk-1.6.0_23-linux-i586.rpm.bin This step is completed, will generate jdk-1.6.0_23-linux-i586.rpm file is insta
Today suddenly the task of learning oracle database, it began, but found a lot of information online, or not fully, or that is a lot, we all copy plus copy, I'll try this side of distribution transformer, the temporary record under the plan for the fu