MCP Club Tbilisi Event - September 11, 2014

by Sandro Galdava 3. September 2014 16:23


მოხარული ვართ შეგატყობინოთ, რომ 11 სექტემბერს 18:00 საათზე დაგეგმილია MCP Club Tbilisi-ს მორიგი IT Pro სემინარი!
 
განხილული იქნება შემდეგი თემები:
 
Microsoft Disaster Recovery and High Availability Solutions Overview 
Alexey Vasiliev (Orient Logic)
 
SharePoint 2013 Overview
Sergey Polyakov (WebZavod)
 
Azure Overview 
Arman Obosyan (Microsoft)
 

სემინარზე დასასწრებად გთხოვთ შეავსოთ მარტივი სარეგისტრაციო ფორმა შემდეგ ბმულზე: http://mcpclubtbilisi.azurewebsites.net/?p=52

ჩატარების ადგილი: მერაბ კოსტავას ქუჩა 47/57 (კოორდინატები: 41.709968, 44.785586) (იხ. სურათი)

Click to Enlarge

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MCP Club Tbilisi ჩატარდება 29-ე აუდიტორიაში, რომელიც მდებარეობს შენობის მეორე სართულზე.

პატივისცემით

MCP Club Tbilisi

Tags:

Table level recovery in Oracle 12c

by Vazha Mantua 7. October 2013 17:44

Good Day,

One major new features in Oracle 12c in new RMAN feature named table level recovery . With 12c R1, you can recover a particular table or partition to a point-in-time or SCN from RMAN backups in the event of a table drop or truncate.

I test new feature on Linux x64_86 platform.  As I understood procedure of restore is

1. Backup database

2. Create an auxiliary database and recovers the specified tables or table partitions, until the specified point in time, into this auxiliary database

3. Make export of table from auxiliary database with data pump.

4. Make import to Source DB with data pump

5. Drop temporary auxiliary database .

-----------------------------------------------------------------------------------------------------

Let’s Begin, we have  made this example for : Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production, Single instance, archive mode.

set DB_RECOVERY_FILE_DEST parameter:

SQL> alter system set DB_RECOVERY_FILE_DEST=’/u1/oradata/backup’ scope=both;

create table, which we should restore from RMAN backup:

SQL> create table vazha.clients_12c as select * from dba_users; (table should not be in system and sysaux TBS!)

now we should make backup of DB:

export ORACLE_SID=ORA12C

rman target /

RMAN> backup database;

After finishing backup you can drop table from source DB ORA12C with command

SQL> drop table vazha.clients_12c;

 

-----------------------------------------------------------------------------------------------------

So now we can restore table from RMAN backup:

find last SCN which is on RMAN backup, you can find it with command list backup

RMAN> List backup;

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.20G      DISK        00:01:32     07-OCT-13     
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20131007T165002
        Piece Name: /u1/oradata/backup/ORA12C/backupset/2013_10_07/o1_mf_nnndf_TAG20131007T165002_955cj05c_.bkp
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1735782    07-OCT-13 /u1/oradata/ORA12C/system01.dbf
  3       Full 1735782    07-OCT-13 /u1/oradata/ORA12C/sysaux01.dbf
  4       Full 1735782    07-OCT-13 /u1/oradata/ORA12C/undotbs01.dbf
  6       Full 1735782    07-OCT-13 /u1/oradata/ORA12C/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    9.64M      DISK        00:00:05     07-OCT-13     
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20131007T165002
        Piece Name: /u1/oradata/backup/ORA12C/backupset/2013_10_07/o1_mf_ncsnf_TAG20131007T165002_955cm0jr_.bkp
  SPFILE Included: Modification time: 07-OCT-13
  SPFILE db_unique_name: ORA12C
  Control File Included: Ckp SCN: 1735826      Ckp time: 07-OCT-13

 

So you can restore table until SCN: 1735826.

For restoring table you should do:

export ORACLE_SID=ORA12C

rman target /

RMAN>recover table vazha.clients_12c until scn 1735826 auxiliary destination '/install/oracle/temp';

Oracle OS user should have privileges on directory /install/oracle/temp. on this destination RMAN create temporary database for exporting table.

 

That’s ALL.

Tags: , , ,

ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [56327]

by Vazha Mantua 4. October 2013 13:24

Good Day,

Today I restored database from 32-bit Linux machine to 64-bit. after opening database , there were a lot of errors like that:

ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327].

Solution of this problem is recompiles existing PL/SQL modules in the format required by the new database.

Step by step:

SQL> shutdown immediate;
SQL> startup upgrade;
SQL> @$ORACLE_HOME/rdbms/admin/utlirp;
SQL> shutdown immediate;
SQL> startup;
SQL> @@$ORACLE_HOME/rdbms/admin/utlrp;

Tags: , , , , , ,

Flush Single SQL statement from shared pool

by Vaja Mantua 16. September 2013 16:04

Sometime on database we observed SQL statements which change SQL_Plans, cause of this may be various situation, for example recalculation  table statistics, or bind mismatch, etc. Sometime we simple want to delete bad SQL_Plan from shared pool, of course we can do it with flushing whole shared pool, but the best way is flushing single SQL statement.

First of all we should find address and hash value of statement, with this command:

select address||','||hash_value
  from v$sqlarea
  where sql_id like '1u1hcw5c5t8r3';

after that, we copy results to argument to procedure sys.dbms_shared_pool.purge

Example

begin
   sys.dbms_shared_pool. purge('00000004FA8BA948,1482466019','C',1);
end;  

That’s all.

Tags:

გილოცავთ სისტემური ადმინისტატორის დღეს!

by Sandro Galdava 26. July 2013 14:48

Tags:

MVA - What's New in Windows Server 2012 R2 Jump Start

by Sandro Galdava 1. July 2013 15:48

windows_server_2012_r2_jump_start

 

 

Register today for this two-day, demo-rich Jump Start aimed at showing IT Pros the new capabilities and features of Windows Server 2012 R2. Join Microsoft Senior Technical Evangelist Rick Claus and Lead Architect & President of holSystems Corey Hynes as they go through details of Windows Server 2012 vs Windows Server 2012 R2. Get ready for this live online interactive experience highlighting the latest and greatest via numerous scenarios and demos all while answering questions from the audience.

Course outline:

Day 1
01 | Introducing Windows Server 2012 R2
02 | Server Virtualization in WS 2012 R2
03 | Cloud Optimized Networking in Windows Server 2012 R2
04 | Storage in Windows Server 2012 R2

Day 2
01 | Server Management & Automation with Windows Server 2012 R2
02 | VDI with Windows Server 2012 R2
03 | Access & Information Protection with Windows Server 2012
04 | Web Application & Platform with Windows Server 2012

Live Event Details
July 10 & 11, 2013
9:00am - 5:00pm (PDT)
Cost: Free
Audience: IT Professionals
Prerequisites: This Jump Start is tailored for IT Professionals who have a good understanding of  Windows Server 2012

Register Now: http://events.microsoftvirtualacademy.com/mvastartregistration.aspx?eid=327ce4d8-27ed-4d58-8183-8883e0e4c64c

Source: http://www.microsoftvirtualacademy.com/liveevents/Windows-Server-2012R2-Jump-Start

Tags:

MCP Club Tbilisi Event - June 28

by Sandro Galdava 20. June 2013 18:39


მოხარული ვართ შეგატყობინოთ, რომ 28 ივნისს 18:00 საათზე დაგეგმილია MCP Club Tbilisi-ს მორიგი IT Pro სემინარი!
 
განხილული იქნება შემდეგი თემები:
 
Introducing Microsoft Windows Server 2012 R2
Sandro Galdava (MCP Club Tbilisi Community Leader)
 
Protect Data in Hyper-V Virtual Environment Using Veeam
Oleksandr Yemets (კომპანია Veeam-ი, სისტემური ინჟინერი)
 
Microsoft Lync 2013 Overview
Giorgi Jambazishvili (სისტემური ინჟინერი)
 

სემინარზე დასასწრებად გთხოვთ შეავსოთ მარტივი სარეგისტრაციო ფორმა შემდეგ ბმულზე: http://mcpclubtbilisi.azurewebsites.net/?p=52

ჩატარების ადგილი: მერაბ კოსტავას ქუჩა 47/57 (კოორდინატები: 41.709968, 44.785586) (იხ. სურათი)

Click to Enlarge

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MCP Club Tbilisi ჩატარდება 29-ე აუდიტორიაში, რომელიც მდებარეობს შენობის მეორე სართულზე.

პატივისცემით

MCP Club Tbilisi

Tags: ,

IT Pro

24 Hours of PASS. Russian Edition

by Arman Obosyan 13. March 2013 10:14

 

24 Hours of PASS

24 Hours of PASS. Russian Edition

Запомните дату: 21 марта 2013. В этот день состоится вторая онлайн конференция "24 Hours of PASS. Russian Edition".

Регистрация на конференцию открыта.

http://www.sqlpass.org/24hours/russia2013/

 

 

Если вы пропустили прошлую конференцию, то на странице вы можете посмотреть не только обычную видеозапись, но и записи в формате Microsoft Office Live Meeting High-Fidelity Presentation.

Записи встречи и презентации размещены также на сайте http://www.techdays.ru/series/pass-2012

Tags:

Tclsh ping

by Besarion Giorgadze 25. January 2013 13:07

ქსელის დონეზე საბაზისო კავშირის შესამოწმებლად პირველრიგში ვიყენებთ ping-ს. cisco-ს CLI-ში ping-ის რამდენიმე მისამრთზე ერთდოულად ბუფერიდან გაშვება  შეუძლებელია. იმიტომ რომ cisco-ს CLI-ში buffer-იდან ბრძანებები სრულდება თანმიმდევრობით ანუ ეს იმას ნიშნავს რომ პირველი ბრძანება ჩაისხმება თუ არა მომენტალურად სრულება ის,ხოლო შემდეგი ბძანებების ჩასხმა და პირველი ბძანების შესრულება ერთდროულად მიმდინარეობს, რის შედეგადაც ვღებულობთ შემდეგ შედეგს, მომდევნო ბრძანებების სიმობოლოები შეიძლება საერთოდ არ მივიდეს CLI-იმდე ან თუ მივა ბრძანებას რაღაც სიმბოლოები აკლდეს.

მაგალითად როუტერზე გავუშვათ ბუფერიდან პინგი შემდეგ მისამართებზე.

ping 8.8.8.8
ping 8.8.4.4
ping 173.194.44.36
ping 75.140.41.225
ping 173.252.100.16

<><></></>

router#ping 8.8.8.8

Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 8.8.8.8, timeout is 2 seconds:
!!!!!
Success rate is 100 percent (5/5), round-trip min/avg/max = 68/68/68 ms
router#

მივიღებთ ზემოთ მოცემულ შედეგს, ანუ მხოლოდ 1 მისამრთზე შესრულდა. ამის ყველაზე მარტივი გადაწყვეტა შეიძლება ქვემოთ მოყვანილი tcl scipt-ით.

router#tclsh
router(tcl)#foreach ADD {
+>8.8.8.8
+>8.8.4.4
+>173.194.44.36
+>75.140.41.225
+>173.252.100.16
+>} { ping $ADD }

Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 8.8.8.8, timeout is 2 seconds:
!!!!!
Success rate is 100 percent (5/5), round-trip min/avg/max = 68/68/68 ms
Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 8.8.4.4, timeout is 2 seconds:
!!!!!
Success rate is 100 percent (5/5), round-trip min/avg/max = 68/68/68 ms
Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 173.194.44.36, timeout is 2 seconds:
!!!!!
Success rate is 100 percent (5/5), round-trip min/avg/max = 72/72/72 ms
Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 75.140.41.225, timeout is 2 seconds:
!!!!!
Success rate is 100 percent (5/5), round-trip min/avg/max = 244/247/252 ms
Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 173.252.100.16, timeout is 2 seconds:
!!!!!
Success rate is 100 percent (5/5), round-trip min/avg/max = 172/173/176 ms
router(tcl)#tclquit
router#

 

tcl script-ზე Ping-ის იმლემენტაციის  ბევრი ვარიანტი არსებობს შემდეგ მაგალითში შედეგის output-ი არის შეცვლილი. თუ პინგი გავა წერს IP მისამართს და statu-ს “OK”  ხოლო თუ პინგი არ გავა წერლს IP მისამართს და statu-ს “unreachable”.

router(tcl)#foreach ADDRESS {
+>   8.8.8.8
+>  8.8.4.4
+>  173.194.44.36
+>  75.140.41.225
+>  173.252.100.16
+>3.3.3.3
+>} {
+>
+>     set RESULT [exec "ping $ADDRESS repeat 5 timeout 1"];
+>     if {[regexp "!!!" $RESULT] } { puts "$ADDRESS OK"} else { puts "$ADDRESS Unreachable" } }
8.8.8.8 OK
8.8.4.4 OK
173.194.44.36 OK
75.140.41.225 OK
173.252.100.16 OK
3.3.3.3 Unreachable

Router(tcl)#

Tags: , ,

tcl scripts

OWA 2013 and Lync 2013 integration

by Giorgi Jambazishvili 14. January 2013 15:42

In this post I’ll describe how to integrate lync 2013 and owa 2013. Because of traffic between lync and exchange servers are encrypted you need certificates in both side (lync and exchange),
Lync 2013 certificate: During installation of lync server, there was one step where you assign certificate and this certificate will be used for integration, so you don’t need any additional certificate in lync infrastructure.
Exchange 2013 Certificate: you can use certificate that you already assigned to exchange server. you cannot use self sign certificate in exchange server during integration, because certificate that will be used in lync and exchange both must be trusted for all exchange and lync infrastructure servers.
Exchange side
I will create addition certificate for lync im integration: don’t use wildcard certificate, in alternative names you need all servers fqdn in exchange infrastructure, cas array name, webmail fqdns.
My Certificate friendly name will be Exchange IM Cert: alternative names will be e-15.domain.corp, mail.lab.community.ge (i will not add lync fqdn in certificate, it is not necessary )
my lync fqdn is lync2013.domain.corp. I will not assign exchange im certificate to any services, it’s not necessary to assign certificate to any service to use for im integration.

image image


 

image

After import Certificate in exchange server we must enable instantmessaging for lync to do this type in exchange console:

Get-OwaVirtualDirectory | Set-OwaVirtualDirectory –InstantMessagingEnabled
$True -InstantMessagingType OCS

we need also add in Web.config in C:\Program Files\Microsoft\Exchange Server\V15\ClientAccess\Owa
under <AppSettings>

image

<add key="IMCertificateThumbprint" value="3D1036F139BCDFE68F53546C766FAB9ECCD0387F"/> 
<add key="IMServerName" value="lync2013.domain.corp"/>

 

 

 

last step on exchange side


C:\Windows\System32\Inetsrv\Appcmd.exe recycle apppool /apppool.name:"MSExchangeOWAAppPool"

Lync Side
Create trusted application pool in topology builder
imageimage 

 

publish topolgy. after creating trusted application pool, we must create trusted application in this pool , to do this open lync shell and type

New-CsTrustedApplication -ApplicationId OutlookWebApp -TrustedApplicationPoolFqdn e-15.domain.corp -Port 5199

enable-topology

 

 

and at last in exhcange server  iisreset /noforce or you can restart server.

image

Tags: