Database Experts: Microsoft SQL Server 2005/2008:Create Read Only Us...

Database Experts: Microsoft SQL Server 2005/2008:Create Read Only Us...: 1.Create Read Only User. CREATE LOGIN [ ROUser ] WITH PASSWORD=N''*****', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHE...

Comments

Post a Comment

Dear User,

Thank you very much for your kind response

Popular posts from this blog

Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL

Image
Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL  APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and later Information in this document applies to any platform. GOAL  How to purge the  UNIFIED_AUDIT_TRAIL table ? SOLUTION The unified audit trail can be purged using the DBMS_AUDIT_MGMT package:  qlplus / as sysdba SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------       2619 SQL>  BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( audit_trail_type         =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp  =>  FALSE); END; / PL/SQL procedure successfully completed. SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------          1 You can also use the last_arch_timestamp, if you don't want to purge all ...
Read more

Oracle 11g:Upgrade 11.2.0.x version to latest 11.2.0.4.1 patchset:Upgrade

Image
Oracle 11g:Upgrade 11.2.0.x version  to latest 11.2.0.4.1 patchset:Upgrade  Once We finish the installation of 11.2.0.4 on different then we will go further for upgrade database. For Installation, http://oracle-mssql-dba.blogspot.in/2014/07/oracle-11gupgrade-1120x-version-to.html Step 2.Run Pre-upgrade Information Tool  SQL>spool /utlu112i.log SQL>@ORACLE_HOME/rdbms/admin/utlu112i.sql Check timezone .Need to upgrade if it is require by tool. Step 3.Run dbupgdiag.sql.Check any invalid objects in dba_registry. Valid all Dba_registry object by running utlrp.sql sql>sqlplus / as sysdba sql>@?/rdbms/admin/utlrp.sql Step 4.Backup database. a)take rman backup with latest spfile & controlfile. b)take cold backup by mount the database after shutdown normal db. Step 5.Shut down database normal. SQL>shutdown normal. Step 6.Set New Oracle_HOME,PATH,LIBRARY_PATH.Copy tnsnames.ora,listener.ora,spfile,pfile & password to n...
Read more

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Image
Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c This document is prepared for monitoring windows server where sql server installed.Mostly used OEM for monitoring databases. In this document we will cover agent installation with target addition into OEM 12c. We will also cover prerequisite like enabling port for communication from agent to oms server Agent Installation on windows server  As a part of installation, we require to fulfil prerequisite like connectivity between OEM server and Window server. For Port opening and communication between two servers Ports required to open : 4903 , 7799 , 3872 Following steps require doing for manually installation of Agent in Windows server. Verifying if the agent exists on OMS. To begin, open your Cloud Control and go to "Setup -> Extensibility -> Self Update". Open the "Agent Software" folder and check if the Agent Software of Windows x64 is with statu...
Read more