firma

Comprimir y descomprimir archivos UNIX/LINUX

Comprimir y descomprimir archivos es una de las tareas mas comunes que vamos a tener que realizar en Linux por línea de comandos. Podemos hacerlo mediante diversas herramientas, pero existen dos que van a estar disponibles en casi cualquier distribución. 





Son dos herramientas que se tienen que utilizar de manera complementaria. Se trata de tar, que simplemente empaqueta varios archivos en un único fichero, y gzip, que hace la compresión propiamente dicha.





El comando tar tiene la siguiente sintaxis:





tar [opciones] [origen] [destino]





Donde opciones son, por ejemplo, las siguientes:

• c: crear un archivo
• x: extraer de un archivo
• t: listar los contenidos de un archivo
• v: ver un reporte de las acciones a medida que se van realizando
• f: empaquetar contenidos de archivos
• z: para comprimir a la vez que se empaqueta

Como se puede ver, con la opción z se puede comprimir en el mismo paso en el que se empaqueta, lo que puede hacer las cosas más rápidas y cómodas. De todos modos, tar simplemente hace el empaquetado y es gzip el que realiza la compresión. Simplemente que nosotros no tenemos que llamar a gzip, sino que ya lo hace directa e internamente tar.

Ejemplos

1) Si queremos empaquetar un directorio llamado "html" y guardar los datos en "html-paq.tar", lo haríamos con la sentencia:

tar cvf html-paq.tar html

2) Si queremos comprimir un directorio llamado "archivos" y guardarlo en un fichero llamado "archivos-comp.tgz", `podríamos hacer algo como esto:

tar czvf archivos-comp.tgz archivos 

Si nos fijamos, en este caso el nombre del archivo comprimido le hemos puesto extensión .tgz, que indica que está empaquetado y comprimido.

3) Si queremos desempaquetar un archivo llamado xxx.tar podemos utilizar un comando como este:

tar xvf xxx.tar

Eso supone que tenemos el archivo xxx.tar en el mismo directorio desde donde lanzamos el comando. Los contenidos se desempaquetarán en el mismo directorio donde estamos situados.

4) Si el archivo que queremos desempaquetar está comprimido. Es decir, si queremos descomprimir y desempaquetar en un solo paso, tenemos que hacerlo con la opción z del comando tar. Algo como esto:

tar xzvf xxx.tgz

Hi,

We have been working on 11.1.2.1 last few weeks and everything was working perfectly. But suddenly we got an error when we tried to access Application/ Dimension library from workspace.

When we tried to access the below link:
http://:19091/awb/

It gaves us the error as follows:

error - 503 : service unavailable.

Loading the module 'awb.appcontainer' failed.

Code: org.apache.axis.AxisFault

Description: An error occurred processing the result from the server.

Please help us out.

thanks.


Check the windows event viewer after starting the EPMA server service as it may give some clues, also check the EPMA web app logs

If everything was working perfectly before, and all of a sudden EPMA is not available it is one of 3 things:

EPMA was configured to point to an IP instead of a logical server name and the machine was first rebooted prior to this happening
Services hung, and all services need to be brought down and come back up.

Although everytime I have seen this happen in a working environment, it has been because one of the EPMA services crashed, or the EPMA services were not started in the correct order.

I would restart all services and make sure you start them in the proper order. This is almost certainly not something major.

Hi, We found one solution from the Oracle Metalink, yet to work it out. The ID: 799934.1 - error 503- service unavailable Thanks.

794965 Posts: 13 Registered: 09/15/10

Re: EPMA : error - 503: service unavailable in Hyperion workspace  Posted: 25-jul-2012 21:41    in response to: 794965     Reply Hi, We have solved the issue finally.. By Updating the user credentials in IIS manager, the issue has been resolved. Thanks.

Service cannot be started. Hyperion.DimensionServer.Interface (Error al iniciar el servicio de EPMA Dimension Server en Windows)

Service cannot be started. Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Oracle.DataAccess.Client.OracleException ORA-00942: table or view does not exist    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at Hyperion.DataAccessLayerCore.DALDatasetCommand.get_Reader()
   at Hyperion.DataAccessLayerCore.DALDatasetCommand.FastRead()
   at Hyperion.DataAccessLayerCore.DALDatasetCommand.Read()
   at Hyperion.DataAccessLayerC...


[EPMA Server Startup] ERROR SVR_ERR_PROCESSMGR_CANT_INIT_SESSIONMGR:Cannot initialize the Session Manager.Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Oracle.DataAccess.Client.OracleException ORA-00942: table or view does not exist    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at Hyperion.DataAccessLayerCore.DALDatasetCommand.get_Reader()
   at Hyperion.DataAccessLayerCore.DALDatasetCommand.FastRead()
   at Hyperion.DataAccessLayerCore.DALDatasetCommand.Read()
   at Hyperion.DataAccessLayerCore.DataAccessLayer.ExecLoadSQL(String SQL, Action`1 onSetParams, Action`1 onRead, DatabaseContext context)
   at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion, Boolean onlyLoadKnownTables)
   at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion)
   at Hyperion.SessionManager.DAO.SessionManagerDataAccessLayer..ctor(NameValueCollection settings)
   at Hyperion.DimensionServer.SessionManager.SessionStoreRdbms.Initialize(String rdbmsVendor, String rdbmsConnParams, Int32 rdbmsCommandTimeout, Boolean logAllSQL)
   at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(String configFileName, Boolean restorePastInstanceSessions, Boolean enableCaching)
   --- End of inner exception stack trace ---
   at Hyperion.DimensionServer.Service.Main.InitializeSessionManager()
   at Hyperion.DimensionServer.Service.Main.Start()

Solución: Reconfigurar la base de datos.

Can't start Foundationservice Error with EPMregistry?

Hi all , I have recently install EPM 11.1 in linux . it starts well at first. but it gets error while i start today. start-FoundationServices0-out.log ====== Registry was NOT initialized sucessfully The registry was not initialised properly, registry update disabled loggingUpdateWORKSPACE.block file exist or the system is running in the Fusion mode, skipping logging.xml configuration ".> ===== I also check the all server status in weblogic , Foundation service displays running. while i access to shared service web site ,it get 404 error. Regards, Chelsea 1.- Re-run config tool on that server and re-configure the Shared Services database. When prompted select reuse existing tables. Regards, John A. Booth http://www.metavero.com

2.- 
I've has a similar problem recently, finally traced it back to a problem (my error) with the configuration. Was doing individual databases (SQL Server) for each app, and must have got one wrong which left the system pointing to an incorrect database for shared services. This can be fixed by editing the xml file that stores the database information. 

For EMPregistry the file is located at:
\Oracle\Middleware\user_projects\domains\EPMSystem\config\jdbc
called EPMSystemRegistry-jdbc.xml

Line 5 reads
jdbc:weblogic:sqlserver://:1433;databaseName=;loadLibraryPath=\Oracle\Middleware\wlserver_10.3\server\lib

change , and (I inserted these for clarity - the original has the actual names) to suit your installation.

Naturally, restart services afterwards.

Hope this helps someone else.

3.- 
Hi All,

Found this thread when looking at a similar problem myself. In our system, for some reason, one of our servers had the shared services database set to the R&A database. 

We changed it to HYPHSS as suggested but it's not so easy if your passwords are different.

Anyway, after some searching I found the link http://weblogicserver.blogspot.com/2008/10/how-to-encrypt-clear-text-password-with.html

To get it running for EPM components, use the following command:

java -Dweblogic.RootDirectory="/user_projects/domains/EPMSystem" -cp "/wlserver_10.3/server/lib/weblogic.jar" weblogic.security.Encrypt YOURPASSWORD

Replace with the right directory and YOURPASSWORD with the database password. It will return an AES string which you can paste into the EPMSystemRegistry-jdbc.xml file.

Thanks to posters here getting me started in the right direction though!

The WebLogic Admin Server 11g just hangs upon startup

The WebLogic Admin Server 11g just hangs upon startup

Problem:

Due to our disk space having filled up, I shutdown the Oracle WebLogic AdminServer 11g (11.1.1.3), cleared some logs, and restarted it.

However, when I start it up, it just stops at the entry below. No movement in the log whatsoever, and nothing is happening on the server.

oracle@oradev:/u01/app/oracle/middleware/user_projects/domains/soa_domain/bin>./startWebLogic.sh
*****************************************************
** Setting up SOA specific environment...
*****************************************************
EXTRA_JAVA_PROPERTIES= -da:org.apache.xmlbeans...
.
LD_LIBRARY_PATH=/u01/app/oracle/middleware/patch_wls1033/profiles/default/native:/u01/app/oracle/middleware/Oracle_SOA1/lib:/u01/app/oracle/middleware/wlserver_10.3/server/native/linux/x86_64:/u01/app/oracle/middleware/wlserver_10.3/server/native/linux/x86_64/oci920_8:/u01/app/oracle/middleware/Oracle_SOA1/soa/thirdparty/edifecs/XEngine/bin
.
USER_MEM_ARGS=-Xms768m -Xmx768m -XX:PermSize=256m -XX:MaxPermSize=512m
.
*****************************************************
** End SOA specific environment setup
*****************************************************
.
.
JAVA Memory arguments: -Xms768m -Xmx768m -XX:PermSize=256m -XX:MaxPermSize=512m
.
WLS Start Mode=Production
.
CLASSPATH=/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/user-patch.jar:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/soa-startup.jar::/u01/app/oracle/middleware/patch_wls1033/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/u01/app/oracle/jdk1.6.0_21/lib/tools.jar:/u01/app/oracle/middleware/wlserver_10.3/server/lib/weblogic_sp.jar:/u01/app/oracle/middleware/wlserver_10.3/server/lib/weblogic.jar:/u01/app/oracle/middleware/modules/features/weblogic.server.modules_10.3.3.0.jar:/u01/app/oracle/middleware/wlserver_10.3/server/lib/webservices.jar:/u01/app/oracle/middleware/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/u01/app/oracle/middleware/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/oracle.soa.common.adapters_11.1.1/oracle.soa.common.adapters.jar:/u01/app/oracle/middleware/oracle_common/soa/modules/commons-cli-1.1.jar:/u01/app/oracle/middleware/oracle_common/soa/modules/oracle.soa.mgmt_11.1.1/soa-infra-mgmt.jar:/u01/app/oracle/middleware/oracle_common/modules/oracle.xdk_11.1.0/xsu12.jar:/u01/app/oracle/middleware/modules/features/weblogic.server.modules.xquery_10.3.1.0.jar:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/db2jcc4.jar:/u01/app/oracle/middleware/user_projects/domains/soa_domain/config/soa-infra:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/fabric-url-handler_11.1.1.jar:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/quartz-all-1.6.5.jar:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/oracle.soa.fabric_11.1.1/oracle.soa.fabric.jar:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/oracle.soa.adapter_11.1.1/oracle.soa.adapter.jar:/u01/app/oracle/middleware/Oracle_SOA1/soa/modules/oracle.soa.b2b_11.1.1/oracle.soa.b2b.jar:/u01/app/oracle/middleware/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/u01/app/oracle/middleware/wlserver_10.3/common/derby/lib/derbyclient.jar:/u01/app/oracle/middleware/wlserver_10.3/server/lib/xqrl.jar:/u01/app/oracle/middleware/Oracle_SOA1/lib:/u01/app/oracle/middleware/jdk160_18/lib
.
PATH=/u01/app/oracle/middleware/wlserver_10.3/server/bin:/u01/app/oracle/middleware/modules/org.apache.ant_1.7.1/bin:/u01/app/oracle/jdk1.6.0_21/jre/bin:/u01/app/oracle/jdk1.6.0_21/bin:/usr/local/bin:/bin:/usr/bin:/usr/sbin:.
.
***************************************************
*  To start WebLogic Server, use a username and   *
*  password assigned to an admin-level user.  For *
*  server administration, use the WebLogic Server *
*  console at http://hostname:port/console        *
***************************************************
starting weblogic with Java version:
java version "1.6.0_21"
Java(TM) SE Runtime Environment (build 1.6.0_21-b06)
Java HotSpot(TM) 64-Bit Server VM (build 17.0-b16, mixed mode)
Starting WLS with line:
/u01/app/oracle/jdk1.6.0_21/bin/java -server   -Xms768m -Xmx768m -XX:PermSize=256m -XX:MaxPermSize=512m -Dweblogic.Name=AdminServer -Djava.security.policy=/u01/app/oracle/middleware/wlserver_10.3/server/lib/weblogic.policy  -Dweblogic.ProductionModeEnabled=true   -da -Dplatform.home=/u01/app/oracle/middleware/wlserver_10.3 -Dwls.home=/u01/app/oracle/middleware/wlserver_10.3/server -Dweblogic.home=/u01/app/oracle/middleware/wlserver_10.3/server  -Ddomain.home=/u01/app/oracle/middleware/user_projects/domains/soa_domain -Dcommon.components.home=/u01/app/oracle/middleware/oracle_common -Djrf.version=11.1.1 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Djrockit.optfile=/u01/app/oracle/middleware/oracle_common/modules/oracle.jrf_11.1.1/jrocket_optfile.txt -Doracle.domain.config.dir=/u01/app/oracle/middleware/user_projects/domains/soa_domain/config/fmwconfig -Doracle.server.config.dir=/u01/app/oracle/middleware/user_projects/domains/soa_domain/config/fmwconfig/servers/AdminServer -Doracle.security.jps.config=/u01/app/oracle/middleware/user_projects/domains/soa_domain/config/fmwconfig/jps-config.xml -Djava.protocol.handler.pkgs=oracle.mds.net.protocol  -Digf.arisidbeans.carmlloc=/u01/app/oracle/middleware/user_projects/domains/soa_domain/config/fmwconfig/carml  -Digf.arisidstack.home=/u01/app/oracle/middleware/user_projects/domains/soa_domain/config/fmwconfig/arisidprovider -Dweblogic.alternateTypesDirectory=/u01/app/oracle/middleware/Oracle_SOA1/modules/oracle.ossoiap_11.1.1,/u01/app/oracle/middleware/Oracle_SOA1/modules/oracle.oamprovider_11.1.1  -Dweblogic.jdbc.remoteEnabled=true -Doracle.security.jps.policy.migration.validate.principal=false  -da:org.apache.xmlbeans... -Dsoa.archives.dir=/u01/app/oracle/middleware/Oracle_SOA1/soa -Dsoa.oracle.home=/u01/app/oracle/middleware/Oracle_SOA1 -Dsoa.instance.home=/u01/app/oracle/middleware/user_projects/domains/soa_domain -Dtangosol.coherence.clusteraddress=227.7.7.8 -Dtangosol.coherence.clusterport=9778 -Dtangosol.coherence.log=jdk -Djavax.xml.soap.MessageFactory=oracle.j2ee.ws.saaj.soap.MessageFactoryImpl -Dcom.sun.management.jmxremote -Djava.protocol.handler.pkgs=oracle.mds.net.protocol|oracle.fabric.common.classloaderurl.handler|oracle.fabric.common.uddiurl.handler|oracle.bpm.io.fs.protocol -Dweblogic.transaction.blocking.commit=true -Dweblogic.transaction.blocking.rollback=true -Djavax.net.ssl.trustStore=/u01/app/oracle/middleware/wlserver_10.3/server/lib/DemoTrust.jks -Dem.oracle.home=/u01/app/oracle/middleware/oracle_common -Djava.awt.headless=true -Dbam.oracle.home=/u01/app/oracle/middleware/Oracle_SOA1 -Dums.oracle.home=/u01/app/oracle/middleware/Oracle_SOA1 -Dweblogic.management.discover=true  -Dwlw.iterativeDev=false -Dwlw.testConsole=false -Dwlw.logErrorsToConsole=false -Dweblogic.ext.dirs=/u01/app/oracle/middleware/patch_wls1033/profiles/default/sysext_manifest_classpath  weblogic.Server

Solution:

I worked an Oracle Support analyst (thanks Vijay!) and we reset some passwords and were able to bring up the server again. I am somewhat convinced that this was related to our disk being full.

This is what we proceeded doing:

1. Shutdown the Admin Server

2. Remove the "cache", "date", and "tmp" folders from the server AdminServer location

rm -rf /u01/app/oracle/middleware/user_projects/domains/soa_domain/servers/AdminServer/cache 

rm -rf /u01/app/oracle/middleware/user_projects/domains/soa_domain/servers/AdminServer/data

rm -rf /u01/app/oracle/middleware/user_projects/domains/soa_domain/servers/AdminServer/tmp

This did not solve our problem.

3. Reset the weblogic password by running this command:

java weblogic.security.utils.AdminAccount weblogic welcome1 .

... and resetting the password in:

./servers/AdminServer/security/boot.properties

This partially resolved the problem.

4. We noticed that the "system-jazn-data.xml" file was zero bytes in size:

ll /u01/app/oracle/middleware/user_projects/domains/soa_domain/config/fmwconfig

-rw-r----- 1 oracle ldba      0 Dec 21 20:49 system-jazn-data.xml

I copied the file from a separate server, and the Admin Server now started up.

The question remains... why was the "system-jazn-data.xml" file zero bytes?

Most likely when the disk was full, some process was probably trying to save to it but was unable to, thus blanking out the file. This is my only explanation for this.

Also, since the "system-jazn-data.xml" file that I copied over was not exactly identical, I had to recreate some user accounts.

Applicable Versions:

• Oracle WebLogic Server 11g (10.3.3)
• Oracle SOA Suite 11g (11.1.1.3)

Ver los tablespaces de una base de datos con sqlplus en Oracle

Ver los tablespaces de una base de datos con sqlplus en Oracle

En ocasiones deseamos consultar los tablespaces que se encuentran creado en una base de datos usando sqlplus pero no sabemos cómo. Pues bien, la forma de consultarlos es muy sencilla, deberemos ejecutar alguna de las siguientes instrucciones en SQL, las cuales nos devolverán los nombres de los tablespaces creado.

En caso de ser usuario sys o system, podemos ejecutar la siguiente consulta:

SQL> SELECT tablespace_name FROM dba_tablespaces;

En el caso de ser un usuario que no tiene privilegios de administrador, podemos ejecutar la siguiente consulta:

SQL> SELECT tablespace_name FROM user_tablespaces;

Como se puede observar, únicamente estamos obteniendo el nombre de los tablespaces, pero podemos obtener más información de ellos usando el operador *, por ejemplo:

SQL> SELECT * FROM dba_tablespaces;

o

SQL> SELECT * FROM user_tablespaces;

Para ver el espacio libre que queda en un tablespace tenemos que mirar en la tabla dba_free_space

SELECT tablespace_name,
ROUND(sum(bytes)/1024/1024,0)
FROM dba_free_space
WHERE tablespace_name NOT LIKE 'TEMP%'
GROUP BY tablespace_name;

Con esta consulta obentemos el nombre del tablespace y el espacio en Megas libre

Para ver el espacio total en un tablespace tenemos que mirar en la tabla dba_data_files

SELECT tablespace_name,
round(sum(BYTES/1024/1024),0)
FROM dba_data_files b
WHERE tablespace_name NOT LIKE 'TEMP%'
GROUP BY b.tablespace_name;

Con esta consulta obentemos el nombre del tablespace y el espacio total en Megas que puede llegar a tener.