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 .

November 10, 2016

Extend Data Storage Area on DBaaS

Filed under: Cloud,DBaaS — yasinsaygili @ 7:18 am

Today , I would like to show how to scale up for storage area . Sometimes need to expand our storage area hence you can do it with a few steps .

1.Please select machine which is needed to the machine disk.

machines.PNG

2.Please select symbol at right side .

machine.jpg

3.Please select Scale Up/Down

scaleup.jpg

4.Please select Add Storage to “Extend Data Storage Volume” or “Extend Backup Storage Volume”

Scaleup2jpg2.jpg

Tips and Tricks for Connecting DBaaS

Filed under: Uncategorized — yasinsaygili @ 7:17 am
Tags: ,

##As known that cloud is everywhere .  Up to now all of vendors decided to build new generation solutions through Cloud .Nonetheless on-premise , Oracle is growing up with Oracle Cloud . Particularly , Oracle DBaaS , Oracle Backup Service .##

DBaaS is being anounced at 2015 and  DBaaS is  released by Oracle . Machines can be served by DBaaS , To put it another way DBaaS is serving machines for using database in machine.Machines are assigned IP adress and all of users can connect to machines through ssh connections .Today , figure out how to connect to system .

1.Firstly start PUTTY

Capture1.PNG

2. Click to Data Section .

Capture2.PNG

3. Please click SSH section .

Capture3.PNG

4. Click to Auth section and in addition to browse and select the private key.

Capture4.PNG

5.Please write source port and destination

Capture6.PNG

6. Don’t forget to save all details .

Today , all of details are learned related putty connection .

 

 

 

 

 

 

 

 

 

 

September 6, 2016

Partner Webcast – Oracle PaaS: Exadata Database on Cloud

Filed under: Cloud,Exadata,Uncategorized — yasinsaygili @ 8:03 am

the webcast was delivered with my colleagues who is Thanos .

 

August 15, 2016

Connecting DBaaS with WinSCP

Filed under: Cloud,DBaaS,Uncategorized — yasinsaygili @ 2:24 pm

As known that all of DBaaS machines work  and Oracle DBA need to move data from on-premise to cloud .Hence , WinSCP is needed .Today , I would like to show this structure .

1.Start WinSCP and write Host name…

Capture7.PNG

2. Please click advance ..

Capture8.PNG

3.Please select Authentication section and select private key .

Capture9.PNG

4. Finally , select Login .

Capture10.PNG

Consequently , with afew clicks data can be moved with WinSCP  .

 

 

Next Page »

Blog at WordPress.com.