Oracle10G Self-starting Troubleshooting
the Since the startup failed, ps -ef |grep ora_ found nothing. Run dbstart start manually have: Failed to auto-start Oracle Net Listen using /ade/vikrkuma_new/oracle/bin/tnslsnr the Solution steps: (1) Change rc.local su oracle -lc ora_App/product/10.2.0/db_1/bin/lsnrctl start su oracle -lc ora_App/product/10.2.0/db_1/bin/dbstart because: The parameters of the su command, when there is a -l parameter to change the identity, also change the working directory, as well as the HOME, SHELL, USER, LOGNAME, PATH variables www.2cto.com (2) vi dbstart Change ORACLE_HOME_LISTNER=$ORACLE_HOME the appears in the log ORA-27125: unable to create shared memory segment cat /etc/group Get oracle group dba id 502 Modify kernel parameters echo “502” >/proc/sys/vm/hugetlb_shm_group the the Author deams
oracle basic trivial summary —–delete data
When the data in the table is not needed, you should delete the data and release the occupied space. To delete the data in the table, you can use the Delete statement or the Truncate statement, which are described below. 1. delete statement (1) Conditional deletion Grammar format: delete [from] table_name [where condition]; For example: delete the data whose userid is ‘001’ in the users table: delete from users where userid='001'; (2) Unconditionally delete the entire table data Grammar format: delete table_name; Such as: delete all data in the user table: delete users; 2. Truncate statement www.2cto.com Use the Truncate statement to delete all records in the table. Syntax format: Truncate [table] table_name; (1) Delete all records without keeping records occupying space Truncate [table] table_name [drop storage]; For example: delete all the data in the users table without saving the occupied space: Truncate table users drop storage; Since the drop storage keyword is used by default, drop storage can be omitted; (2) Delete all records and keep records occupying space Truncate [table] table_name [reuse storage]; For example: delete all the data in the users table and save the occupied space: Truncate table users reuse storage; 3. Comparison of two delete…
ORACLE11g manually configures EM under Linux
Oracle installed using the OTK tool does not have EM configured by default, so record the configuration and startup process below! the First create EM, execute the following command the $ emca -config dbcontrol db -repos recreate The first time I run it, I report the following error: the Mar 31, 2012 4:16:06 PM oracle.sysman.emcp.EMReposConfig createRepository CONFIG: ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.SOURCE$ by 128 in tablespace SYSTEM oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00604: error occurred at recursive SQL level 1 www.2cto.com ORA-01653: unable to extend table SYS.SOURCE$ by 128 in tablespace SYSTEM at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1000) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380) at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:510) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:228) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521) Mar 31, 2012 4:16:06 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository www.2cto.com the Solution the Log in to sqlplus as the SYS user, and execute the following statement: the SQL> SELECT * FROM DBA_DATA_FILES where TABLESPACE_NAME = 'SYSTEM'; FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_ /data01/rdbms/wcdb/datafile/wcdb_system_01.dbf 1 SYSTEM 536870912 65536 AVAILABLE 1 NO 0 …
Backup and recovery of oracle log files, parameter files and control files
Before figuring out the role of each file, you must master the basic concepts of oracle. 1. Backup and restore of basic files 1. Logfile diversification and backup recovery log query select * from v$logfile; select * from v$log; Switch logs manually alter system switch logfile; manual checkpoint alter system checkpoint; Alarm log file www.2cto.com show paramter dump $ORACLE_BASE/admin/orcl/bdump tail -f alert*.log Pluralistic log files alter database add logfile member '/opt/ora10g/oradata/orcl/redo01B.log' to group 1; alter database add logfile member '/opt/ora10g/oradata/orcl/redo02B.log' to group 2; alter database add logfile member '/opt/ora10g/oradata/orcl/redo03B.log' to group 3; The log file is broken, repair the log file (it is lost, you can also use this to recover) alter database clear logfile group 1; if not attributed alter database clear unarchived logfile group 2; add members alter database add logfile group 4; alter database add logfile member '/opt/ora10g/oradata/orcl/redo04.log' to group 4; delete log group alter database drop logfile group 4; Delete log group members www.2cto.com alter database drop logfile member '/opt/ora10g/oradata/orcl/redo01B.log'; 2. Backup and restore of parameter files Use pfile to back up the binary startup parameter file create pfile from spfile; When the spfile file is missing or damaged it can startup pfile='…INIT.ora' create spfile from…
ORA-12514 (TNS:The listener is currently unrecognized…) solution
During the installation of ORACLE 11G, due to configuration reasons, the following errors were reported during the installation process: the After performing the following operations according to the installation prompts, when opening PL/SQL DEVELOPER to connect to the database, it will always report ORA-12514: TNS: The listener currently cannot recognize the service requested in the connection descriptor! Test in ORACLE NET MANAGER to test whether the service can succeed. The result is still reporting the above error the Baidu searched for this error ORA-12514 on the Internet. It turns out that many people have encountered this problem, so I configured it according to the processing steps of others, and this problem was solved. However, I still feel that it is necessary to record the steps to solve this problem. First, let yourself have a deep understanding and exercise your ability to summarize, and second, it can help people who encounter this problem in the future. First find the listener.ora file. The experimental machine is located in the listener.ora file in the E:\app\kerry\product\11.2.0\dbhome_1\NETWORK\ADMIN directory. The problem is with this file. The file initially looks like this: # listener.ora Network Configuration File: E:\app\kerry\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER= (SID_LIST =…
Summary of connection problems between Sqlplus and oracle
Question one: When connecting, it prompts that there is no listener the There may be no listener, or the service may not be up. 1) Establish monitoring: the 2) If there is monitoring, it may be that the monitoring service has not started: the Question two: When Sqlplus connects to the local database, there is no response, and the same is true when using the client (toad\plsql developer). And there is no response to the oracle connection test. www.2cto.com Recently, after starting the local oracle service, I used cmd to log in to sqlplus and found that the connection did not respond, that is, it died there. Under normal circumstances, it will prompt that it is connected. Now the situation is as follows: the After Connect, press Enter, but there is no response. At the same time, there is no response when trying to use the client. Looking at the service list, the oracle service and the monitoring service are normal: the the At the same time, I did a connection test, but there was no response: the And go into tnsnames.ora to look at it, the configuration content has not been modified, it is strange. After exploration, by deleting…
How to add column to specified location in oracle
oracle add column to specified location the oracle, 1. If the table has loaded a large amount of data, it should be replaced by a view. alter table TableNM add NewField varchar2(10) rename TableNM to TableNMX www.2cto.com create or replace view TableNM as select Field1,Field2,NewField,Field3 from TableNMX the 2. Not very big data, you can alter table TableNM rename column Field3 to NewField alter table TableNM add Field3 … This method involves Field3, the data type of NewField, and the transfer between data fields the 3. Small amount of data, you can consider drop and then create Example: alter table INV_SALESSETTLEMENTDETAIL add ( realTimeQuantityKg number(13,2) default '0', realTimeQuantityLiter number(13,2) default '0' ) ; create table INV_SALESSETTLEMENTDETAIL1 as select “SALESDETAILGID”, “SETTLEMENTGID”, “OILARCHGID”, “ARCHNAME”, “ARCHSPEC”, “SALESTIME”, “LOADINGBILLGID”, “DENSITY”, “TINGID”, “SITENO”, “OUTAMOUNTKG”, “OUTAMOUNTLITER”, realTimeQuantityKg, realTimeQuantityLiter, “TAXRATE”, www.2cto.com “SETTLEMENTPRICEKGTAX”, “BUSINESSMARK”, “SETTLEMENTPRICEKG”, “SETTLEMENTPRICELITERTAX”, “SETTLEMENTPRICELITER”, “OTHERMONEYAMOUNT”, “PAYMENTAMOUNT”, “REMARK”, “CREATETIME”, “CREATOR” from “TRANSPORTOIL”.”INV_SALESSETTLEMENTDETAIL” ; drop table INV_SALESSETTLEMENTDETAIL; rename INV_SALESSETTLEMENTDETAIL1 to INV_SALESSETTLEMENTDETAIL; the the the Author liufeng_king
