[ORACLE] ORA-01034 , ORA-27101 해결방법

1. 아래의 그림과 같이 Sqlplus 명령 수행으로 접속 시도를 해 보았을때 

ORA-27101 shared memory realm does not exist 에러가 발생하는경우

- sqlplus /nolog 로 실행후

- conn sys/ as sysdba 로 접속한다음 

- startup 명령을 수행하면 DB 가 정상적으로 잘 동작한다. 

왜 에러가 발생하는지는 모르겠으나 

Windows Service 로 Oracle Listener 가 재기동 않는 경우에 발생하였다. 

[OpenSource R]CentOS 7 OpenSource R install rpm mirror site

1. 일반적으로 CentOS 에서 R 설치할때
    "yum install R" 명령 수행으로 간단히 최신 버전으로 설치가 가능

2. External Network 가 막혀 있는 상황에서는

http://www.mirror.yandex.ru/epel/7/x86_64/r/  Mirror 사이트에 있는

R 관련 RPM 들을 설치 하여 사용하는것이 가장 간편하고 안정적인 설치가 가능하다

물론, R Source 를 다운로드 받아 직접 빌드하여 사용도 가능하지만

이 경우에 빌드를 위해 필요한 라이브러리들을 모두 구성하기가 어려워 빌드가 잘 되지 않았다.

CentOS는 RedHat 계열 OS 이므로 rpm 파일을 사용하여 설치가 가능하다.

[Spotfire Analyst] function test using through TSSS with OpenSource R for Big Data Solution

For Spotfire Analyst .

1. connected to hadoop by RHadoop packages
2. calculated with mapper of hadoop by RHadoop packages.

Conclusion : It is possible and i will test other cases.

[Spotfire Developer] Can't not save dxp file with Library Item on Spotfire Client.

Developed CustomTool using Spotfire 7.0 API , the CustomTool acting is clear.
But when the dxp file save as Library item , occured error such as below. 


[ Error Message on Spotfire Client ]
Error message: Could not publish Baseball_test.

SerializationException at Spotfire.Dxp.Framework:
Type 'SpotfireDevTools.TwoWayAnova.CustomNode.TWACustomNode' is not serializable. The type is not marked with a 'System.SerializableAttribute'.
Object reference chain leading to the fault (closest reference first):

    Spotfire.Dxp.Application.CustomNodes.Nodes[0]
    Spotfire.Dxp.Application.Document.CustomNodes
 (HRESULT: 8013150C)

Stack Trace:
   at Spotfire.Dxp.Framework.Persistence.Xml.SerializationFormatter.Serialize(Object graph)
   at Spotfire.Dxp.Framework.Persistence.Xml.XmlFormatter.Serialize(Stream serializationStream, Object graph, StreamingContext context, PrunerBase pruner)
   at Spotfire.Dxp.Framework.Persistence.PersistenceManager.SerializeForPersistence(Stream serializationStream, Object graph, IServiceProvider serviceProvider)
   at Spotfire.Dxp.Framework.Persistence.PersistenceManager.<>c__DisplayClassd.<Save>b__6()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)
   at Spotfire.Dxp.Framework.Persistence.PersistenceManager.Save(DocumentTypes documentType, DocumentNode doc, IDocumentSaveSettings settings, Stream targetStream)
   at Spotfire.Dxp.Framework.Persistence.PersistenceManager.Save(DocumentTypes documentType, DocumentNode doc, IDocumentSaveSettings settings, String fileName)
   at Spotfire.Dxp.Application.AnalysisApplication.SaveAs(LibraryEntry entry, Document document, LibraryItemMetadataSettings metadataSettings, DocumentSaveSettings saveSettings)
   at Spotfire.Dxp.Application.AnalysisApplication.SaveAs(LibraryEntry entry, LibraryItemMetadataSettings metadataSettings, DocumentSaveSettings saveSettings)
   at Spotfire.Dxp.Forms.Application.FileUserActions.<>c__DisplayClassb.<SaveAsLibrary>b__9()
   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

[Solution]
in the Class , write annotation. and rerun. then can see nomal acting. 
============example code=========================
 [Serializable()] 
 [PersistenceVersion(1, 0)]
 public class TWACustomNode{}

[C# 암호화코드]

AES 암호화 알고리즘 관련

http://marcof.tistory.com/94   암호화 및 복호화 설명

[Spotfire Developer] Adding R Graphics to Spotfire

[reference]How to Adding R Graphics to Spotfire

[Spotfire Analyst] Calculated Dynamic Items in Html Text Area related to Document Property by JavaScript

Calculated Dynamic Items in Html Text Area related with Document Property
1. ppt 파일
https://drive.google.com/open?id=0B4nh5nRwVZGmaEV1b3pkUjlnYkE

2. Sample dxp in Spotfire analyst 7.0.0

https://drive.google.com/open?id=0B4nh5nRwVZGmSEFLYXNNTkdObDg