connect access to oracle 11g

created in lowercase Tom, it is capitalized in the data dictionary, so you also need to write uppercase when queryingDelete Tom UserDrop user Tom;Create user "Tom" identified by Oracle;Delete Tom UserThe correct way to delete this should be:Drop user "Tom";Create user tom, the default tablespace is "XXX" and does not specify quotas, so Tom users cannot create objects on the XXX table spaceResults of using the Tom user to

= $ORACLE _base/oracle/product/11.2.0/db_1Oracle_sid=brdwdevOracle_unqname=brdwdevPath= $PATH: $HOME/bin: $ORACLE _home/binLd_library_path= $ORACLE _home/lib:/usr/libLang=c Export oracle_base oracle_home oracle_sid oracle_unqname PATH ld_library_path LANG # See how we are called:Case $ inStartSu-oracleLsnrctl startSqlp

Tags: OracleI. Oracle database structure1. Logical Structure1.1. Data Block (Orale block): A certain number of bytes of disk space in the operating system's storage system. The data block is the smallest logical part of the Oracle database. can be defined as 2K, 4K, 8K, 16K, 32K, or larger, often referred to as oralce blocks.Size of the Orale block: the db_block_size parameter setting in the initial file In

enter a short password that you normally use, and you don't have to add numbers to the 8-bit size that Oracle recommends. Oh. Note: Sys/system, also modify the new password, confirm the password. 15. Similarly, passwords that do not conform to the rules are prompted. Don't worry about it, continue Y. 16. The installation is successful and complete. It's simple, hehe. three. After installation, access to

Global Zone (PGA):This system diagram is very important to hear, many companies interview request handwriting this figureInstallation of the 3.pl/sql toolThe first installation did not succeed, under the CSDN resources, now think of it should be tnsnames.ora there is a Sqlnet.ora two files are not configured, resulting in the connection when the detection of the database is only a 222222222, go in to say no listening program. Later on the Internet to check and change, change my DOS box of

detailed crossing Web documents)) 1. First open "Start menu->oracle database Express Edition" or "Run SQL command line" 2, if "Run SQL command line" run Sqlplus directly, if "Start the database" will just go to the command line, you need to open Sqlplus, enter the Sqlplus/nolog (or help Sqlplus to view assistance) 3. After startup, connect the database: Connect

and datafiles;Modify table space Size (Note: Modify = can be increased and can be reduced.) ）alter?database?datafile '/u01/app/oracle/oradata/orcl/ittbank.dbf ' resize 200m;Increase table space Size (Note: increase = can only increase, cannot be reduced.) ）alter tablespace ittbank add datafile '/u01/app/oracle/oradata/orcl/ittbank.dbf ' size 2048m;Querying database files:select * from Dba_data_files;To que

system's memory resources are limited and the operating system itself consumes some memory space.4. Large pools (Large pool)The memory structure is not required in the SGA, and the instance will use a large pool to alleviate the access pressure of the shared pool only in one of the following special cases:a--when using Recovery Manager for backup and restore operations, large pools are used as I/O buffersb--when I/O Slave emulate asynchronous I/O fun

\Administrator\product\11.2.0\dbhome_1.after Oracle completes the installation, the service is registered in the system, and the following two services must be started in the registered services or Oracle will not work properly:(1) Oracleoradb11g_home1tnslistener: Indicates the listener service, which must be turned on if the client wants to connect to the databa

Problem description: the customer reports that the client cannot connect when it cannot log on to the application.Environment: AIX 5.3 + Oracle 11gR2Solution: remote Telnet to the Database Host, sqlplus/as sysdba after the connection operation is normal, indicating that the database server should be normal, and then in the client to connect to the database with s

for MigrationImpdp ityy_z1_w/z1_w123 directory = DATA_PUMP_DIR network_link = zqxt logfile = ityy. logThe execution result is as follows:Import: Release 11.2.0.1.0-Production on Friday June 28 16:52:03 2013Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Produc

=8192*.db_domain= "*.db_name= ' Matrix '*.db_recovery_file_dest= '/u2/oracle/fast_recovery_area '*.db_recovery_file_dest_size=4322230272*.diagnostic_dest= '/u2/oracle '*.dispatchers= ' (protocol=tcp) (SERVICE=MATRIXXDB) '*.memory_target=419430400*.open_cursors=300*.processes=150*.remote_login_passwordfile= ' EXCLUSIVE '*.undo_tablespace= ' UNDOTBS1 '*.db_unique_name= ' MATRIXDG '*.log_archive_config= ' dg_c

dbtimezone, sessiontimezone from dual. But OS (unix level) TZ settings DO alter the time that the OS will pass on to Oracle. To debug: Telnet to the unix box and connect using sqlplus in the telnet session: 1) once trought the listener using a tnsnames alias Select to_char (sysdate, 'dd-MON-YY HH24: MI: ss') from dual; 2) once trough a "local" ORACLE_SID connection Select to_char (sysdate, 'dd-MON-YY HH24:

Basic Import and Export commands for Oracle10g/11g: ExpUser Name/User Password@ Service name File=Save path. dmp Buffer=8192Filesize=10000 m feedback=1000 imp username/user password @ service name file = file path. dmp full = y Generally, data export (including triggers and stored procedures) under a specified user can be completely exported (imported) within 10 Gb ). In addition, you can also export the specified table and specify functions. For

Tags: CTI fail window LIS Technology 40 Manage Err RorSymptom: The Oracle database for the Windows operating system, which uses a sqlplus connection (without specifying the instance name), connects quickly, and it takes about thirty or forty seconds for the program to connect or to use the connection tool or to test the connection in net Manager (the program connection may fail). It also takes thirty or for

NextReport a prompt, found that the listener is running, the purpose to achieve, select NoGo back to configure the main page, select the Local network service name configuration, click NextIn the drop-down box, select Orcl NextService Name Fill ORCL NextSelect TCP Nexthostname complete localhost, using standard port number 1521 nextCheck to test nextShow the test is unsuccessful, it's OK, click Change Login, Test success will not point the next stepFill in the account and password that we confi

How to Understand oracle 11g scan ipBefore 11.2, the client should use vip when connecting to the database. If your cluster has four nodes, the client's tnsnames. in ora, there should be a connection string of four vip hosts. If a node is added to the cluster, You need to modify the tnsnames for each client connected to the database. ora. After scan is introduced, it facilitates an interface for client con

datafile ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\Facial.DBF ' size 500M autoextend on next 50M ;--Create UserCreate user facial identified by facial default tablespace ts_facial;--Authorized to UserGrant CONNECT,RESOURCE,DBA to facial;Test.dmp and Test.log are placed in the E:\oracle\product\10.2.0\admin\orcl\dpdump directory.10g import statement: IMPDP userid=

When building django+oracle 11g on a Win7 system, note that the example uses Python 2.7:Important: Python, Oracle, Oracle client these three OS bits must be the same, otherwise Python cannot connect to the Oracle database.

_/data01/rdbms/wcdb/datafile/wcdb_system_01.dbf 1 SYSTEM 536870912 65536 AVAILABLE1 NO 0 0 0 535822336 65408SYSTEM Then define a new space file wcdb_system_02.dbf. Do not name it again. Then define a new space file * wcdb_system_02.dbf *. Do not name it again. SQL> ALTER TABLESPACE SYSTEM ADD DATAFILE '/data01/rdbms/wcdb/datafile/wcdb_system_02.dbf' SIZE 500 M; Tablespace altered. Then execute EM again to create successfully! EM access address: https