23 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 /...
Karl Johnson's user avatar
15 votes
Accepted

db_owner unable to drop database - Error 615, SQL Server

I can guess you have the AutoClose option for database set to True. This is the default behavior when you create a database with Express Editions. The mentioned error can occur exactly in this case. ...
Learner's user avatar
  • 266
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}' &...
turiyag's user avatar
  • 161
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 ...
figtrap's user avatar
  • 171
6 votes

Where to store data on AWS?

Yes. Think of EC2 as a machine. It has a disk attached - a EBS (Elastic Block Store), and the disk size is your limit. Lets say your ec2 instance has a 20gig disk. If you database grow over 20gig, ...
ddutra's user avatar
  • 263
5 votes

How to run MongoDB as a non root user in Linux?

UPDATE This answer is extremely old and covers old versions of MongoDB which using init scripts. For systemd systems, see the answer below by Wernfried Domscheit. OLD ANSWER You mention that you used ...
Pete Garafano's user avatar
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 ...
Giacomo1968's user avatar
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 ...
Arif Basri's user avatar
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 ...
Melih's user avatar
  • 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 ...
serv-inc's user avatar
  • 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
user318817's user avatar
3 votes
Accepted

Server warnings on MongoDB startup

You need to apply what MongoDB Docs say: https://docs.mongodb.org/manual/tutorial/transparent-huge-pages/ I installed MongoDB 3.0.8 as couple of months ago and got the same warnings. This setting ...
RolandoMySQLDBA's user avatar
2 votes

How to run MongoDB as a non root user in Linux?

After changing permissions on directories and files don't forget to log out and log back in. I can't still run it as $ service mongod start it can only be run as root. But alternatively you can ...
ed-ta's user avatar
  • 453
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 ...
RolandoMySQLDBA's user avatar
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 ...
Evert's user avatar
  • 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 ...
RolandoMySQLDBA's user avatar
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/...
Dave Rix's user avatar
  • 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 ...
Michael - sqlbot's user avatar
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,...
Md Haidar Ali Khan's user avatar
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 ...
Rick James's user avatar
  • 78.1k
2 votes

Why does my MySQL page cleaner thread step up its minimum CPU usage over time and never decrease back to zero?

Page Cleaners are very busy because you had 159,120 innodb_buffer_pool_pages_dirty when you gathered your SHOW GLOBAL STATUS data on Feb 18, 2020 Rate Per Second = RPS Suggestions to consider for ...
Wilson Hauck's user avatar
  • 1,763
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?...
Cliff Williams's user avatar
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: ...
Bren1818's user avatar
  • 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 ...
Ian_H's user avatar
  • 1,646
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 ...
entDba's user avatar
  • 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 ...
Brent Ozar's user avatar
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, ...
Michael - sqlbot's user avatar
1 vote
Accepted

Is this work flow suitable for Amazon RDS?

The difference in RDS and MySQL on EC2 is that RDS is a managed deployment of MySQL (you can't change server settings) but not vanilla MySQL either. So if you do not need to alter MySQL's server ...
ratchet's user avatar
  • 60

Only top scored, non community-wiki answers of a minimum length are eligible