SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report
conn / as sysdba @$ORACLE_HOME/sqlplus/admin/plustrce.sql grant plustrace to scott; conn scott/password @$ORACLE_HOME/rdbms/admin/utlxplan.sql exit
root pts/4 psl0ssh01.skead. Thu Jan 31 12:56 still logged in oracle pts/4 w7x64proddvh111. Thu Jan 31 12:50 - 12:52 (00:02) root pts/6 psl0ssh01.skead. Thu Jan 31 12:18 - 12:23 (00:05) root pts/5 psl0ssh01.skead. Thu Jan 31 11:08 still logged in admin pts/5 psa0addm2.skead. Wed Jan 30 20:21 - 20:23 (00:01) admin pts/5 psa0addm2.skead. Wed Jan 30 20:11 - 20:21 (00:09)
HISTTIMEFORMAT="%d/%m/%y %T "
962 31/01/19 11:08:50 cd product/ 963 31/01/19 11:08:50 ls -al 964 31/01/19 11:08:50 du -sh * 965 31/01/19 11:08:50 cd ..
962 cd product/ 963 ls -al 964 du -sh * 965 cd ..The man page for history states
psql psql (11.2) Type "help" for help. postgres=# alter role superuser valid until 'infinity'; ALTER ROLE
#------------------------------------------------------------------------------
# REPORTING AND LOGGING
#------------------------------------------------------------------------------
# - Where to Log -
log_destination = stderr # Valid values are combinations of
# stderr, csvlog, syslog, and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.
# This is used when logging to stderr:
logging_collector = on # Enable capturing of stderr and csvlog
# into log files. Required to be on for
# csvlogs.
# (change requires restart)
# These are only used if logging_collector is on:
log_directory = log # directory where log files are written,
# can be absolute or relative to PGDATA
log_filename = 'postgresql-%a.log' # log file name pattern,
# can include strftime() escapes
log_truncate_on_rotation = on # If on, an existing log file with the
# same name as the new log file will be
# truncated rather than appended to.
# But such truncation only occurs on
# time-driven rotation, not on restarts
# or size-driven rotation. Default is
# off, meaning append to existing files
# in all cases.
log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 disables.
log_rotation_size = 0 # Automatic rotation of logfiles will
# happen after that much log output.
# 0 disables.
[postgres@myserver /pgdata/data/log]$ ls -latrh total 5.6M drwx------ 2 postgres postgres 4.0K Dec 23 00:00 . -rw------- 1 postgres postgres 867K Jan 24 23:59 postgresql-Thu.log -rw------- 1 postgres postgres 869K Jan 25 23:59 postgresql-Fri.log -rw------- 1 postgres postgres 873K Jan 26 23:59 postgresql-Sat.log -rw------- 1 postgres postgres 873K Jan 27 23:59 postgresql-Sun.log -rw------- 1 postgres postgres 873K Jan 28 23:59 postgresql-Mon.log -rw------- 1 postgres postgres 873K Jan 29 23:59 postgresql-Tue.log drwx------ 21 postgres postgres 4.0K Jan 30 10:47 .. -rw------- 1 postgres postgres 407K Jan 30 11:01 postgresql-Wed.log
[postgres@myserver ~]$ echo $PGDATA /pgdata/data
[postgres@myserver ~]$ pg_ctl status pg_ctl: server is running (PID: 27870) /usr/pgsql-11/bin/postgres "-D" "/pgdata/data"
[postgres@myserver ~]$ pg_ctl status -D /pgdata/data pg_ctl: server is running (PID: 27870) /usr/pgsql-11/bin/postgres "-D" "/pgdata/data"
[postgres@myserver ~]$ pg_isready -d testdb01 /var/run/postgresql:5432 - accepting connectionsStop:
[postgres@myserver ~]$ pg_ctl stop waiting for server to shut down.... done server stopped
[postgres@myserver ~]$ pg_ctl start waiting for server to start....2019-01-30 10:35:04 CET LOG: listening on IPv4 address "0.0.0.0", port 5432 2019-01-30 10:35:04 CET LOG: listening on IPv6 address "::", port 5432 2019-01-30 10:35:04 CET LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2019-01-30 10:35:04 CET LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2019-01-30 10:35:04 CET LOG: redirecting log output to logging collector process 2019-01-30 10:35:04 CET HINT: Future log output will appear in directory "log". done server startedIf your postgres server is running on RHEL7 or newer, you should use systemctl to control the service:
systemctl start postgresql-11 systemctl stop postgresql-11 systemctl restart postgresql-11 systemctl status postgresql-11Example output(abbreviated) from the status command:
● postgresql-11.service - PostgreSQL 11 database server
Loaded: loaded (/etc/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2021-01-08 02:20:51 CET; 1 months 10 days ago
Docs: https://www.postgresql.org/docs/11/static/
Main PID: 1910 (postmaster)
CGroup: /system.slice/postgresql-11.service
├─ 1910 /usr/pgsql-11/bin/postmaster -D /postgres/data
├─ 2047 postgres: logger
├─ 2390 postgres: checkpointer
├─ 2392 postgres: background writer
├─ 2394 postgres: walwriter
├─ 2395 postgres: autovacuum launcher
├─ 2396 postgres: archiver last was 00000001000002360000009A
├─ 2397 postgres: stats collector
├─ 2398 postgres: logical replication launcher
├─ 2766 postgres: postgres_exporter postgres localhost(60360) idle
├─ 3061 postgres: postgres_exporter postgres localhost(44202) idle
├─48217 postgres: postgres postgres [local] idle
which psql /sw/postgres/pgsql-13/bin/psql cat /u02/pgdata/datafiles/PG_VERSION 13 cat /etc/PG_VERSION 13.ansible
| UNDO | REDO |
|---|---|
| Used during normal database operations | Used during instance and media recovery only |
| Contains changed column values | Contains "change vectors", a description of a change made to a single block |
| Stored inside the database, in a separate tablespace | Stored outside the database, in redo log files |
| Can be utilized for many purposes | Has one purpose only |