Check Tablespace Location in PostgreSQL
oraHow - Howto Guides & Software Tutorials
by admin
4M ago
pg_tablespace_location(oid) function is used to check the path of PostgreSQL tablespace location on disk. Tablespace in postgres is the physical location on disk where all data files related to database objects like table and indexes are stored. Query to check Tablespace Location in PostgreSQL postgres=# select spcname ,pg_tablespace_location(oid) from pg_tablespace; Example: devdb=# select spcname ,pg_tablespace_location(oid) from pg_tablespace; spcname | pg_tablespace_location -------------+---------------------------------- pg_default | pg_global | devdefault | /pgdata/devda ..read more
Visit website
Alter Tablespace Add Datafile in Oracle
oraHow - Howto Guides & Software Tutorials
by admin
5M ago
To overcome tablespace full issue, you need to add datafile to the tablespace in Oracle otherwise you may face “ORA-01658: unable to create INITIAL extent for segment in tablespace” which means tablespace is full and datafile is unable to extend further. To oversome this issue, check the space allocated to the tablespace and add datafile to the tablespace. Check current tablespace utilization, initial size, maxsize, autoextensible etc. SQL> select file_name, bytes/1024/1024/1024, maxbytes/1024/1024/1024, autoextensible from dba_data_files where tablespace_name='ORAHOWDATA'; FILE_NAME ..read more
Visit website
IO Error: The Network Adapter could not establish the connection
oraHow - Howto Guides & Software Tutorials
by admin
5M ago
Test Failed: IO Error: The network Adapter could not establish the connection is very generic error which you will get while connecting via SQL Developer to the Oracle database. The resolution of this error is very simple. Below are the few checks you need to follow. Turn off the firewall worked in my case which is point no 3 mentioned below. 1: Check Listener status using below command. lsnrctl status Make sure listener.ora file has correct entry defined. It is located in $ORACLE_HOME/network/admin/listener.ora 2: Check tnsping [oracle@san-cs-test ~]$ tnsping DBRAID7 TNS Ping Utility for ..read more
Visit website
ERROR: [062]: stop file exists for stanza db
oraHow - Howto Guides & Software Tutorials
by admin
5M ago
You might have faced this error while creating or deleting staza in pgBackrest. I got this error while creating stanza as shown below: bash-4.4$ pgbackrest stanza-create --stanza=db --repo1-path=/pgbackrest/postgres-operator/backup/repo1-bkq --To update new repo path. ERROR: [062]: stop file exists for stanza db If you look at the error carefully, it is trying to tell you that “stop file exists” which means pgBackrest is already in stopped state and you need to start it before performing the operation in PostgreSQL. To resolve it, start the stanza or simply start pgbackrest for all the sta ..read more
Visit website
Pg_restore: error: corrupt tar header found in PGDMP
oraHow - Howto Guides & Software Tutorials
by admin
6M ago
bash-4.2$ pg_restore -U appmdm-Ft -d test < test.tar pg_restore: error: corrupt tar header found in PGDMP (expected 0, computed 18703) file position 512 The above error occurred while importing the test database using pg_restore command. pg_dump was taken in .tar format using below command. bash-4.2$ pg_restore -U appmdm -Ft -d test < test.tar Here, -F is format and t is tar. To overcome this issue, we checked few blogs where it was mentioned this as a bug. I tried to extract it and see the contents of tar file but seems it is not recognized as a tar file. bash-4.2$ tar -tvf test.tar ..read more
Visit website
ERROR: permission denied to create role in PostgreSQL
oraHow - Howto Guides & Software Tutorials
by admin
8M ago
Only postgres user or superuser can grant CREATEROLE permission to a user or role in postgres. If you don’t have this permission, you will get ERROR: permission denied to create role. Check permissions assigned to a user: postgres=# \du List of roles Role name | Attributes | Member of -----------+------------------------------------------------ appadm | | {} postgres | Superuser, Create role, Create DB, | {} Replication Here, we can see that appadm user doesn’t have cr ..read more
Visit website
Understanding Key Background Processes in Oracle
oraHow - Howto Guides & Software Tutorials
by admin
11M ago
When an instance is started, Oracle Database allocates a memory area called the system global area (SGA) and starts one or more background processes. Types of Processes: Different types of database processes: 1: Client Process: A client process can run on a host other than the database host. Client processes run the application or Oracle tool code. 2: Oracle processes: Oracle processes run the Oracle database code. Oracle processes including the following subtypes: 2.1: Background processes: Background processes start with the database instance and perform maintenance tasks such as performing ..read more
Visit website
How to Change AWS RDS Instance Class using AWS CLI
oraHow - Howto Guides & Software Tutorials
by admin
1y ago
It is easy to modify AWS RDS instance class using AWS console but in this post we will discuss about changing instance type using AWS CLI. It is always recommended to test Instance class upgrade on test instance before changing into production instance so that you can compare performance of both the instance type. Please note that Upgrading RDS instance class will require a downtime of few minutes as the instance will move to a different host and the outage involved even if RDS instance is configured with Multi-AZ. Must Read: Find & Kill Blocking Sessions in RDS Oracle. How to Recover dele ..read more
Visit website
How to Find and Kill Blocking sessions in RDS Oracle
oraHow - Howto Guides & Software Tutorials
by admin
1y ago
You cannot use the “alter system kill session” command to terminate blocking sessions in RDS Oracle instead of that you need to use rdsadmin.rdsadmin_util.kill procedure to kill RDS user sessions. Blocking locks will be released once the process is terminated. Due to restrictions you are not allowed to execute “alter system kill command” directly in RDS Oracle. You may get below error after it’s execution. SQL> alter system kill session '627,35083'; alter system kill session '627,35083' * ERROR at line 1: ORA-01031: insufficient privileges In previous post, we discussed about troubleshoot ..read more
Visit website
Increase Amazon RDS Storage Size using AWS CLI
oraHow - Howto Guides & Software Tutorials
by admin
1y ago
You might have encountered AWS RDS storage full situation for your RDS instance. To overcome this situation you can increase or scale up the storage using Amazon RDS console or else using the Command Line Interface -AWS CLI. Scaling storage usually don’t cause any database outage but after storage size modification, the status of the DB instance will be storage-optimization. Storage optimization can take upto several hours and you can’t make further storage modification either for six hours or until storage modification has been completed on the instance, whichever is longer. Related Article ..read more
Visit website

Follow oraHow - Howto Guides & Software Tutorials on FeedSpot

Continue with Google
Continue with Apple
OR