Profile

Cover photo
Yury Velikanov
Works at Google
Attended Latvijas Universitate
Lives in Mountain View, California, US
458 followers|266,404 views
AboutPostsPhotosYouTube

Stream

Yury Velikanov

Shared publicly  - 
 
How about to meet on the other side of the glass door?
http://lmgtfy.com/?q=oracle+careers+at+google
1
Aaron Macks's profile photo
 
there's something amusingly circular about using LMGTFY to find things at google
Add a comment...

Yury Velikanov

Shared publicly  - 
 
Someone asked me: Do you suggest RAC certification and would it play a role in an employment process?

Sharing the conversation just because I think some of you may be interested in the answer 

Question: Hello Yury. I have some question about Oracle certification. I have OCP certificate and i'm thinking to take one more, RAC expert certificate. Employers which i had worked never asked me about my certification. And now I think need I one more certificate or not? I want to ask you. Employers in which you had worked asked you about your certificate?

My Answer: I would definitely go for the RAC certification. It is a very good and challenging exam. It is a good way to learn and master RAC related features. 

As to the employment. The certification may play or may not a role. If someone asked me to review a CV and I would see RAC relate certificate I will give to that person an initial advantage comparing to one who doesn't (I just know how challenging the exam is). However it will not be the decider. I would give certification ~5% in terms of CV evaluation.
1
Add a comment...

Yury Velikanov

Shared publicly  - 
 
Look. RAC Attack Ninjas having FUN! Who will join us at Collaborate 2014? :)
3
Add a comment...
 
Look my interview to +IOUG | Independent Oracle Users Group 

http://www.ioug.org/p/bl/et/blogid=40&blogaid=228

where I am talking about several things including:
-- If The Oracle ACE Program helped my career
-- What is my biggest achievement as of today
# It isn't a technical project, it is something else 
-- What is my biggest regret
-- Advice to you on how you can advance your career
2
Yunus SIMSEK's profile photoYury Velikanov's profile photo
2 comments
 
Yep. I do.
Add a comment...

Yury Velikanov

Shared publicly  - 
 
Look. We run into this lovely creature other day at my kids school :)
1
Add a comment...
Have him in circles
458 people
Ismail Aboussaad's profile photo
Samer Forzley's profile photo
Nandakumar T's profile photo
neal ke's profile photo
Steve Karam's profile photo
Olga Varvara's profile photo
Tanya Sakovsky's profile photo
Emin Guliyev's profile photo
Mouaz Alem's profile photo
 
Hello my Oracle DBA friends. Most of us know that it isn't advisable to use the default DB service name to connect to an Oracle database as it reduces workload management options. It is especially true in RAC environments.

I have created the following small after logon trigger to prevent client connecting to a database using the default service name. It may be way too hard option to use it in a production environment as it could stop your clients from connecting to a database. However if DEV or for a new systems it could be a good start :)

create or replace TRIGGER yve_SERV_LOGON_MON 
AFTER LOGON ON DATABASE
declare
-- v0.1 Initial version by yvelik on 04/06/2014
-- The trigger prevents default TNS service name to be used by clients to make sure that specific services are in use. Is specifically important to use custom service names in a RAC configuration.
-- The trigger allows exceptions to be introduced on host by host basis. To allow connections to the default host please insert a record to the yve_serv_login_hosts_ext table
-- Information about all sessions that used the default DB service name is logged under yve_serv_login_log table
-- If the trigger raises unhandled exception then a line in the alert log is inserted

--# Objects used by the trigger (create those objects at the same time as the trigger)
--# create table yve_serv_login_log as select * from gv$session where 1=2;
--# create table yve_serv_login_hosts_ext (host varchar2(100), whoinserted varchar2(100), wheninserted date, description varchar2(4000));
--# Example => insert into yve_serv_login_hosts_ext values ('db01.yuryfun.com','yvelik',sysdate,'This is database host that we may connect to the default service from');

v_db_unique_name v_$parameter.value%type;
v_comp_db_unique_name v_$parameter.value%type;
v_parm_service_name v_$parameter.value%type;
v_db_domain v_$parameter.value%type;
v_session v_$session%rowtype;
v_msg varchar2(4000);
v_host_count number;

default_service_in_use EXCEPTION;

BEGIN
-- Let's the other world know where the SQLs are comimg from
DBMS_APPLICATION_INFO.SET_MODULE ('yve_SERV_LOGON_MON',null); 
DBMS_APPLICATION_INFO.SET_CLIENT_INFO ('Logon trigger'); 
   
-- Select service name the session is connected to
select s.* into v_session from v$session s where sid=sys_context('USERENV', 'SID') and rownum<2;
-- Let’s check if hosts exception list. If the session comes the host in the list we don’t execute further checks
select count(host) into v_host_count from yve_serv_login_hosts_ext where HOST = v_session.machine;

if v_host_count = 0
then

  -- Select the default services name
  select p.value into v_db_unique_name from v$parameter p where name = 'db_unique_name';
  -- Select db_domain from parameters list
  select p.value into v_db_domain from v$parameter p where name = 'db_domain';
  -- Select service_names parameter list
  select p.value into v_parm_service_name from v$parameter p where name = 'service_names';

  -- There is a difference in naming depending if db_domain is set or not
  if v_db_domain is null 
  then v_comp_db_unique_name:=v_db_unique_name;
  else v_comp_db_unique_name:=v_db_unique_name||'.'||v_db_domain;
  end if;

  if upper(v_session.service_name) = upper(v_comp_db_unique_name)
  then
    RAISE default_service_in_use;
  end if;
end if;

-- Let's clean the application info
DBMS_APPLICATION_INFO.SET_MODULE (null, null); 
DBMS_APPLICATION_INFO.SET_CLIENT_INFO ( null ); 

EXCEPTION
WHEN default_service_in_use THEN
  -- For debug and log purposes. Let's record information about the session that uses the default TNS service
  insert into dbe_serv_login_log select * from gv$session where sid=sys_context('USERENV', 'SID') and inst_id=sys_context('USERENV', 'INSTANCE') and rownum<2;
commit;
  -- Raise an exception
  v_msg := 'yve_SERV_LOGON_MON Trigger: The session is not allowed to connects to the default TNS service '||v_session.service_name||'. Please use one of non-default services '||v_parm_service_name;
  RAISE_APPLICATION_ERROR (num=> -20042, msg=> v_msg);
WHEN OTHERS THEN
-- Let's report a problem in the alert log if there is an unhandled exception note: 2 = write to the alert log
dbms_system.ksdwrt(2, 'ORA-20042: AFTER LOGON trigger yve_SERV_LOGON_MON failed with an error: '||SQLERRM);
END;
/
4
3
Yury Velikanov's profile photoConnor McDonald's profile photoAndy Webster's profile photoJorge Donato's profile photo
2 comments
 
Good catch. IMHO: Should use v$session for that purpose. Let me fix the code :)
Add a comment...

Yury Velikanov

Shared publicly  - 
 
Look there are quite several Oracle positions opened at Google at the moment :)

https://www.google.com/about/jobs/search/#t=sq&q=j&d=oracle&li=10&j=oracle&na=JOBS_SEARCH&
2
Add a comment...

Yury Velikanov

Shared publicly  - 
 
Oracle Applications DBA wanted at Google (Mountain View)!

Hey folks! Do you want to work with an awesome team at Google? Here is your chance! Apply and who knows may be I have a pleasure to work with you together  

PS If you have any question do not hesitate to ask. If you think that someone from your friends may be interested feel free to share.

See more details under the following link! See you soon 
https://www.google.com/about/jobs/search/#!t=jo&jid=818002
2
Yunus SIMSEK's profile photo
 
Thank you Yury
Add a comment...

Yury Velikanov

Shared publicly  - 
 
“Oracle Infrastructure Middleware Engineer" position is opened at GOOGLE!

Do you want to work with me in the same team at Google ? Here is your chance!  Refresh your CV/RESUME and apply! Let dream to become true! I am looking forward to work with you in the same team! 

https://www.google.com/about/jobs/search/#!t=jo&jid=4355001&
1
1
Andraly Ng's profile photo
Add a comment...

Yury Velikanov

Shared publicly  - 
 
How to Download Oracle Software Using WGET?

I am sure many of my friends from Oracle area have their own solutions. Some of them are more elegant some less. Today two of my good friends sharing their great work in that space. André Araújo is talking about what options are available to download SW from Oracle sites Oracle Technology Network, eDelivery, MOS) and Maris Elsins shared his great script that allows you to download patches in CMD mode from My Oracle Support.

Feel free to share among your Oracle peers

How to Download Oracle Software Using WGET or CURL
from +André Araújo 
http://www.pythian.com/blog/how-to-download-oracle-software-using-wget-or-curl/

getMOSPatch.sh – Downloading Patches From My Oracle Support
from +Maris Elsins 
http://www.pythian.com/blog/getmospatch-sh-downloading-patches-from-my-oracle-support/
1
Add a comment...

Yury Velikanov

Shared publicly  - 
 
Just a quick on the document something that I forgot on regular basis:

Yury please remember "xdpyinfo" is a great command to check if X Server set ok (DYSPALY=:X). THX +John Piwowar.

This is a good alternative to xclock method. In case xclock isn't installed. Please feel free to share other options too :)

https://twitter.com/yvelik/status/397892421154902016


The output example:

xdpyinfo
name of display:    :45.0
version number:    11.0
vendor string:    The X.Org Foundation
vendor release number:    70101000
X.Org version: 7.1.1
maximum request size:  16777212 bytes
motion buffer size:  256
bitmap unit, bit order, padding:    32, LSBFirst, 32
image byte order:    LSBFirst
number of supported pixmap formats:    6
supported pixmap formats:
    depth 1, bits_per_pixel 1, scanline_pad 32
    depth 4, bits_per_pixel 8, scanline_pad 32
    depth 8, bits_per_pixel 8, scanline_pad 32
    depth 16, bits_per_pixel 16, scanline_pad 32
    depth 24, bits_per_pixel 32, scanline_pad 32
    depth 32, bits_per_pixel 32, scanline_pad 32
keycode range:    minimum 8, maximum 255
focus:  PointerRoot
number of extensions:    24
    BIG-REQUESTS
    DAMAGE
    DEC-XTRAP
    DOUBLE-BUFFER
    Extended-Visual-Information
    GLX
    MIT-SCREEN-SAVER
    MIT-SHM
    MIT-SUNDRY-NONSTANDARD
    RECORD
    RENDER
    SECURITY
    SGI-GLX
    SHAPE
    SYNC
    TOG-CUP
    VNC-EXTENSION
    X-Resource
    XC-APPGROUP
    XC-MISC
    XFIXES
    XFree86-Bigfont
    XTEST
    XVideo
default screen number:    0
number of screens:    1

screen #0:
  dimensions:    1024x768 pixels (260x195 millimeters)
  resolution:    100x100 dots per inch
  depths (7):    1, 4, 8, 16, 24, 32, 16
  root window id:    0x3a
  depth of root window:    16 planes
  number of colormaps:    minimum 1, maximum 1
  default colormap:    0x20
  default number of colormap cells:    64
  preallocated pixels:    black 0, white 65535
  options:    backing-store YES, save-unders YES
  largest cursor:    1024x768
  current input event mask:    0x400000
    PropertyChangeMask
  number of visuals:    4
  default visual id:  0x22
  visual:
    visual id:    0x22
    class:    TrueColor
    depth:    16 planes
    available colormap entries:    64 per subfield
    red, green, blue masks:    0xf800, 0x7e0, 0x1f
    significant bits in color specification:    8 bits
  visual:
    visual id:    0x23
    class:    TrueColor
    depth:    16 planes
    available colormap entries:    64 per subfield
    red, green, blue masks:    0xf800, 0x7e0, 0x1f
    significant bits in color specification:    8 bits
  visual:
    visual id:    0x24
    class:    TrueColor
    depth:    16 planes
    available colormap entries:    64 per subfield
    red, green, blue masks:    0xf800, 0x7e0, 0x1f
    significant bits in color specification:    8 bits
  visual:
    visual id:    0x25
    class:    TrueColor
    depth:    16 planes
    available colormap entries:    64 per subfield
    red, green, blue masks:    0xf800, 0x7e0, 0x1f
    significant bits in color specification:    8 bits
Instantly connect to what's most important to you. Follow your friends, experts, favorite celebrities, and breaking news.
1
Add a comment...

Yury Velikanov

Shared publicly  - 
 
Are you planning to attend UKOUG Tech conference in Manchester in less than 1 month time? 

Don't miss to attend OakTable sessions (free for all):
http://www.scaleabilities.co.uk/oaktable-world-uk-2013/

Pythian, Dbvisit, Scale Abilities
Scale Abilities is proud to be sponsoring the first independent OakTable World UK event along with co-sponsors Pythian and Dbvisit. The event is offered free of charge to all visitors to the UKOUG ...
3
Yury Velikanov's profile photo
 
Adding +Pythian, +Scale Abilities Ltd  and +Dbvisit Software Limited. Thanks for sponsoring the great community initiatives and groups :)
Add a comment...
People
Have him in circles
458 people
Ismail Aboussaad's profile photo
Samer Forzley's profile photo
Nandakumar T's profile photo
neal ke's profile photo
Steve Karam's profile photo
Olga Varvara's profile photo
Tanya Sakovsky's profile photo
Emin Guliyev's profile photo
Mouaz Alem's profile photo
Work
Occupation
Oracle DBA / Team Technical Lead
Skills
Data management using Oracle products
Employment
  • Google
    Database Engineer, 2014 - present
  • The Pythian Group
    Team Technical Lead / Oracle [Apps] DBA, 2009 - 2013
    Oracle Database and e-Business Suite technical management
  • Rolta TUSC Asia Pacific
    Lead Oracle DBA, 2009 - 2009
  • Tieto
    Senior Oracle Applications DBA, 2006 - 2009
  • DSP Global
    Oracle Applications DBA, 2006 - 2006
  • Solihull Council
    Senior Oracle DBA, 2005 - 2006
  • IT Alise
    Oracle [Apps] DBA, 1998 - 2006
  • Ministry of Internal Affairs of the Republic of Latvia
    Junior Oracle DBA, 1997 - 1998
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Mountain View, California, US
Previously
Sydney, Australia - Riga, Latvia - Solihull, England
Contact Information
Home
Skype
j.velikanovs
AIM
pythianvelikanov
Google Talk
j.velikanovs@gmail.com
Yahoo
pythianvelikanovs@yahoo.com
Story
Tagline
I like my job, I like what I do, I like to share knowledge, I like to help others to share knowledge, I like to learn, I like my job.
Introduction

Other notes:

  • I make typos. I do a lot of those. Please don't get offended
  • I appreciate if you try to spell my name right ;)
  • Please avoid calling me from 1am to 7am - Time zone information 

My favorite phrases:

  • "Someone who never admits they are wrong is dangerous." - from blog post
  • "We remember that constructive criticism is the door to improvement." - Pythian
  • "Your time is limited so don't waste it living someone else's life" - Steve Jobs
  • "Give feedback if you see someone do a good job for you. It helps him to keep going.Give me feedback if you don't like something I do. It helps me to improve :)" - me
  • "Today I will do what others won't so tomorrow I can do what others can't" - Jerry Rice (from Kamran Agayev's tweet)
  • "Thinking you know the answer is BAD!" - Jonathan Lewis (from Kamran Agayev's tweet)

Video work that I found inspirational:

Bragging rights
IT my hobby and work, Love my family, fishing, camping, community, socializing and social medai
Education
  • Latvijas Universitate
    Computer Science, 1999 - 2001
    System Design Object-Oriented Programming Object-Oriented Analysis and Modeling Office Automation Business Component Factory Oracle Design Tools Computer Networks Design and analysis of efficient algorithms Artificial Intelligence Business Process Reengineering
  • Riga Technical University
    Computer Science, 1996 - 1999
    Data Structures Object Oriented Programming Database Management Systems Operating Systems Algorithm and Program Design Software Development Technology Computer Architecture and Assembler Information System Design Technology Basics
Basic Information
Gender
Male
Looking for
Networking
Relationship
Married