Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the Internet. At that time because of busy also do not do other things, so has not been in charge of it. Make up for the last Internet café. The two days are free. So
you are granting permissions directly to a user, you must update each user account individually.
After you complete the preceding steps, you can configure your PHP application to use the Cms_user account for all database connections that are requested by anonymous Web users, and use the Cms_editor account for connections raised by password-protected administration pages. Now, even if a public Web form is attacked, the impact on the database will be minimal because the Cms_user account has only
Conclusion
Now that your database has been started and running, you can start to use ORACLE 10G. It is best to start using Oracle Enterprise Manager because it is completely rewritten and uses a Web-based interface. If you are not sure where to start,OracleConcept GuideAndDBATwo-day Quick Start GuideIt will help you familiarize yourself with the new database. OTN
First select your system version, 32-bit system Select 32-bit, 64-bit system can use 32-bit can also use 64-bit, recommended 64 bits! Oracle Database 11g 2nd edition (11.2.0.1.0) for Microsoft Windows (32-bit)Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zipHttp://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2
Tags: Database next port win Win64 DB instance data one1. Download 11g on the Oracle website first Oracle Database one -2nd edition (11.2.0.1.0) Standard Edition, Standard Edition 1, and Enterprise Edition Oracle Database, version 2nd (11.2.0.1.0) for Microsoft Windows (x64) : Http://download.oracle.com/otn/nt/oracle11
The previous time to connect to the Oracle database remotely, but do not want to complete the installation of OracleClient on their own computer, so to the Oracle website to download the lightweight Clientinstant client.This thing does not have a graphical interface, all rely on sqlplus remote connection server, so does not occupy the place, just satisfies me to pursue "simple is good" the obsessive-compuls
1. Oracle Installation
Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html.
2. Use the command line sqlplus to connect to Oracle
(1) Check the listening status
C: \> LSNRCTL status
LSNRCTL for 32-bit windows: Version 9.2.0.1.0-production on 2005 11:01:01
Copyright (c) 1991,200 2, Oracle Corporation. A
It takes a day and a half to resolve the client connection to the Oracle database on the server side, unable to connect the problem. Ora-01034:oracle Not available (ORACLE does not exist), ora-27101:shared memory realm does not exist analysis:A few days ago you can also connect to the database, but yesterday, the local no reason to connect to the server database.
How to uninstall the "hidden oracle" software installed after an error is reported, and the hidden oracle
**************************************** ******************************** **************
Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.
Please leave a messag
Oracle Server entry and oracle management routineI. Common oracle database management toolsOracle Universal Installer (OUI): used to install, upgrade, or delete Software ComponentsOracle Database Configuration Assistant (DBCA): a graphical user interface tool that interacts with OUI. It can also be used independently to create, delete, or modify databases.SQL * P
What is a relational database? Oracle database architecture, Oracle cluster introduction, and oracle Architecture
What is a relational database?
Databases based on Relational Models.
What is a relational model?
Use rows and columns in a two-dimensional table to maintain the data model.
Oracle database architectur
Tags: style blog http ar file Data SP Div 2014 1 installation Knowledge of Oracle (oracle10g and oracle11g version differences ) :A the installation directory should not have Chinese and white spaceB oracle10g support winxp does not support win7,8 and vista;oracle11g supports all versions2 oralce Server: comprised of Oracle instances and Oracle datab
(1) Download Oracle 10g software on Oracle official website at: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_ Production_db.zip, can directly copy in the Thunder and other download software directly to download.(2) then modify the following files, the first one is the Refhost.xml file under disk1\stage\prereq\db\ Add the following conten
1. Download Oracle client on official website (login required)http://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpmhttp://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient11.2-sqlplus-11.2.0.4.0-1
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R2 11.2.0.4. The operating system version is Oracle
ALL_TAB_PRIVS_RECD represents the permissions on an object that the user is public or grantee
Dba_col_privs all authorizations on the database column
Dba_role_privs show roles that have been granted to a user or other role
Dba_sys_privs system permissions that have been granted to a user or role
Dba_tab_privs all permissions on a database object
ROLE_ROLE_PRIVS displays the roles that have been granted to the user
ROLE_SYS_PRIVS displays system permissions granted to users through roles
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.