You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from the command line. First, the adump directory needs to be created. You can create a directory on all nodes as follows. [crayon-5bf19506424b1682253742/] With DBCA, you can create your rac database […]
If Goldengate doesn’t start with errors like this, the solution is very easy. Possible errors: Not enough database memory to honor requested MAX_SGA_SIZE of 400. PROCESS ABENDING. Solution: Set the parameters for streams_pool_size and shared_pool_size. streams_pool_size must be greater than the size specified in the error (400 in the example above). Then restart the […]
With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates Log Backup. If you type ‘D’ in this section, you can see the last full backup date, if you type ‘G’, you can see the latest differential backup date. If […]
One of the information I needed most is the file version. You can learn this in unix systems with the following command. [crayon-5bf1950642bcb283034550/]
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to determine our standards and to perform our controls automatically. For example, we can create a policy for control purposes so that the names of our stored procedures do not start […]
If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on explain” before running the query. [crayon-5bf1950642d67982248679/]
First of all, don’t forget to take backup for the security of your data. You can change the database’s collation with the following code. [crayon-5bf1950642efe537225817/] However, the database collation change does not apply to existing tables and columns. If you want to make the same change for existing tables and all columns, you […]
Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the client sent to MySQL and how MySQL responds? Then we can capture network packets of the client and MySQL server. Preparing: Capturer tool: tcpdump command on Linux Packets Analyzer: […]
You can find the queries that are run in the database from v$sql, v$sql_text views, and who are running from sys.all_users. You can create queries by associating v$sql, v$sql_text views and sys.all_users. The sample query is as follows. [crayon-5bf19506432c0628855230/]
Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test and you have an instance named testinstance on your test server. You can normally connect to Instance as “test\testinstance”. Suppose that the name of the test server is changed […]
