24
votes
"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2
After two hours, I figured it out.
Oracle's documentation for the error didn't seem terribly descriptive at first:
ORA-24454: client host name is not set
Cause: The network host name in files like /...
- 371
6
votes
Why use RDS over EC2 for Postgres?
For a single instance comparison, not much, but RDS has many advantages, maintenance of a multi-AZ setup with read replicas in different regions, etc. is more than I'd prefer to deal with in EC2. RDS ...
- 171
6
votes
"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2
It's been mentioned in a comment above, but this line fixed this issue for me on my MacBook Pro, running docker wnameless/oracle-xe-11g on port 1521.
sudo /bin/bash -c "echo '127.0.0.1 ${HOSTNAME}' &...
- 161
4
votes
Cannot Access New Installation of MySQL on an Amazon EC2 Instance
While others are suggesting a full reset of the MySQL root password via launching into single user mode and then reseting the password manually through a query, that should not be the case on a clean ...
- 226
4
votes
"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2
This was due to a VPC setting which the EC2 was created under, was set to no:
Under Your VPCs -> Summary tab,
DNS hostnames: no
In order to avoid manual resolution as answered by others, set the ...
- 41
3
votes
"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2
I had this problem with my macOS
Please make sure that you entered your hostname correctly on your /etc/hosts file
to do that> hostname command shows the "real hostname of your mac" and ...
- 131
3
votes
How to run MongoDB as a non root user in Linux?
Another alternative is to use the tarball instead of an installer:
download from https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.6.3.tgz (use wget)
extract (tar xaf mongodb-linux...tgz) and ...
- 175
3
votes
Get WAL files from AWS RDS PostgreSQL instance
This is now possible using Logical Replication:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.LogicalReplication
- 31
2
votes
Disable MySQL replication on rds
The easy way to disable replication is to run this on the RDS slave
CALL mysql.rds_stop_replication;
CALL mysql.rds_reset_external_master;
If Slave_IO_Running is Connecting, then there is one or ...
- 184k
2
votes
Accepted
MySQL replication lagging behind with log_slave_updates
Ultimately I found that adding extra disks (even raiding it), and changing all the suggested settings from Rolando did not help me.
The one thing that did was:
sync_binlog=0
This setting will cause ...
- 151
2
votes
MySQL replication lagging behind with log_slave_updates
First of all, you need to rely on SHOW SLAVE STATUS\G
Let's take a sample display from an old answer of mine : MySQL Replication Lag Behaving Erraticly. In the display, please note the items that can ...
- 184k
2
votes
Amazon RDS low in memory no mysql connections
The memory will be consumed by a number of things, including the MySQL innodb buffer pool, table and definition caches, etc.
RDS will default the innodb_buffer_pool_size to {DBInstanceClassMemory*3/...
- 1,353
2
votes
Accepted
AWS - MySQL server "Service CPU Usage" stuck at 50% / being throttled?
This is probably neither throttling nor a misconfiguration, nor anything related to AWS. Consider these points:
A c4.large instance has 2 cores.
Any given query running in MySQL runs entirely ...
- 22.6k
2
votes
Accepted
Binding specific ips with Mongodb
I am running the below command:
sudo mongod --storageEngine wiredTiger --dbpath /data --bind_ip_all
--logpath /var/log/mongodb/mongod.log --fork
and everything will work just fine. Except,...
- 6,477
2
votes
MySQL hitting IOPS wall in AWS, not able to utilize full volume IOPS level
There are many reasons that may lead to the inability to use all the IOPs available. Here's an unordered list of thoughts.
How many threads are being invoked in the benchmark?
More than about 40 ...
- 78.9k
2
votes
SQL Server for Linux 2019 - Windows Authentication not working
For anyone coming here looking for the solution, it is all about the keytab file.
This is a good tutotial
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication?...
1
vote
Mongodb 3.6.3 disappears after 2 weeks on centos 7 ec2 instance
Your latter problem (start with sudo) is because some of the files or directories are NOT owned by user mongod.
When you state sudo service mongod start mongod process is started with user mongod:...
- 5,723
1
vote
MongoDB Production Amazon - 3 data nodes per replica set, or 2 data nodes plus a shared arbiter
Option 2 has no problems in theory; however the more limited redundancy may be a problem.
About the arbiters:
Yes, you can run multiple arbiters on a single lightweight machine. An arbiter is a very ...
- 399
1
vote
SQL Server AG Listener issues in an AWS VPC
Can you please review the AWS documentation on how to properly set up AG on their environment?
http://docs.aws.amazon.com/quickstart/latest/sql/part3.html
There are some specific steps that need to ...
1
vote
Amazon RDS MySQL limitations
Yes, these values can be changed (within limits).
1. max_connections
You can change this value via parameter groups. The maximum allowed value is 100 000. Note that you are also constrained by ...
- 144
1
vote
"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2
In addition to the top 2 answers (Thanks!), I had to set the HOSTNAME variable in my ~/Library/LaunchAgents/environment.plist file on MacBook running Catalina as it was not already set. After editing, ...
- 11
1
vote
"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2
For people using one of the virtual machines Oracle provides VPN can be a factor here.
If connected, disconnecting from the VPN fixes the problem.
For some reason the Oracle client doesn't like ...
- 111
1
vote
"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2
This issue happened to me, but was not resolved solely by the solution above. If you're using the 11g/12g client, you will get a different error.
In order to resolve the error, do the following:
...
- 111
1
vote
What could be causing this rogue CPU spike on MS SQL Server running on EC2?
For a start, be aware that memory usage (if based on the simple used memory counter, which it likely is) will probably be always static - and likely (for a SQL Server that has been operating for a ...
- 1,656
1
vote
Getting started with AWS: Price for large databases?
are you looking at RDS or EC2 ?, I would suggest you go with an EC2 as you can get a EBS backed storage around 100GB for much less on a lower instance type.have look at this calculator it will give ...
- 191
1
vote
Accepted
Move mssql db Amazon RDS to EC2
Let's step back a little: you're basically switching from a SQL Server that someone else manages, to managing your own server.
Q: What are the security challenges involved with running your own ...
- 43.1k
1
vote
How to configure replication from PostgreSQL (RDS) to vanilla PostgreSQL?
You can use AWS Database Migration Services (DMS) to replicate full and/or change data to another system (such as S3 or a PostgreSQL database running on-premises or on EC2)
make sure use DMS v3.3 if ...
- 8,543
1
vote
MySQL2::Error: BLOB/TEXT column can't have a default value
BLOB, TEXT, GEOMETRY, and JSON columns cannot be assigned a default value.
http://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
What you are in essence asking -- without realizing it, ...
- 22.6k
Only top scored, non community-wiki answers of a minimum length are eligible