Okcan Yasin Saygili's Blog

May 30, 2017

Oracle Storage Cloud on CloudBerry

Filed under: Uncategorized — yasinsaygili @ 3:35 pm

Oracle storage is needed a tool for connecting to client machine and CloudBerry is one of most popular tool in world .

Now take a look how to configure this tool …

cloudb1.PNG

cloudb.PNG

cloudb3.PNG

cloudb5.PNG

Replication Policy at Oracle Storage Cloud (in a few steps)

Filed under: Uncategorized — yasinsaygili @ 3:35 pm

repli1.PNG

repli2.PNG

Refrences
1. http://www.cloudberrylab.com/blog/how-to-use-cloudberry-explorer-with-oracle-cloud-storage/
2. https://blogs.oracle.com/OracleCloud4Developers/entry/cloudberry_setup_for_oracle_storage
3. https://www.youtube.com/watch?v=9nRF0Hq-CLQ
4. http://blog.dbi-services.com/how-to-manage-your-containers-in-oracle-storage-cloud-service/
and another docs

Oracle Storage Cloud First Configurations

Filed under: Uncategorized — yasinsaygili @ 3:35 pm

First of all , install curl on windows https://winampplugins.co.uk/curl/ .
1. Get an authentication token from Oracle Storage Cloud Service.
curl -v -s -X GET -H “X-Storage-User: Storage-usthetalen:yasin@thetalent.me” -H “X-Storage-Pass: Q1w2e3r4_” https://storage.us2.oraclecloud.com/auth/v1.0
Our Auth key below side .
AUTH_tkb24e42debe0154c71d19f69586f25967

2.Now , container is being created .

D:\curl_7_51_0_openssl_nghttp2_x64>curl -v -s -X PUT -H “X-Auth-Token: AUTH_tkb2
4e42debe0154c71d19f69586f25967” https://storage.us2.oraclecloud.com/v1/Storage-u
sthetalen/test
curl -v -s -X PUT -H “X-Auth-Token: AUTH_tkb24e42debe0154c71d19f69586f25967” https://storage.us2.oraclecloud.com/v1/Storage-usthetalen/test
* Trying 129.152.172.4…
* TCP_NODELAY set
* Connected to storage.us2.oraclecloud.com (129.152.172.4) port 443 (#0)
* ALPN, offering h2
* ALPN, offering http/1.1
* Cipher selection: ALL:!EXPORT:!EXPORT40:!EXPORT56:!aNULL:!LOW:!RC4:@STRENGTH
* successfully set certificate verify locations:
* CAfile: D:\curl_7_51_0_openssl_nghttp2_x64\ca-bundle.crt
CApath: none
* TLSv1.2 (OUT), TLS header, Certificate Status (22):
Okcan Yasin Saygılı
* TLSv1.2 (OUT), TLS handshake, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Server hello (2):
* TLSv1.2 (IN), TLS handshake, Certificate (11):
* TLSv1.2 (IN), TLS handshake, Server finished (14):
* TLSv1.2 (OUT), TLS handshake, Client key exchange (16):
* TLSv1.2 (OUT), TLS change cipher, Client hello (1):
* TLSv1.2 (OUT), TLS handshake, Finished (20):
* TLSv1.2 (IN), TLS change cipher, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Finished (20):
* SSL connection using TLSv1.2 / AES128-SHA
* ALPN, server did not agree to a protocol
* Server certificate:
* subject: C=US; ST=California; L=Redwood Shores; O=Oracle Corporation; CN=*.us
2.oraclecloud.com
* start date: Dec 8 00:00:00 2015 GMT
* expire date: Jan 6 23:59:59 2017 GMT
* subjectAltName: host “storage.us2.oraclecloud.com” matched cert’s “*.us2.orac
lecloud.com”
* issuer: C=US; O=Symantec Corporation; OU=Symantec Trust Network; CN=Symantec
Class 3 Secure Server CA – G4
* SSL certificate verify ok.
> PUT /v1/Storage-usthetalen/test HTTP/1.1
> Host: storage.us2.oraclecloud.com
> User-Agent: curl/7.51.0
> Accept: */*
Okcan Yasin Saygılı
> X-Auth-Token: AUTH_tkb24e42debe0154c71d19f69586f25967
>
< HTTP/1.1 201 Created
< X-Trans-Id: txde23c6110fb442cb9ec70-0058296fb9ga
< Date: Mon, 14 Nov 2016 08:03:05 GMT
< Connection: keep-alive
< X-Last-Modified-Timestamp: 1479110585.21201
< Content-Type: text/html;charset=UTF-8
< Content-Length: 0
< Server: Oracle-Storage-Cloud-Service
<
* Curl_http_done: called premature == 0
* Connection #0 to host storage.us2.oraclecloud.com left intact
To get some error from this step .Such as Replication Place issues.
<html><body>The operation was not performed because the replication policy has n
ot been set. Sign in to My Services as the service administrator and select a re
plication policy for your service instance.</body></html>* Curl_http_done: calle
d premature == 0
* Connection #0 to host storage.us2.oraclecloud.com left intact
To solve this problem with select replication place on Oracle Public Cloud Service Console .
*************************************************************************************
1.Please look service console screen and to find replication policy .
2.Please select city which you want .
3.Please confirm your selection and don’t forget this policy cannot be changed .
*************************************************************************************

3.Verify your service is ready or not .
curl -v -s -X GET -H “X-Auth-Token: AUTH_tkb24e42debe0154c71d19f69586f25967” https://storage.us2.oraclecloud.com/v1/Storage-usthetalen/test
D:\curl_7_51_0_openssl_nghttp2_x64>curl -v -s -X GET -H “X-Auth-Token: AUTH_tkb2
4e42debe0154c71d19f69586f25967” https://storage.us2.oraclecloud.com/v1/Storage-u
sthetalen/test
* Trying 129.152.172.3…
* TCP_NODELAY set
* Connected to storage.us2.oraclecloud.com (129.152.172.3) port 443 (#0)
* ALPN, offering h2
* ALPN, offering http/1.1
* Cipher selection: ALL:!EXPORT:!EXPORT40:!EXPORT56:!aNULL:!LOW:!RC4:@STRENGTH
* successfully set certificate verify locations:
* CAfile: D:\curl_7_51_0_openssl_nghttp2_x64\ca-bundle.crt
CApath: none
* TLSv1.2 (OUT), TLS header, Certificate Status (22):
* TLSv1.2 (OUT), TLS handshake, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Server hello (2):
* TLSv1.2 (IN), TLS handshake, Certificate (11):
* TLSv1.2 (IN), TLS handshake, Server finished (14):
* TLSv1.2 (OUT), TLS handshake, Client key exchange (16):
* TLSv1.2 (OUT), TLS change cipher, Client hello (1):
* TLSv1.2 (OUT), TLS handshake, Finished (20):
* TLSv1.2 (IN), TLS change cipher, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Finished (20):
Okcan Yasin Saygılı
* SSL connection using TLSv1.2 / AES128-SHA
* ALPN, server did not agree to a protocol
* Server certificate:
* subject: C=US; ST=California; L=Redwood Shores; O=Oracle Corporation; CN=*.us
2.oraclecloud.com
* start date: Dec 8 00:00:00 2015 GMT
* expire date: Jan 6 23:59:59 2017 GMT
* subjectAltName: host “storage.us2.oraclecloud.com” matched cert’s “*.us2.orac
lecloud.com”
* issuer: C=US; O=Symantec Corporation; OU=Symantec Trust Network; CN=Symantec
Class 3 Secure Server CA – G4
* SSL certificate verify ok.
> GET /v1/Storage-usthetalen/test HTTP/1.1
> Host: storage.us2.oraclecloud.com
> User-Agent: curl/7.51.0
> Accept: */*
> X-Auth-Token: AUTH_tkb24e42debe0154c71d19f69586f25967
>
< HTTP/1.1 204 No Content
< X-Container-Object-Count: 0
< X-Container-Write: usthetalen.Storage.Storage_ReadWriteGroup
< Accept-Ranges: bytes
< X-Timestamp: 1479110585.37577
< X-Container-Read: usthetalen.Storage.Storage_ReadOnlyGroup,usthetalen.Storage.
Storage_ReadWriteGroup
Okcan Yasin Saygılı
< X-Container-Bytes-Used: 0
< X-Trans-Id: txa2ca1da6aa9e4d75bd47e-005829730dga
< Date: Mon, 14 Nov 2016 08:17:17 GMT
< Connection: keep-alive
< X-Storage-Class: Standard
< X-Container-Meta-Policy-Georeplication: us2-us6
< X-Last-Modified-Timestamp: 1479110585.21201
< Content-Type: text/html;charset=UTF-8
< Server: Oracle-Storage-Cloud-Service
<
* Curl_http_done: called premature == 0
* Connection #0 to host storage.us2.oraclecloud.com left intact

4.Post data on api .
curl -v -k -X PUT -H “X-Auth-Token: AUTH_tkb24e42debe0154c71d19f69586f25967” -T table.txt https://storage.us2.oraclecloud.com/v1/Storage-usthetalen/test/table.txt
D:\curl_7_51_0_openssl_nghttp2_x64>curl -v -k -X PUT -H “X-Auth-Token: AUTH_tkb2
4e42debe0154c71d19f69586f25967” -T table.txt https://storage.us2.oraclecloud.com
/v1/Storage-usthetalen/test/table.txt
* Trying 129.152.172.3…
* TCP_NODELAY set
* Connected to storage.us2.oraclecloud.com (129.152.172.3) port 443 (#0)
* ALPN, offering h2
* ALPN, offering http/1.1
* Cipher selection: ALL:!EXPORT:!EXPORT40:!EXPORT56:!aNULL:!LOW:!RC4:@STRENGTH
Okcan Yasin Saygılı
* TLSv1.2 (OUT), TLS header, Certificate Status (22):
* TLSv1.2 (OUT), TLS handshake, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Server hello (2):
* TLSv1.2 (IN), TLS handshake, Certificate (11):
* TLSv1.2 (IN), TLS handshake, Server finished (14):
* TLSv1.2 (OUT), TLS handshake, Client key exchange (16):
* TLSv1.2 (OUT), TLS change cipher, Client hello (1):
* TLSv1.2 (OUT), TLS handshake, Finished (20):
* TLSv1.2 (IN), TLS change cipher, Client hello (1):
* TLSv1.2 (IN), TLS handshake, Finished (20):
* SSL connection using TLSv1.2 / AES128-SHA
* ALPN, server did not agree to a protocol
* Server certificate:
* subject: C=US; ST=California; L=Redwood Shores; O=Oracle Corporation; CN=*.us
2.oraclecloud.com
* start date: Dec 8 00:00:00 2015 GMT
* expire date: Jan 6 23:59:59 2017 GMT
* issuer: C=US; O=Symantec Corporation; OU=Symantec Trust Network; CN=Symantec
Class 3 Secure Server CA – G4
* SSL certificate verify result: unable to get local issuer certificate (20), c
ontinuing anyway.
> PUT /v1/Storage-usthetalen/test/table.txt HTTP/1.1
> Host: storage.us2.oraclecloud.com
> User-Agent: curl/7.51.0
> Accept: */*
Okcan Yasin Saygılı
> X-Auth-Token: AUTH_tkb24e42debe0154c71d19f69586f25967
> Content-Length: 0
>
< HTTP/1.1 201 Created
< Etag: d41d8cd98f00b204e9800998ecf8427e
< Connection: keep-alive
< Last-Modified: Mon, 14 Nov 2016 08:21:57 GMT
< X-Trans-Id: tx0b221562fdf44e7987dc2-0058297424ga
< Date: Mon, 14 Nov 2016 08:21:56 GMT
< X-Last-Modified-Timestamp: 1479111716.23776
< Content-Type: text/html;charset=UTF-8
< Content-Length: 0
< Server: Oracle-Storage-Cloud-Service
<
* Curl_http_done: called premature == 0
* Connection #0 to host storage.us2.oraclecloud.com left intact

Refrences
1. http://www.cloudberrylab.com/blog/how-to-use-cloudberry-explorer-with-oracle-cloud-storage/
2. https://blogs.oracle.com/OracleCloud4Developers/entry/cloudberry_setup_for_oracle_storage
3. https://www.youtube.com/watch?v=9nRF0Hq-CLQ
4. http://blog.dbi-services.com/how-to-manage-your-containers-in-oracle-storage-cloud-service/
and another docs

Primavera Unifier on Oracle Public Cloud Database Part:3 (Writer : Okcan Yasin Saygılı – Selçuk Gülderen)

Filed under: Uncategorized — yasinsaygili @ 3:35 pm

31.Show up your configurations.

32.Please create new domain for Unifier.( C:\Oracle\Middleware\Oracle_Home1\oracle_common\common\bin)

33.Please Configure your Unifier Configurator .Please write compter fullname for internal name .

  1. Please create these folder for Unifier.

35.Please fill in the blanks with your database details.

36.Please fill your mail details.

37.Save the systems .

38.Please build EAR with above button.

39.Please write your details on Unifier setenv.bat (in Unifier’s weblogic folder)( D:\V77738-01\Primavera_Unifier_15.2\unifier_15.2.0.0\weblogic)

40.Please Click deploy.bat (D:\V77738-01\Primavera_Unifier_15.2\unifier_15.2.0.0\weblogic)

References

  1. https://primaveraworld.com/2016/02/04/installation-of-primavera-unifier-v15-2-part-1/
  2. https://primaveraworld.com/2016/02/14/installation-of-primavera-unifier-v15-2-part-2/
  3. https://primaveraworld.com/2016/02/20/installation-of-primavera-unifier-v15-2-part-3/
  4. oracle.com
  5. https://primaveraworld.com
  6. I couldn’t remember other references.

Primavera Unifier on Oracle Public Cloud Database Part:1 (Writer : Okcan Yasin Saygılı – Selçuk Gülderen)

Filed under: Uncategorized — yasinsaygili @ 3:35 pm

As know that Oracle Unifier is top tool which is project management.After Cloud acceleration , Oracle Unifier is planned to migrate database from on-premise to Cloud .This docs aim to guide all of installation about Unifier application on Oracle Public Cloud database .There is a topology related this upgrade . Let’s check it out .

1.Configuration of  Oracle DBaaS (P.S. Generated Public and Private Key )

2.Installation  of Weblogic 12.1.3

3.Configuration of Unifer’s component

1.Create database service for adopting our application .

2.Please select service level .

3.Please select software release , Oracle 11g is selected in this tutorial .

4.Please select EE edition .

5.Please fill in the blanks with your details and please paste public key from puttygen to ssh public key on DBaaS.

5.1. Open puttygen and generate key with generate button .

5.2.Please copy of above public key and save private key with below button .

  1. Service is created . Please check it out status of your service .However , service is created after that this service’s status is runing .

7.Please write your Ip address .

8.Please fill username with “oracle” .

 

9.Please select SSH version with “2”.

10.Please select Auth and browse generated .ppk key .

 

11.Please fill source port and destination with your Ip address and port.

12.Please select session and save all of settings .

  1. Please select your machine .

 

14.Please check it out status of your machine .

Primavera Unifier on Oracle Public Cloud Database Part:2 (Writer : Okcan Yasin Saygılı – Selçuk Gülderen)

Filed under: Uncategorized — yasinsaygili @ 3:35 pm

 

  1. Please Click Cloud Compute Service .
  1. Please Click Network and adjusted as required .Please set as disable at listener .
  1. Please Click Network and adjusted as required .Please give permission with permit on the application.

18.Please give permission your port and add your required port .

19.Please run these queries .

[oracle@Primavera-Database ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 12 20:25:06 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn sys/oracle as sysdba;

Connected.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

[oracle@Primavera-Database ORCL]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 12 20:27:34 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn sys/oracle as sysdba

Connected.

SQL> CREATE SMALLFILE TABLESPACE “UNIFIER” DATAFILE ‘/u02/app/oracle/oradata/ORCL/unifier001’ SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

SQL> SQL> CREATE SMALLFILE TEMPORARY TABLESPACE “UNIFIER_TMP” TEMPFILE ‘/u02/app/oracle/oradata/ORCL/unifier_tmp’ SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M ;

Tablespace created.

SQL> SQL> CREATE USER “UNIFIER” PROFILE “DEFAULT” IDENTIFIED BY “oracle” DEFAULT TABLESPACE “UNIFIER” TEMPORARY TABLESPACE “UNIFIER_TMP” ACCOUNT UNLOCK;

User created.

SQL> GRANT CREATE TABLE TO “UNIFIER”;

Grant succeeded.

SQL> GRANT CREATE VIEW TO “UNIFIER”;

Grant succeeded.

SQL> GRANT “CONNECT” TO “UNIFIER”;

Grant succeeded.

SQL> GRANT “RESOURCE” TO “UNIFIER”;

Grant succeeded.

20.Please move your sqlnet.ora file .

21.Please add your listener .

22.Install Weblogic with setup.exe

23.Finish your installation .

24.Please create domain .

25.Please select domain .

26.Please create weblogic account .

27.Please select domain mode .

28.Please select server mode .

30.Finish .

Blog at WordPress.com.