I have a postgres instance where I need to find out who/what is connecting. The installed version of postgres is 9.0.1. The instance sits on a linux box, SUSE I believe. Where could I look if it is already logging this? If it isn't what could I enable? I need the origin hostname and/or ip, I don't really need any other info outside of that.

for the installation of a SAP IDM system, I need to know how to use the command alter system set "_ORACLE_SCRIPT"=true SCOPE=SPFILE; command correctly. The installation creates a user and gives the error ORA-65096: "invalid common user or role name". During the researches I found the command alter session set "_ORACLE_SCRIPT"=true. This command allows to create users temporarly. At the next session or in a separate terminal, this is no longer possible. In the $ORACLE_HOME/dbs/spfile.ora the parameter *_oracle_script=true was in there, but it gives me the same error again. Thank you in advance. -Sruscht

While upgrading catupgrade.sql, we are getting below error. >Due to errors found during the upgrade process, the post upgrade actions in catuppst.sql have not been automatically run. >*** THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE *** > 1. Evaluate the errors found in the upgrade logs and determine the proper action. 2. Execute the post upgrade script as described in Chapter 3 of the Database Upgrade Guide. >REASON: catuppst.sql unable to run in Database: EluxTest Id: 0 ERRORS FOUND: during upgrade CATCTL ERROR COUNT=6 ------------------------------------------------------ >Identifier CATALOG 20-01-27 02:20:04 Script = c1102000.sql ERROR = [ORA-12801: error signaled in parallel query server P000 ORA-01115: IO error reading block from file (block # ) >ORA-01115: IO error reading block from file 2 (block # 215616) >ORA-27072: File I/O error >Additional information: 4 >Additional information: 215616 >Additional information: 212992 >ORA-06512: at line 8 ] STATEMENT = [BEGIN EXECUTE IMMEDIATE 'create unique index WRH$_EVENT_HISTOGRAM_PK on WRH$_EVENT_HISTOGRAM (dbid, snap_id, instance_number, event_id, wait_time_milli, con_dbid) local nologging parallel tablespace sysaux'; EXCEPTION WHEN OTHERS THEN IF (SQLCODE = -942) THEN NULL; ELSE RAISE; END IF; END;] Tried various solutions mentioned below posted online in various forums, but nothing worked. - Increased SGA to 6GB - Altered Data file sysaux01 to AUTOEXTEND OFF - Altered datafile to ONLINE

We are trying to install Oracle 12c in Suse Linux 12.4. As soon as we start the installation, it fails saying [INS-13001] Environment does not meet minimum requirements When we checked the log, we found this, >oracle.cluster..verification.PreReqNotSupportedException: reference data is not available for Release "12.1" on the operating system distribution "Linux4.12.14-94.41-default" We are not able to find the solution. Does this mean we cannot install 12c in our environment? Please help us to understand and fix this.

We need to add few Ip address in our pg_hba.conf file so that some new servers can connect to our postgresql database. We did the changes to pg_hba.conf like below old pg_hba.conf # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 password host all all 10.150.0.0/16 password host all all 10.156.14.0/23 password New Ips to be added to pg_hba.conf 10.24.8.1 10.150.256.170 10.150.256.133 We had done the changes to pg_hba.conf and added entries like below(we directly added IP address without /16 or /32) New pg_hba.conf # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 password host all all 10.150.0.0/16 password host all all 10.156.14.0/23 password host all all 10.24.8.1 password host all all 10.150.256.170 password host all all 10.150.256.133 password Now, we need to restart the postgresql-9.1 server. I tried the below commands but nothing worked. postgres:~> service status postgresql-9.1 Absolute path to 'service' is '/sbin/service', so it might be intended to be run only by user with superuser privileges (eg. root). -bash: service: command not found postgres:~> service postgresql-9.1 status Absolute path to 'service' is '/sbin/service', so it might be intended to be run only by user with superuser privileges (eg. root). -bash: service: command not found postgres:~> systemctl status postgresql-9.4 If 'systemctl' is not a typo you can run the following command to lookup the package that contains the binary: command-not-found systemctl -bash: systemctl: command not found This is the server info having postgresql-9.1 installed postgres:~> uname -a Linux camboxtest1 3.0.101-108.87-default #1 SMP Fri Feb 22 16:42:57 UTC 2019 (10e85a8) x86_64 x86_64 x86_64 GNU/Linux Did i add the IP address in right format ? What will be the command to restart the postgresql-9.1 services?