Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database-administration]

The tag has no usage guidance.

0
votes
1answer
40 views

PostgreSQL 10 does not start after something

I'm handling a strange problem with one installation of PostgreSQL 10.4. One of the databases instances of PostgreSQL have stopped working after 7 months without issues. When this guy saw that the ...
0
votes
0answers
10 views

postgresql works slowly, even there is enough server resources

Even there is enough server resources, postgresql started to work slowly. postgresql.conf: # DB Version: 9.5 # OS Type: linux # DB Type: web # Total Memory (RAM): 32 GB # CPUs num: 8 # Connections ...
1
vote
1answer
33 views

What kind of tables would I need for the following person database made in MS Access 2003?

It's a database about actors and movies. I want fill it with their age too, so I can answer the queries: at what age they made their last movie. what is the average age when they made their movies? ...
2
votes
1answer
62 views

Database server for web browser [closed]

What is the most used database server for web browsers such as Chrome, Firefox, Opera, or Safari? Maybe I don't understand web browsers, but I am assuming they must have a database server the same way ...
0
votes
0answers
16 views

Is there a way to Store a Query in View/Procedures?

I wrote an Oracle query and I run it manually from SQL Plus or SQL Developer. It has 2 parameters; start and end date/time. Is there a way to store this query in a view or procedures and run it ...
0
votes
0answers
23 views

Why is the database tab not functional in Crystal Reports 9?

I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
0
votes
1answer
46 views

Automatic update of cells on a second tab when they are merely a copy of the previous tab

I have 2 tabs in excel, part of the information on tab one is to be copied into tab 2. It works ok until I insert a new row into the tab 1 spreadsheet. That change to the cells does not reflect in the ...
1
vote
0answers
52 views

Data security in server at home

I am a beginner linux user, and am planning on provisionally opening a game server on a machine I have at home. In addition to the possible DDoS attacks that may occur on this server (the server will ...
2
votes
1answer
683 views

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY '...
2
votes
1answer
134 views

Simulating file corruption on Linux programmatically? (for DB durability testing)

Basically, I want to fwrite() n bytes and have < n bytes be written on the actual disk, or whatever other inconsistency artifacts could arise (like sectors being written out-of-order). I know I ...
0
votes
1answer
789 views

What is the difference between DELTA & TOTAL columns in dba_hist_sqlstat Oracle?

I am using the following query to measure the performance improvement between two views SELECT PARSING_SCHEMA_NAME, SQL_TEXT, OPTIMIZER_COST, FETCHES_TOTAL, FETCHES_DELTA, ...
0
votes
0answers
230 views

Odoo 10 stock transfer under wrong company

The Scenario I am running Odoo 10 Community on a postgresql 9.4 database. I have multiple companies setup, including a parent company and two child companies. A PO was setup incorrectly in the ...
3
votes
4answers
620 views

Why is Hadoop not a Data Warehouse?

What are functional reasons why Hadoop cannot be a Data Warehouse On several sites one can see statements that a Hadoop cluster is not a replacement of a traditional data warehouse. However, I can't ...
0
votes
0answers
41 views

What are the steps involved to share the credentials with multiple applications?

I have 2 scenarios here. app1 and app2 both belong to the same domain app1 and app2 both do not belong to the same domain. For both scenarios, I require the responsibilities of frontend and backend ...
2
votes
2answers
3k views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
2
votes
2answers
257 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
0
votes
1answer
560 views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
0
votes
1answer
142 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
1
vote
0answers
47 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
1
vote
2answers
5k views

Postgres restoring replication, timeline conflict

I have a postgres database (version 9.4) with streaming replication (master, slave configuration). Lets call master db A and slave db B. The server running A failed and we had to do a switchover, ...
0
votes
1answer
193 views

How to give DBA Rights to Domain User Account

How can we give rights / permission to domain managed user account, to manage SQL Databases, typically a DBA Rights? I am on Windows OS.
0
votes
1answer
26 views

SQL 2014 adds null transaction log entries every time a custom service wakes up to look at the database.

SQL2014 on Server2012 (12.0.2000) versus SQL2008R2 (10.50.6000) on Server 2008R2. In SQL2014 but not in SQL2008 .... Both examples add the noted entries to the transaction log once a second (every ...
0
votes
1answer
235 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...
1
vote
0answers
58 views

Mongoose: Failed to connect to IPC Port. [closed]

Failed to connect to IPC Port. Mongoose installed without issue. But I get this error when I attempt to actually use Mongoose.
0
votes
1answer
133 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
-1
votes
1answer
2k views

OSX: Postgresql port 5432 is closed. How to open?

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) Snort 2.9.7.0 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could ...
0
votes
1answer
508 views

Postgresql: can't rename the database

PostgreSQL 9.4.1 (installed with homebrew) I want to rename a database. I'm doing this: $ psql postgres postgres=# ALTER DATABASE snot RENAME TO snortdb postgres-# \l ...
1
vote
2answers
1k views

Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
1
vote
0answers
539 views

check_oracle_health with OPS$Nagios account

I can login to my database via sqlplus with the OPS$ account, but i cannt seem to get it to work in with the nagios check_oracle_health. Im testing from the command line. nagios@servername:/usr/local/...
0
votes
1answer
42 views

Reads vs Writes

Consider a Database which is being constantly accessed (read,write,update,deletions etc) , for instance the Database for some particular airlines. I can understand simultaneous writes/updates can ...
2
votes
1answer
285 views

Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See

My computer has the following Software involved. Microsoft Windows 7 Microsoft SQL Server 2008 R2 Microsoft SQL Server Management Studio Moreover, I have the following Drive partitions: C: drive ...
0
votes
0answers
213 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
2answers
2k views

Adminer error (No PHP extension supported (SQLSRV, MSSQL) available

Adminer is a db management tool made in php (http://www.adminer.org/) I've installed it in Linux LAMP but I get the same error I've written in the Question Title. Did anybody solve this? How? I am ...
4
votes
2answers
1k views

Will a query which may take hours to execute keep executing on remote server if I close the connection after executing the command?

If I connect to a remote database server via ssh, start mysql client and execute a query which may take a couple of hours to execute, then close the connection, will the query continue to execute ...
-1
votes
1answer
1k views

Do oracle database servers use a license key?

I installed oracle Linux and oracle database on a test server using the media on the OTN. I noticed that no key was required. My question is this: On a production environment at some point do I have ...
0
votes
2answers
5k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
1
vote
1answer
2k views

how do I alter the structure of a table in SugarCRM CE?

How do I add fields to the opportunities table so that they propagate? From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...
1
vote
2answers
1k views

What are the risks of copying MDF/LDF files without detaching the DB first?

Our support team have been trained to restore databases by stopping the instance service and then copying a backup of the LDF and MDF files into the folder. All without detaching or attaching the DB ...
1
vote
2answers
5k views

How to start only one version of PostgreSQL database, in this case 9.1?

I have installed PostgreSQL 8.4 and 9.1 on same Ubuntu machine and I want to try to run only 9.1 and 8.4 to stay off. When I run /etc/init.d/postgresql start it starts both. How to start only one ...
2
votes
1answer
10k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
0
votes
1answer
48 views

Model for Cooperation in a class? [closed]

Assume you have six classes of students with low level of computer skills. They use Gmail inboxes to store old exam questions, notes and tips. Dropbox and Google Drive too, since Gmail inboxes get ...
0
votes
0answers
258 views

How to restore mysql databases from file disk

I used to have a few mysql databases on my system, but my operating system crashed and I cannot access the installed mysql service anymore. The only thing that I have is access to the database files ...
2
votes
0answers
300 views

How do I enable fully qualified column names in Query Builder in Toad for Oracle?

I've found several hits on google on how to do this in Toad for SQL, but I need the same for Toad for Oracle. (Toad v11). I'm building a large query where I combine several aliases of the same table (...
1
vote
0answers
1k views

Installation of Oracle Database 11g Express Edition on Ubuntu 12.10

I intalled the Oracle database have followed this steps [link|http://meandmyubuntulinux.blogspot.in/2012/05/installing-oracle-11g-r2-express.html?showComment=1357195285714#c4393074524447658792] . 1....
0
votes
1answer
1k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
0answers
101 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
1
vote
1answer
587 views

MongoDB Command Line Tool

Is it possible to enter arbitrary command in MongoVUE and get result? If there is not such feature do you know any other windows app that can be used as mongo front-end console?
0
votes
1answer
12k views

Restricting a user to access only his own tables in Oracle SQL Developer

I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, ...
3
votes
2answers
4k views

Collaborative use of bibtex as an online database (JabRef)?

I am thinking about a collaborative effort, where several people would need to insert data; for different reasons, it would be most convenient that this data is in bibtex format (the references format ...
0
votes
1answer
2k views

Mysql not starting with changed datadir

I was looking for a way to store my mysql databases on a different partition than the default installation. I found this link and followed the steps. However, after having changed the line datadir = /...