alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: October 2013
http://alexzy.blogspot.com/2013_10_01_archive.html
List databases from OEM with pivoting PROPERTY NAME to columns. Environment: OEM12, Oracle database 11.2. SELECT T.TARGET NAME, P1.PROPERTY NAME, P1.PROPERTY VALUE. FROM SYSMAN.MGMT TARGETS T, SYSMAN.MGMT TARGET PROPERTIES P1. WHERE T.TARGET TYPE='oracle database'. AND TTARGET GUID = P1.TARGET GUID. AND NOT EXISTS (SELECT 1 FROM MGMT BLACKOUT FLAT TARGETS B WHERE T.TARGET GUID = B.TARGET GUID). AND UPPER(T.TARGET NAME) LIKE '%'. Filter by database name. ORDER BY 1;. Posted by Alexander Zy.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: Modifying collection schedule for OEM metric Tablespace Allocation.
http://alexzy.blogspot.com/2014/11/modifying-collection-schedule-for-oem.html
Modifying collection schedule for OEM metric Tablespace Allocation. Oracle DB 11.2, Standard Edition One with DB console. Windows 2003 R2, 32bit. Default metric (Tablespace Allocation) collection interval is "Every 7 Days", which can be found on page "All Metrics" in DB console. Go to %ORACLE HOME% sysman admin default collection. And edit file database.xmlp. Find "Category: Tablespace Allocation" and few rows down:. IntervalSchedule INTERVAL="7" TIME UNIT="Day". Restart the oracle agent.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: September 2012
http://alexzy.blogspot.com/2012_09_01_archive.html
Cloning Oracle 11.2 database installation on Solaris. Oracle 11.2.0.2, Solaris 10. Packing Source Oracle Home. Export CLONE=/oracle/stage/clone11.2.0.2. Optionally you can create Exclude List for tar command to exclude some files from source home. Find -name "*.log" $CLONE/ExcludeList.txt. Find -name "*.err" $CLONE/ExcludeList.txt. Find /assistants/dbca/templates $CLONE/ExcludeList.txt. Find /network/admin $CLONE/ExcludeList.txt. Check your Exclude file:. Check or create oraInst.loc. Check known issues in.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: September 2014
http://alexzy.blogspot.com/2014_09_01_archive.html
Configuring Oracle Database 11g Gateway for ODBC MS SQL Server. Oracle database 11.2. Oracle Linux Server release 5.7. Microsoft ODBC Driver 11 for SQL Server - RedHat Linux. Microsoft SQL Server 2005,2008R2. Install the driver according to MS http:/ www.microsoft.com/en-us/download/details.aspx? To verify that the ODBC Driver on Linux was registered successfully, execute the following command:. Odbcinst -q -d -n "ODBC Driver 11 for SQL Server". Edit /.odbc.ini. Driver=ODBC Driver 11 for SQL Server.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: Configuring Oracle Database 11g Gateway for ODBC MS SQL Server
http://alexzy.blogspot.com/2014/09/configuring-oracle-database-11g-gateway.html
Configuring Oracle Database 11g Gateway for ODBC MS SQL Server. Oracle database 11.2. Oracle Linux Server release 5.7. Microsoft ODBC Driver 11 for SQL Server - RedHat Linux. Microsoft SQL Server 2005,2008R2. Install the driver according to MS http:/ www.microsoft.com/en-us/download/details.aspx? To verify that the ODBC Driver on Linux was registered successfully, execute the following command:. Odbcinst -q -d -n "ODBC Driver 11 for SQL Server". Edit /.odbc.ini. Driver=ODBC Driver 11 for SQL Server.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: SQLNET AUTHENTICATION_SERVICES in Windows environment
http://alexzy.blogspot.com/2014/03/sqlnet-authenticationservices-in.html
SQLNET AUTHENTICATION SERVICES in Windows environment. Windows Server 2003 R2, Oracle 11.2.0.4. Windows service OracleServiceSID is up. Windows account is added in local group ORA DBA. Oracle password file is created. SQLNET.AUTHENTICATION SERVICES in sqlnet.ora on server. ORA-01017: invalid username/password; logon denied. ORA-12641: Authentication service failed to initialize. Local: sqlplus sys as sysdba. ORA-12641: Authentication service failed to initialize. Local: sqlplus sys@tnsname as sysdba.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: January 2014
http://alexzy.blogspot.com/2014_01_01_archive.html
Using Oracle collection instead of cursor. Oracle 11.2.0.3. ORA-01555 "Snapshot too old" occurs when "fetch across commits" is used (committing inside of open cursor loop). Possible solution is to use Oracle collection instead of cursor:. TYPE nested typ IS TABLE OF NUMBER;. T1 nested typ;. Select AGENT INSURER ID BULK COLLECT into t1. FOR i IN t1.FIRST.t1.LAST LOOP. DBMS OUTPUT.PUT LINE('ROW NUM: ' i ' AGENT INSURER ID: ' t1(i) ;. Which has COMMIT inside. Posted by Alexander Zy. View my complete profile.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: CPU and system info on Windows
http://alexzy.blogspot.com/2014/08/cpu-and-system-info-on-windows.html
CPU and system info on Windows. Just few examples of wmic utility to get CPU and system info. Wmic cpu get /format:list. Wmic cpu list full /format:list. To get some particular field. Wmic cpu get deviceid,SocketDesignation. Wmic COMPUTERSYSTEM list full /format:list. Wmic COMPUTERSYSTEM get name,model,NumberOfProcessors /format:list. Use /S to connect to remote host. Posted by Alexander Zy. Subscribe to: Post Comments (Atom). Regular expressions for CSV files. CPU and system info on Windows.
alexzy.blogspot.com
IIR Solutions - Oracle DBA blog: October 2012
http://alexzy.blogspot.com/2012_10_01_archive.html
Oracle Enterprise Manager (OEM) Grid Control 11.1. This report shows backup jobs scheduled in the given time interval. It also shows HOST name and IP address of the database target which is handy for preparing for network, server or co-location outages. Modify parameters in the end of the SQL. The report looks for NEXT execution time (not all future ones). If a job is supposed to run before the given interval as well as in the interval, it will not appear in the report. Ttarget type, t.target guid. Selec...
SOCIAL ENGAGEMENT