Oracle FAQ collection

Oracle FAQ 1. oracleDBConsoleorcl cannot start error code 2: solution: Enter emctl start dbconsole in the command line to report an error. ORACLE_SID does not define the input set ORACLE_SID = ORCL (ORCL is my Instance name and service name) no problem. Then, enter emctl start dbconsole to prompt for the prompt of "productname Configuration issue. d: oracleproduct10.2.0db _ 1/Solaris/j2ee/OC4J_DBConsole_192.168.1.103_orcl not found. copy the OC4J_DBConsole_HOSTNAME_orcl folder under j2ee, rename it to OC4J_DBConsole_192.168.1.103_orcl, copy the HOSTNAME_orcl folder under db_1, and rename it 192.168.1.10 3_orcl. Restart dbconsole. The service is successfully started. ORA-12514: TNS: The Listener currently does not recognize the Service requested in the connection descriptor literally determines it is a listener error, so the listener is reconfigured, restart the monitor service, or cannot solve the problem. Finally, it corresponds to the listener on the normal Oracle machine. ora compared the following results: non-normal Oracle configuration: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (PROGRAM = extproc) (SID_NAME = PLSExtProc) (ORACLE_HOME = E: \ Server \ oracle \ product \ 10.2.0 \ db_1) normal Oracle configuration SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = E: \ Server \ oracle \ product \ 10.2.0 \ db_1) (SID_NAME = ORCL) (SID_DESC = (PROGRAM = extproc) (SID_NAME = PLSExtPr Oc) (ORACLE_HOME = E: \ Server \ oracle \ product \ 10.2.0 \ db_1) The above is marked in red. In the Listener Configuration File on the colleagues' machine, no local database configuration is available in the SID list. So I added the database to the SID list and restarted the listener. Everything is normal. 3. ORA-12560: TNS: protocol adapter error Environment variable configuration [Environment (Environment)] OS: WINDOWS XP DB: ORACLE 10.2 [Symptom (Symptom)] Start sqlplus, then log on to the database, error, the specific information is as follows: C: \ Documents ents and Settings \ netshong> sqlplusSQL * Plus: Release10.2.0.1.0-Production on Monday July 24 13:46:02 2006 Copyright (c) 1982,200 5, Oracle. all rights reserved. enter User name: sys as SYSDBA enter password: ERROR: ORA-12560: TNS: protocol adapter ERROR <Cause (Cause) <This is caused by environment variable ORACLE_SID not set or set ERROR. Before starting sqlplus, we run the following command in the DOS window: set Oracle_sid = BBC. The SID (BBC) set by this command does not exist, so it causes a ORA-12560 error. <Action (method)] n Method 1: Set the correct ORACLE_SID and log on to the database. Step 01: set ORACLE_SIDC: \> set ORACLE_SID = wmwm to the instance name. Step 02: log on to the database. C: \ Documents and Settings \ netshong> sqlplusSQL * Plus: Release10.2.0.1.0-Production on Sun Nov 19 06:23:52 2006 Copyright (c) 1982,200 5, Oracle. all rights reserved. enter user-name: sys as SYSDBAEnter password: Connected to: Oracle Database10gEnterpriseEdition Release10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> log on to the database successfully. N Method 2: Use the Net Service Name when connecting to the database ). C: \ Documents ents and Settings \ netshong> sqlplusSQL * Plus: Release10.2.0.1.0-Production on Mon Sep 4 09:37:15 2006 Copyright (c) 1982,200 5, Oracle. all rights reserved. enter user-name: sys @ wm as SYSDBAEnter password: Connected to: Oracle Database10gEnterpriseEdition Release10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> here the network Service Name (Net Service name) is used) wm connects to the database. Net Service Nam E) wm is configured in the ORACLE network. 4. ORA-12518 TNS: The listener cannot distribute client connection 1. GLOBAL_DBNAME In the listener file, SID_NAME may not match the Instance name, after modification, restart listener. 2. The value of processes in VPC mode is too small. You can solve this problem by using the following methods: 1.cmd 2. sqlplus 3. connect sys/test as sysdba 4. view sessions, processes, and sessions SQL> select count (*) from v $ session; COUNT (*) ---------- 45 SQL> show parameter processes name type value db_writer_processes integer 1 gcs_server_processes integer 0 job_queue_processes integer 10 Bytes integer 2 processes integer 50 SQL> show parameter sessions NAME TYPE VALUE java_soft_sessions Pace_limit integer 0l icense_max_sessions integer 0 license_sessions_warning integer 0 logmnr_max_persistent_sessions integer 1 sessions integer 60 shared_server_sessions integer 5. modify the values of processes and sessions: sessions = (1.1 * process + 5) SQL> alter system set processes = 300 scope = spfile; the system has changed. SQL> alter system set sessions = 335 scope = spfile; the system has been changed. 6. restart the database to make the change take effect. 3. In shared mode, 1. show parameters dispatchers; name type value dispatchers string (protocol = tcp) (service = oracle10xdb) max_dispatchers integer 2. check whether there are enough dispatchers SQL> select name, (busy/(busy + idle) "dispatcher busy rate" from v $ dispatcher; NAME dispatcher busy rate ---- -------------------- D000. 000121704 D001. 000042597 D002. 004935402 if it exceeds 50%, you need to consider adding more dispatchers; 3. change dispathchers: SQL> alter system set dispatchers = '(protocol = tcp) (dispatchers = 3) (service = oracle10xdb)'; system altered 4. PGA memory setting too small note: This method has not been tried. Author: "ERDP technical architecture" 5. the username and password are case-insensitive when oracle ORA-01017 users cannot log on to earlier versions of oracle via PL-SQL, but in 11g, the default database password is case sensitive, in fact very simple, that is to remove the oracle password capital sensitive settings: alter system set sec_case_sensitive_logon = false