Category Archives: Windows

Oracle crtice – ili kako da ja to nekako sažvaćem :-)

Posted on October 17, 2018 by

Redo Log – The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has … Continue reading →

Posted in Linux, Unix, Windows | Tagged | Leave a comment

SCOM alerts

Posted on October 5, 2018 by

Razni alerti koji se javljaju pod SCOM-om, i šta raditi po tim pitanjima. 1. Max Concurrent API reached in Server XYZ MaxConcurrentApi is a registry key which specifies the maximum number of simultaneous, logon-related, application programming interface (API) calls that … Continue reading →

Posted in Windows | Tagged , | Leave a comment

MS SQL upozorenje “average wait time (ms) too high”

Posted on September 13, 2018 by

Na šta treba obratiti pažnju kada se ovo upozorenje javi : 0. Proveriti “potrošnju” za RAM i CPU, ako su u okviru granica, nastaviti dalje 🙂 1. Koliko često se javlja 2. Koja je prosečna vrednost čekanja 3. Koliki je … Continue reading →

Posted in Windows | Tagged , , | Leave a comment

Virtuelni WIN serveri i njihova memorija – objašnjenje

Posted on September 12, 2018 by

Deo izlaza iz WIN komande “msinfo32” : —– Installed Physical Memory (RAM) Not Available U pitanju je virtielna mašina, pa nema instalirani HW RAM Total Physical Memory 10.0 GB Available Physical Memory 449 MB Ovo je količina SLOBODNE memorije koja … Continue reading →

Posted in Windows | Tagged , | Leave a comment

MS SQL i memorija/stanje sistema/baze

Posted on September 10, 2018 by

Neke skraćenice vezane za MS SQL i memoriju : PLE – page life expectancy DMV – dynamic management views (od SQL Servera 2005) DMF – dynamic management functions. DMV/DMF returns SQL Server runtime state information that can be used to … Continue reading →

Posted in Windows | Tagged , | Leave a comment

Memorija na WIN 2008 i sličnim serverima

Posted on September 5, 2018 by

Hardverska instalirana memorija na serveru se može videti ovako : My Computer/desni klik/Properties, pod stavkom System : Ali postoji i “available” memorija, koja bazično označava količinu memorije koja NIJE u tom trenutku iskorišćena. Memorija se može videti komandom “msinfo32” : … Continue reading →

Posted in Windows | Tagged , , | Leave a comment

SCOM i njegov agent na WIN 2008 serveru

Posted on September 3, 2018 by

Kada se javi problem sa radom SCOM agenta na WIN serveru, treba proveriti njegovo zdravlje. Evo kako. Ide se kroz SCOM (znači ništa se ne gleda na samom WIN serveru (sem logova)!!!! WIN server Operations Manager logovi : SCOM : … Continue reading →

Posted in Windows | Tagged , , , | Leave a comment

Oracle na WIN 7, problemi sa konekcijom preko Oracle SQL Developer-a (2)

Posted on August 30, 2018 by

Koristim ovaj Oracle tutorial. ########## Sada treeba da napravim konekciju kroz “Oracle SQL Developer” na moju lokalnu mašinu, sa nalogom “hr” (videti predhodni post) Javlja mi se greška : “ORA-01031 insufficient privileges” Moguće rešenje 1 : setovala sam mu lozinku … Continue reading →

Posted in Uncategorized, Windows | Tagged , , | Leave a comment

Kako videti šta ima od Oracle-a na lokalnoj mašini (WIN 7) (1)

Posted on August 30, 2018 by

Videti čega ima pod My Computer/Manage/Services Koristiti SQL upit da se vide detalji.   Napomena : Paziti da lokalni nalog koji se koristi bude u ove dve grupe : Administrators i ORA_DBA (Control Panel/User Accounts/Manage User Accounts/Properties/Advanced i tu željenom … Continue reading →

Posted in Windows | Tagged , , | Leave a comment

Podaci o MS OS na remote serveru

Posted on August 30, 2018 by

Ovo može, samo ako ste u comandnoj liniji logovani kao domenski user, sa nalogom koji ima prava da vidi ove podatke (označila sam podatke koji su meni bitni) : C:\>systeminfo /s tsaprojectm Host Name: MOJ.SERVEROS Name: Microsoft Windows Server 2012 … Continue reading →

Posted in Windows | Tagged , , | Leave a comment