Oracle
Материал из noname.com.ua
Заметки по установке и работе с Oracle
Все сказанное касается версии 10 если не сказано обратное.
Полезные комманды
Все комманды вводить после su - oracle
lsnrctl status
bash-3.00$ lsnrctl status LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 27-MAY-2010 10:55:05 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production Start Date 27-MAY-2010 09:25:39 Uptime 0 days 1 hr. 29 min. 25 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/10g/network/admin/listener.ora Listener Log File /oracle/10g/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=solaris-test)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
bash-3.00$ tnsping test-solaris
TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 27-MAY-2010 11:00:22 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /oracle/10g/network/admin/sqlnet.ora TNS-03505: Failed to resolve name bash-3.00$ tnsping solaris-test TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 27-MAY-2010 11:00:29 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /oracle/10g/network/admin/sqlnet.ora Used EZCONNECT adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=solaris-test.))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.2)(PORT=1521))) OK (10 msec)
Термины
- Схема (Schema) - коллекция объектов БД. (аналог database в mysql ? )
