ps -ef|grep pmon
ifconfig
nmtui-edit
whoami
kill -9 1122
df -h
du -h
pwd
find . -name ‘*nombre.txt’
//a partir de la carpeta
find / -name ‘*nombre.txt’
//todo el disco duro
su – oracle
cd $ORACLE_HOME/dbs
ls
export ORACLE_SID=INSTANCIA
cd
pwd
/home/oracle
mkdir datafiles
cd datafiles
pwd
sqlplus «/ as sysdba»
select * from v$instance;
select username from dba_users;
select name from v$datafile;
select tablespace_name from dba_tablespaces;
archive log list;
create tablespace PRUEBA datafile ‘/home/oracle/datafiles/prueba.dbf’ size 1000M autoextend off;
create tablespace PRUEBA datafile ‘/home/oracle/datafiles/prueba.dbf’ size 1000M autoextend on next 50M maxsize 5000M;
create user TEST identified by ‘passw0rd’ default tablespace PRUEBA quota unlimited on PRUEBA;
grant connect to TEST;
grant select on HR.NOMINA to test;
grant select any table to test;
grant insert on HR.NOMINA to test;
grant all privileges to test;
create role DESARROLLO;
create role DESARROLLO identified by ‘passw0rd’;
grant select on HR.SUELDOS to DESARROLLO;
alter user TEST default role DESARROLLO;
create table TABLAPRUEBA (id number, nombre varchar2(30), apellido varchar2(30));
insert into TABLAPRUEBA VALUES (1,’juan’,’perez’);
select * from TABPAPRUEBA;
create index TABLAPRUEBA_idx on TEST.TABLAPRUEBA (nombre, apellido) tablespace PRUEBA;
alter index TABLAPRUEBA_idx rebuild;
alter table TABLAPRUEBA move;
create table TABLAPRUEBA2 as select * from TABLAPRUEBA;
select table_name from user_tables;
alter table TABLAPRUEBA rename to TABLAPRUEBA3;
show parameter sga
drop table TABLAPRUEBA;
drop tablespace PRUEBA including content and datafiles;
alter tablespace PRUEBA add datafile ‘/ruta/prueba02.dbf’ size 1000M autoextend on next 50M maxsize 5000M;
alter system set memory_target=2000M scope=both;
shutdown immediate;
shutdown abort;
ANALYZE TABLE TABLAPRUEBA COMPUTE STATISTICS;
analyze index tablaindex COMPUTE STATISTICS;
exec DBMS_UTILITY.analyze_schema(‘TEST’, ‘compute’);
exec DBMS_UTILITY.analyze_schema(‘TEST’ ,estimate_percent=>15);
cat /etc/oratab
lsnrctl status
lsnrctl start LISTENER
cd $ORACLE_HOME/dbs
cd $ORACLE_HOME/network/admin /listener.ora
tnsping INSTANCIA
rman target /
list archivelog all;
list backup;
crosscheck archivelog all;
crosscheck backup;
backup database;
restore database;
recover database;
restore datafile;
create directory DIRTEST as ‘/home/test/;
expdp sys/oracle123@INSTANCIA dumpfile=exportausuario.dmp directory=DIRTEST full=y
Comentarios recientes