oracle linux commands

Oracle 11G 64-bit automatic restart and shutdown commands in RHEL (Red Hat Enterprise Linux, the same below) 5.5 64-bit: Log On As an oracle user and enter: VI/etc/init. d/Oracle On the Edit page, add the following content: (assume that the

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

files to the regular Oracle software owner(2) Detailed description of relevant documentsThe LS command and many parameters provide some useful file information.Another unfamiliar command, stat, provides more useful information. [oracle@Think ~]$ cd $ORACLE_HOME/bin[oracle@Think bin]$ stat oracle File: `

　　Fire Station Building Institute (LieHuo. Net) Database TechnologyOracle is the world's leading information management software developer and is well known for its complex relational database products. Oracle database products are used by the top 1000 companies in the Fortune ranking. Many large websites also use Oracle Systems. Oracle's relational database is the world's first database that supports the S

Recently, my NC project runs in Linux. Write down the installation process.============= Manually start Oracle ======## note: in this example, the oralce command is in the/home/oracle/product/10.2.0/db_1/bin directory. # You can change it to your own directory. 1. You need to set Environment Variables$ Cd/home/oralce$ Gedit. bash_profile2. append the following st

fileDrop Tablespace tablespace_name;--Delete non-empty table spaces, but not physical filesDrop tablespace tablespace_name including contents;--Delete empty table space, including physical filesDrop tablespace tablespace_name including datafiles;--Delete a non-empty tablespace containing physical filesDrop tablespace tablespace_name including contents and datafiles;--Add Cascade CONSTRAINTS if the table in the other tablespace is associated with a field of a table in this table space with a con

This article is from the "Happy F" blog, please be sure to keep this source http://gaoxingf.blog.51cto.com/612518/121138 Common commands for Oracle databases under Linux Executed under Oracle users: $ sqlplus system/manager @ file.sql Execute SQL script file $ sqlplus System/manager Login sqlplus, using System user $

Switch to Oracle UserSu-oracle #目录转到oracle用户的HOME下, together with the user's shell to switch, only the environment variable that switches Shell,path is valid. Su only switches identities, and the shell environment is still the original user's shell environment./********************************************/1.1 Do not log into the sqlplus environment.Sqlplus/nolog1

load applied by the application.For example, check the available memory before starting the backup application, and check the available memory immediately after startup.The difference between the two is the memory consumed by the backup application.Oracle user usageSo how do you use this command to manage Linux servers running the Oracle environment?One of the most common causes of performance problems is

--------- ------------ ---------- PPRD10 Noarchivelog READ WRITE Where "Log_mode" represents the current archiving method for Oracle. "Archivelog" means that the database is running in archive mode and "Noarchivelog" means that the database is running in non-archive mode. 4. To view error messages for ora-in the database alert_sid.log: $ More/u01/app/oracle/admin/pinnsoft/bdump/alert_pinnsoft.lo

Label:1. Start the Oracle database:To switch to an Oracle User:[Email protected] ~]# su-oracleEntering the Sqlplus environment, the Nolog parameter indicates no login:[Email protected] ~]$ Sqlplus/nologLog in in Administrator mode:[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 11.2.0.3.0 Production on Fri Apr 17 10:13:07 2015Copyright (c) 1982, Oracle. A

How to run Oracle commands in SUSE Linux:Suid/guid:Non-Oracle users are required to run oracle commands such as sqlplus. Solution:If you want to set s u I d, set the one before the corresponding permission bit to 4; if you want to set g u I d, set the one before the corresp

Run Oracle database EM, isqlplus, and other commands in Linux. $ ORACLE_HOME/bin/emctl start dbconsole $ ORACLE_HOME/bin/isqlplusctl start Common emctl command syntax: Emctl start dbconsole to start the EM console service. You need to set the ORACLE_SID environment variable before use. Emctl stop dbconsole to stop the EM console service. You must set the ORA

1. Download gqlplus, download link http://jaist.dl.sourceforge.net/project/gqlplus/gqlplus/1.12/gqlplus-1.12.tar.gz. 2. Upload to linux, decompress and compile and install 2.1tar-zxvfgqlplus-1.12.tar.gz 2.2cdgqlplus-1.12 ./Configure Make 3. log on to the oracle database with gqlplus [Oracle @ Centos ~] $/SQL/gqlplus-1.12/gqlplus/nolog SQL * Plus: Releas

names, home address, telephone, remark," and so on, if used; If you want to extract the names of everyone and their corresponding phone numbers, use the command: Cat Contacts.txt | cut-f1,3-d ";" 2, to see the Linux under the current all users: cat/etc/passwd | cut-f1,3-d ":" The second column is greater than 500 for the user created, and less than 500 for the system-defined user. For example: ##################################################

Tag: Oracle Common Command Oracle650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/8F/26/wKiom1jUy2iQxTFcAAEwFW7sslc476.png "style=" float : none; "title=" 1.png "alt=" Wkiom1juy2iqxtfcaaewfw7sslc476.png "/>650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/8F/26/wKiom1jUy27QTIY1AAISgoZWk0o056.png "style=" float : none; "title=" 2.png "alt=" Wkiom1juy27qtiy1aaisgozwk0o056.png "/>650) this.width=650; "src=" Https://s1.51cto.com/wyfs0

object_name,status from user_objects where object_type= ' PROCEDURE ';View source code for functions and proceduresSql>select text from All_source where Owner=user and Name=upper (' plsql_name '); Third, view the SQL of the database1. View the name and size of the table spaceSelect T.tablespace_name, round (SUM (bytes/(1024*1024)), 0) ts_sizeFrom Dba_tablespaces T, Dba_data_files Dwhere t.tablespace_name = D.tablespace_nameGroup BY T.tablespace_name;2. View the table space physical file name a

Description: This import and export use the EXPDP and IMPDP command to operate, these 2 commands all need to operate on the server side Http://www.cnblogs.com/huacw/p/3888807.html First, export DMP files from an Oracle database 1. To the Linux Oracle user login host, and then create the export file directory/home/

; select username from dba_users; Querying the username of all users under the current SID Sql> Select COUNT (*) from Username.tablename; Query the number of rows in a tablename table Sql> drop user username cascade; To remove an Oracle user named username Sql> SELECT DISTINCT table_name from User_tab_columns; View all table names in the current user mode ~~~~~~ think of this today, first write this, hehe ~ ~ ~ Common Database Operations Tool: SQL Ex

Under the Linux operating system, how do I start a service and listen command? You must first log on as an Oracle User: 1, start the database: The following are the referenced contents:Oracle@suse92:~> Sqlplus/nologSql*plus:release 9.2.0.4.0-production on Fri 20 02:29:37 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Sql> Conn