oracle dba commands

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up ORACLE data. The exp command can export data from the remote database server to the local DMP file, and the IMP command can import the DMP file from the local to the distant database server. This function can be used to build two identical databases, one for testing and the other for formal use.Execution environment: it ca

The local development environment is win2003 + vs2005 + Oracle9i Testing site environment: win2003 + IIS + Oracle10g The password of the local development database account oracleusera orclepassworda and the database name oracledatabasenamea Test the database account oracleuserb password orclepasswordb and database name oracledatabasenameb. -- Create a database connection (F:/Oracle/ora92/Network/admin/tnsnames. ora) with the following content: # Tnsn

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

Oracle command line is believed to be familiar to everyone. in the daily work of DBAs, Oracle users are often unlocked; the following describes how to unlock an Oracle user in the Oracle command line. Several Simple unlock statements can be used to unlock the user. The following describes how to unlock a user using

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:

Common scenarios: When you back up the Oracle database from the server and restore the Oracle database to a local machine, you will often encounter inconsistency in the character encoding of the database. Common scenarios: When you back up the Oracle database from the server and restore the Oracle database to a local m

/managerThird, create user username identified by password (this step can be omitted if you have already created a user)Fourth, Grant create user, drop user, alter user, create any view, drop any view, EXP_FULL_DATABASE, IMP_FULL_DATABASE, DBA, CONNECT, RESOURCE, create session to Username Fifth, run-cmd-to enter the directory where the dmp file is located,IMP userid = system/manager full = y file = *. dmpOr imp userid = system/manager full = y file

testing Optionssql>Select*From User_users; USERNAME user_id Account_status------------------------------ ---------- --------------------------------lock_date expiry_date default_tablespace-------------- -------------- ------------------------------temporary_tablespace CREATED Initial_rsrc_consumer_group------------------------------ -------------- ------------------------------External_name--------------------------------------------------------------------------------Gd_base theOPEN --December

After oracle is installed, three users are generated by default, which are: SysUser: Super Administrator with the highest permissions. Its role isDBAThe password is:Change_on_install SystemUser: it is a system administrator and has high permissions. Its role isDbaoperThe password isManager ScottUser: common user, password isTiger 1. Create a user Create a new user in OracleCreate userCommand, and you must have the

Common Oracle and SDE maintenance commands-view tablespaces and so on, oraclesde Previously, I reported a data update problem on the site. I thought it was caused by the full table space (the error was written in the previous blog article). Therefore, I remotely checked the server. Generally, I use the Entreprise Manager Console of the Oracle client to view the s

Oracle Trace Files Oracle trace files are grouped into three categories: One is the background alarm log file that records the activity of the background process during startup, shutdown, and running of the database, such as table space creation, rollback segment creation, some alter commands, log switches, error messages, and so on. When a database fails, the

/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 (

Label:1. Connect the óracle: Sqlplus Username/[email protected] [as SYSDBA] Sql>startup Force [Nomount/mount/open/force/restrict] Sql>shutdown [Normal/transactional/immediate/abort] 2. Start the console: Mysqld-nt–install (compressed installation into service) Mysqld-nt–remove (Uninstall Service) net start (stop) MySQL De>mysql-v or Mysql-u root-pde> Set oracle_sid=**Emctl Start DbconsoleHttp://hnjk-oh:1158/emIsqlpuls startHttp://hnjk-oh:5560/isqlplusLsnrctl Start (Stop) (start TNS)DBCA (Start c

I. Installation 1: During installation, you can choose to create a database, which will naturally create a database.2: If the Oracle software has been installed but the database has not been created, you can use this tool to create a graphical structure:Database Configuration AssistantCreate a database Table 6 describes how to start the Oracle Database Configuration Assistant (used to create the Tivoli pr

Label:Before the site feedback a data update problem, to see the feeling is because the table space is full (the error was written in the previous blog essay), so remote to the server to view. The individual is usually viewed through the entreprise Manager console of the Oracle client, but discovers that only the Oracle server is installed on the servers and does not perform the Web login properly. So I wen

1. su-oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface.2. sqlplus/nolog, sqlplus system/manager, or./sqlplus system/manager @ ora9i;3. SQL> connect/as sysdba; (as sysoper) orConnect internal/oracle as sysdba; (scott/tiger)Conn sys/change_on_install as sysdba;4. SQL> startup; start the

1. Su-Oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface. 2. sqlplus/nolog, sqlplus system/manager, or./sqlplus system/manager @ ora9i; 3. SQL> connect/As sysdba; (as sysoper) or Connect internal/Oracle AS sysdba; (Scott/TIGER) Conn sys/change_on_install as sysdba; 4. SQL> s

online or offline,Relocate the data file, redo the log file. 　　 Execute "nomount", then open the control file, confirm the location of the data file and the online log file,However, the data files and log files are not checked for validation at this time. 　　 3. Startup Open dbnameExecute "nomount" first, then execute "Mount", and then open all the database files including the redo log file,This way you can access the data in the database. 　　 4, startup, equal to the following three commandsStar

normally do not start and are used to operate tasks on a regular basis; Oracleoradb10g_home1isql*plus--Can not start, this is the Isqlplus service, used to perform SQL execution on the Web page, 11g has canceled this function; Oracleoradb10g_home1tnslistener--Must be started, this is listening, for remote clients to connect your Oracle; ORACLESERVICEORCL--Must be started, which is the service of the

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