Several commands required to understand the Oracle physical system 1. display the parameters related to the rollback segment ChenZw> show parameter undo name type value =---------------- undo_management string AUTOundo_retention integer 900undo_tablespace string UNDOTBS1 2. Display SGA related parameter ChenZw> show parameter sga name type value -------------------------------------- ----------- ----------
Common Oracle commands and recently used Problems
[Problem and background]1. delete a table? A library?Drop table table_name;Drop table database_name;2. Delete all data of a user?It is best to stop the database first and shutdown immediate; startup to ensure no user connectionOr select Sid, serial # from V $ session where username = // 'username // '; query the connectionSid serial #--------------
Use the expimp command in Oracle to quickly import and export data [export data with exp]: 1. Export the database TEST completely. Use the User Name system Password manager to export data to D: daochu. in dmp, expsystemmanager @ TESTfiled: daochu. dmpfully2 exports the tables of system users and sys users in the database to expsystemman.
Use the exp/imp command in Oracle to quickly import and export data [e
/auxfiles/aux_2.f ';CONFIGURE Auxname for datafile 3 to '/oracle/auxfiles/aux_3.f ';CONFIGURE Auxname for datafile 4 to '/oracle/auxfiles/aux_4.f ';-CONFIGURE auxname for datafile 1 CLEAR;CONFIGURE auxname for datafile 2 CLEAR;CONFIGURE Auxname for datafile 3 CLEAR;CONFIGURE Auxname for datafile 4 CLEAR;Rman of the format in the format %Number of copies of%c backup slices%d database name%d The day ordinal (
Oracle Import and Export Command Parsing
This article introduces the import and export of Oracle Data IMP and exp commands, and describes the corresponding parameters.
Drills to deepen understanding.At last, the article discusses the problems that may occur when using these two commands (such as insufficient permission
commands
startupnomount
alterdatabasemount
alterdatabaseopen
5. startup restrict
Constraint-based startup
This method can start the database, but only allow access by users with certain privileges
When a non-authorized user accesses the service, the following prompt is displayed:
ERROR:
ORA-01035: Oracle only allows users with restricted session Permissions
6. startup force
Forced start met
I,OracleTracking FileThere are three types of Oracle tracking files:
One is the background alarm log file, which recordsDatabaseActivities of background processes during startup, shutdown, and running, such as creating tablespaces, creating rollback segments, some alter commands, log switching, and error messages. When the database fails, you should first check the file, but the information in the file is
Profiling oerr commands in Oracle
The commands in Oralce are very rich. The oerr command is a good auxiliary tool. Many error codes that do not seem to have an eyebrow purpose can help DBAs quickly identify the cause of the problem, we don't need to remember the ORA errors at all, unless they are completely inseparable from your work.
Most of the
1. Start the Oracle database:Switch from root to Oracle user access:Su-oracleEntering the Sqlplus environment, the Nolog parameter indicates no login:Sqlplus/nologLog in in Administrator mode:Sqlplus/as SYSDBAStart the databasestartup;Stopping the databaseShutdown ImmediateRemote Connection DatabaseSqlplus/nologConn Sys/[email Protected]:1521/orainstance as SysdbaYou can also run directly:Dbstart# Start the
Oracle commands in windows
It is often necessary to use a database. If you want him to start the database on his own, it will be too slow to start the database.
1. enable:
Enter cmd in the running state, enter the console, and press lsnrctl start to enter, prompting that the listener is successfully started.
Net start OracleServiceORCL.
2 close
Enter cmd in the running state, enter the console, lsnrctl sto
The following articles mainly introduce common Oracle commands, including Oracle data types, views, and instances. If you are a beginner in common Oracle commands, if you know more about the applications of common Oracle
I. Viewing data filesSql> select name from V$datafile;NAME--------------------------------------------------------D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01. DbfD:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01. DbfD:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01. DbfD:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01. DbfD:
Tags: self-organizing commands common in OracleOrganize your own commands that are common in Oracle:ORACLE11G has not supported Isqlplus anymore. Built-in Oracle SQL developer1-----User Multiple Login error, Locked:ALTER USER username account UNLOCK;2-----Modify User password:alter user system IDENTIFID by manager;3-----Create/delete users:Create user Lisi identi
This is often the case in Oracle 8i, that is, Oracle runs operating system commands during storage, generally, Oracle Enterprise Manager can be used to set jobs. however, due to the lack of flexibility in the setup of OEM jobs, the set job parameters are fixed ..
In practical applications,
Remote Import Backup command: Imp cpqlzf/cpqlzf@cpql20080505 file=d:\data\20080505xzfw_new.dmp fromuser=sa touser=cpqlzf ignore=y notes: The CPQLZF is the table space name and the login password; cpql20080505 is the database SID name, the backup database path is behind file, and the Fromuser value is the user name when the database is backed up; the Touser value is the tablespace user name;------------------ -----------------------------------------------------------------
: Startup Pfile=e:\oracle\admin\oradb\pfile\init.ora8, startup EXCLUSIVE============================================There are three ways to start:1. Shutdown normalShut down the database in the normal way.2, Shutdown immediateClose the database immediately.Shutdown immediate is executed in SVRMGRL and the database is not shut down immediately.Instead of shutting down (terminating the session, freeing the session resource) after
V$instance;View current instance Name: Select instance_name from V$instance;Select name from V$database;To query the host name where Oracle resides:Select Host_name from V$instance;Create User: Itmuser identified by password;Show current users: Show user;Switch User: conn Itmuser/password;Query Oracle All users: Select username from dba_users;To view the file path for a user tablespace:Select name from V$d
Summary of common oracle commands
Here, I would like to summarize some common oracle commands that are often used at work, but sometimes they are always forgotten and hope to be useful. The command is as follows:
Cmd or sqlplus connect to oracle
Sqlplus/nolog press ENTER
Con
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.