1. Installing oracle11g1.1Password is the database login password, the student party with the password set simple point, violating the Oracle password setting rules can continue the next step1.2Oracle defaults to three account users Scott (normal user), need to install the interface when the lock is canceled, followed by password. SYS User: Super administrator, highest privilege, and its role is DBA. The default password is Change_on_install. has perm
responsible of resolving IN-DOUBT transactions when Oracle was participating in distributed transactions with M Icrosoft Transaction Server.
List of programs:From the Start menu, you will find the newly installed Oracle program:These procedures include:
Start and Stop Database is used to control the Oracleservicexe service
Backup and Restore Database is scripts for backing up or restoring
OBJECT_NAME format a10;
SQL> col OBJECT_TYPE format a10;
SQL> col STATUS format a10;
SQL> SELECT OBJECT_NAME, OBJECT_TYPE, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'P _ test ';
OBJECT_NAM OBJECT_TYP STATUS
------------------------------
P_TEST PROCEDURE VALID
SQL> ALTER TABLE TEST ADD (NAME VARCHAR2 (30 ));
SQL> SELECT OBJECT_NAME, OBJECT_TYPE, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'P _ test ';
OBJECT_NAM OBJECT_TYP STATUS
------------------------------
P_TEST PROCEDURE VALID
Use adrci in Oracle 11g to view alert logs
1. Know adrci
This command can view error messages and logs, which are provided to us along with the change of the 11g trace directory location. This tool can not only edit logs like vi. You can also view log files like tail-f.
It can also be used across platforms and windows.
-------------------------------------- Split
Tags: CTE height script CEP Select page First Thunderbolt oracle11gIt would be a hassle to go straight to step b. A. Because this is the blog I wrote after I installed it, so the first step is to uninstall Odtwithodac1120320_32bit 1. 2. 3. 4. To complete, close the window. ======================================================================== B. VS2010 vs2013 vs2015 cannot connect to Oracle 11g 64bit A
= 1048586Run the command to update the kernel parameters:Sysctl–p4. Add the following data to the/etc/security/limits.conf file for the kernel limit of the current user (assuming the user name is ZHS)ZHS Soft Nproc 2047ZHS Hard Nproc 16384ZHS Soft Nofile 1024ZHS Hard Nofile 65536ZHS Soft Stack 102405. View the/etc/pam.d/login and add the following lines (with no increase):Session Required Pam_limits.soAlso check the/ETC/PAM.D/SU, without the followin
from the client at the same time, and no longer has any relationship with the newly established session.The visible listening process plays a role.After that, even if the listener stops working, the established session is not affected at all.(2) Local Listener programThe local listener is completely different from the network listener, it does not require a network protocol stack, and the detailed implementation relies heavily on the underlying OS.In Oracle
Tags: Session set EPO BSP Ongl important tips title IDTJob required, installed Oracle 11g, an error occurred while importing the backup data on other machines:IMP-00019: Deny row due to ORACLE error 12899IMP-00003: Encountering ORACLE error 12899ORA-12899: Column "ZHENG". "
When Oracle 11G exports data using EXPORT, the empty table cannot EXPORT the new feature in 11G R2. When the table does not have data, no segment is allocated to save space.Solution: insert a row and then roll back to generate a segment. This method inserts
Learning Oracle is a complex and tedious process. In front of the vast array of official Oracle data, new features, MOS data, and a variety of Internal knowledge, we always feel powerless and overwhelmed. However, this is often the pleasure of our constant persistence, accumulation, and pursuit.In
Oracle 11g InstallationFirst, the Environment preparation
Dividing area
/15000M/tmp 4096M/boot 100MSwap 4096M/u01 remaining space2. Change host name, IP address3. Install the PackageThen the Linux system needs to prepare the environment for Oralce to end here, the following is installed after the system installation of Oracle4. Turn off SendMail to speed up system startup5. Modify the Host tab
I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and delete the old user! Next we will introduce this new feature in the 11g rac environment!
1. Create a test user xxx and
Tags: work company map okay data-fix for me detail Docker installationForeground: Nothing wants to play Linux, think of the future can deploy their own web project up, and then I want to install an oracle ... I didn't know anything about Linux before, only that the company's projects were deployed on top, and then it took nearly five days from the loading system to the completion of
Today, a friend asked me why 11g exp files cannot be imported into 9I? Due to the incompatibility of exp/imp tools, when importing a database of a higher version to a lower version, you need to use the exp/imp tool of a lower version for import and export. A friend used 9i exp to export 11G data and then import imp to 9i. The import is normal. However, I reported
Oracle 11g uses DML Error Logging to avoid bulk insert failure
Use DML Error Logging to avoid bulk insert failureIf an error occurs when an insert statement with a subquery is used to load data. the system terminates the statement and rolls back the entire operation. this operation consumes a lot of time and resources. if the insert statement is used, DML Error L
Discovery PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the
Oracle oinstall 30416896 Jan 22:05 temp01.dbf-rw-r-----1 Oracle Oinstall 110108672 Jan 24 22:05 UNDOTBS01.DBF-RW-R-----1 Oracle oinstall 26222592 Jan 22:05 users01.dbf[[emailprotected] prod]$ Exit[emailnbs p;protected]> ALTER DATABASE Open;alter database Open*error at line 1:ora-03113:end-of-file on communication channelpr Ocess id:2951session id:125 Serial Numb
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.