New answers tagged linux
3
For currently logged in users:
Check the AUTHENTICATION_TYPE column of V$SESSION_CONNECT_INFO.
AUTHENTICATION_TYPE
VARCHAR2(26)
How the user was authenticated:
DATABASE - Username/password authentication
OS - Operating system external user authentication
NETWORK - Network protocol or ANO authentication
PROXY - OCI proxy connection authentication
SERVER
...
1
The problem is literally written on your terminal. You seem to have a db_recovery_file_dest parameter set to a location that does not exist.
As with many oracle database failures, the alertlog will show the problem with a bit more detail. The alertlog will show the parameter value.
Since you don't have a question, just a remark about an error, I assume you ...
1
In Linux installation can be simply executed by selecting latest .deb/.rpm file which can be loaded from official page and installing it via terminal using following command:
Ubuntu 20.04:
sudo dpkg -i dbeaver-xxx.deb
Fedora has two options:
sudo dnf localinstall dbeaver-xxx.rpm
...and:
sudo rpm -i dbeaver-xxx.rpm
IMPORTANT: DBeaver must be shutdown while ...
-1
You can either connect to the mssql server via:
Use SQL Server Management Studio remotly from Windows (note: remote connection needs to be enabled);
Use sqlcmd in linux terminal with the command sqlcmd -S localhost -U SA -P '<YourPassword>'
Use mssql-cli with mssql-cli -S localhost -U SA -P '<YourPassword>' (see docs).
and then run the ...
0
When uploading a lot of data, it must, sooner or later, go to disk. So 88% disk busy probably means that it is busy writing stuff.
If there is a lot of reading in that 88%, then perhaps indexes are being updated. This involves bringing index blocks into RAM (in the buffer_pool), updating them, and (eventually) writing the blocks back to disk. Increasing ...
1
You probably installed PostgreSQL with binary packages rather than from source.
The packager for Ubuntu decided not to use PostgreSQL's features for writing and rotating the log file, but to redirect standard error into a file in /var/log/postgresql and use operating system tools for log rotation.
So yes, the log you see there is all there is. You can adjust ...
Top 50 recent answers are included