A widely-used open-source operating system that is particularly popular on servers.

learn more… | top users | synonyms

0
votes
1answer
84 views

web interface port for oracle 11g

I am running a fresh Oracle 11g installation created on lunix redhat 5, but I forget the web interface port, I have already tried this https:// localhost:5500/em/ but did'nt work. any help will be ...
0
votes
1answer
82 views

Kerne module for Oracle 11gR2 RAC on Linux

As per Oracle, it requires three Linux packages to run ASMLib: oracleasm - kernel module oracleasmlib-2.0 - ASMLib libraries oracleasm-support-2.0 - Admin for ASMLib This library versions are OS ...
0
votes
0answers
22 views

How do I save file data to my newly mounted SSD in mysql innodb continually?

I've recently mounted a new SSD since my disk's empty space had less than 10% (mysql unbuntu linux) and this is what I did in my.cnf file to save data to my new path: innodb_buffer_pool_size=2G ...
0
votes
1answer
99 views

MySQL Service is not starting on linux

I am having a problem with my database it does not want to start :( the server is running on linux centos 6.2 it was working until I emptied the logs I don't know if this have anything to do with ...
1
vote
0answers
55 views

InnoDB: error: space object of table

131212 10:35:18 InnoDB: error: space object of table 'main/wp_m_membership_levels', InnoDB: space id 119 did not exist in memory. Retrying an open. 131212 10:35:18 InnoDB: error: space object of ...
0
votes
1answer
19 views

Change MySQL 4.1 Windos to MySQL 4.1 Linux- Problem with the key Sensitive in query

I need help to resulucion this problem. change the server MySQL 4.1 run on Windows to MySQL 4.1 run on Linux(debian). This all working, but same query not return the correct data because key ...
1
vote
1answer
79 views

Grant postgres superuser to linux account

On my development (Ubuntu linux) laptop I have a postgres OS account, which owns the Postgres installation. When I want to perform any postgres activities, create/drop databases etc, I must first su ...
0
votes
3answers
562 views

MySQL on Windows or GNU/Linux?

I've just read this article: http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html There it says that MySQL on Windows is a good choice. (or is what I've understood) In ...
0
votes
1answer
520 views

MySQL - Server collation utf8_unicode_ci vs table collation utf8_bin: compatibility and performance

I'm not sure whether this belongs to SE DBA, but it sounds more logical ... Our MySQL 5.5.32 on Ubuntu 12.04 64 uses utf8_unicode_ci for the Server collation and some tables, like phpBB3, uses ...
0
votes
1answer
228 views

TCP sockets bottleneck with InnoDB/Debian?

We have a big mysql performance issue on a production environment with 18 "front" servers sending mysql queries to a unique mysql server. We are using Redis on each front server for a number of ...
1
vote
4answers
2k views

Oracle client throwing ORA-12541: TNS:no listener

when i was trying to connect my remote server as- sqlplus SYSTEM/oracle@192.168.0.171:1521/kannel it shows me this error- SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 15 15:36:52 2013 ...
1
vote
3answers
102 views

Best practice to query administrative views for instance level elements

I want to query a monitor element at instance level (for example the memory used for the instance) via a query like this: SELECT MEMBER, MAX_MEMBER_MEM, CURRENT_MEMBER_MEM, PEAK_MEMBER_MEM FROM ...
0
votes
1answer
63 views

Are databases only growing in size?

Databases use the file system to store the data. As far as I know it is not possible to delete a record from a random access file. So does that mean that when we do a DELETE FROM TABLE the size of the ...
0
votes
0answers
193 views

Oracle Installation issue on Oracle Linux 6.4

I am trying to install Oracle 11g(11.2.0.1.0) on Oracle Linux 6.4(Remote Server). I get the following error(s) when Database Configuration Assistant is running ORA-01092: ORACLE instance terminated ...
0
votes
0answers
24 views

mysqldump: Got error: 0: when retrieving data from server

I get a the error in the header when the server tries to replicate itself after the backup completes. I have looked at error indexes, but failed to see an explanation for the error code 0. I was ...
0
votes
2answers
128 views

Importing MySQL database using Linux Terminal

I have an existing database, named dlti.sql I want to transfer it to a Linux-based server. I tried using this code, however I get no response: mysql -u root -p Desktop < dlti.sql The .sql file ...
0
votes
1answer
61 views

How can I run a PostgreSQL outside the standard directories on Linux, ie outside /var/run/postgresql etc?

I need to be able to run PostgreSQL databases outside the standard installation directories, ie run the existing postgres or pg_ctl process pointing to the alternative ports, configuration and data ...
1
vote
1answer
80 views

command line tool on linux to convert oracle sql into db2 sql

IBM has a GUI based tool to convert Oracle SQL into DB2 SQL. Is there a command line tool (preferably on linux) that does the same thing? The reason being, we want to do this work as part of a ...
1
vote
1answer
63 views

creating 2 database at the same time in db2

Do you know whether it is safe to have in one shell user db2inst1 creating a database A and having another shell the same user creating at the same time database B? create database A # shell 1 ...
0
votes
1answer
263 views

configure: error: SQLite3 library not found

I'm getting the below configure error while doing the install the Zabbix reporting tool on Linux. i have tried both Versions(zabbix-2.0.9,zabbix-1.8.17), but getting same issue. Log: checking for ...
0
votes
0answers
66 views

ORACLE_HOME is not available

I install Oracle 11GR2 on Cenots 5.9 . i edited bash_profile to correct values for ORACLE_HOME and ORACLE_BASE and etc . But when i want to run SqlPlus , " command not found " is shown . but when i ...
0
votes
2answers
1k views

Entering command 'sqlplus' results in 'sqlplus: command not found'

I've recently installed Fedora 19 on an older PC, to serve as a test server of sorts. After a lot of hiccups, I was able to install Oracle 10g XE. Because I'm using Linux - which I, admittedly, have ...
0
votes
1answer
339 views

Install Oracle 11gR2 driver for Node.js 0.10.20

I want to connect Oracle 11gR2 and Node.js 0.10.20. I use this package but I don't understand this part of installation process. Can you explain it to me? # Replace /opt/instantclient_11_2/ with ...
0
votes
0answers
43 views

What to do after installing lin_tape

My OS Linux Centos 6.4 is running on a vmware, I downloaded an Virtual tape library VTL from IBM site (Lin_tape), After I download it, I tried to define the drive name /dev/st1 in the TSM Server, but ...
0
votes
0answers
46 views

How do I debug an Oracle Linux Diskspace Issue?

I have about 429GB Diskspace allocated to this VM. I see that only 179GB is being used. Now when I try to add a 128GB file I get an I/O error saying I do not have any space left. I need to be able ...
0
votes
2answers
162 views

Backup Oracle DB using TSM server version 6.3.0

I'm new to Oracle and TSM server. I installed Oracle11gR2 and TSM server version 6.3.0 (linux Centos 6.4 OS). I did the configuration and everything works fine. so far I arrive to run the following ...
1
vote
3answers
379 views

Issues installing MySQL server on Ubuntu 13.04

I'm currently trying to install a MySQL server on my Ubuntu 13.04 machine. The problem is, when I try to install it, I get error messages indicating that not all packages could be downloaded. When I ...
0
votes
1answer
85 views

MongoDB cloneCollection between CentOS servers times out at 2 hours

I'm trying to clone a MongoDB collection from CentOS server A to CentOS server B. Both are running 2.4.6. The copy works great until exaxctly 2 hours, at which point I get a 9001 socket exception: ...
0
votes
1answer
455 views

Mysql Server Login and Permission Deny Error

I have a problem with MySQL server. After upgrading MySQL server from 5.3 to 5.4, I am not able to log-in using my MySQL root password (Yes, I am able to log-in without password!). Also not able to ...
0
votes
1answer
674 views

Installing Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) name

Installing 11gR2 on Oracle Linux 6.4. System is a desktop used by one developer. It's on DHCP. Hostname is similar to ip-t3400-1547.mydomain.local Please note I have no issues installing this ...
0
votes
0answers
127 views

After RAM upgrade on 32-bit Oracle server, ORA-04031: unable to allocate x bytes of shared memory

We are in the process of upgrading our Oracle database server at work, from SUSE Linux Enterprise Server 10.4 / Oracle 10g / 4GB RAM (Intel 32-bit) to Scientific Linux 6.4 / Oracle 12c / 8GB RAM ...
3
votes
2answers
2k views

db2 database alias not listed via list database directory but still unable to create that database

I am trying to create a database by logging on to the linux server on which the db2 server is installed, as the instance owner db2 => list database directory System Database Directory Number ...
0
votes
1answer
141 views

db2 SQL0930N error on linux - not enough space to process this statement

This is another newbie question on db2, related to space. How to I start diagnosing and then solving what the problem is so that users can connect to this database? This error is displayed when both ...
-3
votes
1answer
50 views

How can I move one table from one database to other database [closed]

I want to move one table in one database to other database using mysql dump on linux terminal How can I go about it ?
1
vote
1answer
340 views

SQL1641N error on linux while running db2start using db2 express c on linux (LUW) but the file system is not mounted using nosuid

I am trying to install and start db2 on my linux machine using the following script: #!/usr/bin/env bash MKDIR=/bin/mkdir RM=/bin/rm TAR=/bin/tar ...
1
vote
1answer
125 views

error when trying to connect to remote db2 luw database on linux

I have a db2 client on my local linux machine: alok@hostname:~$ uname -a Linux hostname 3.2.0-53-generic #81-Ubuntu SMP Thu Aug 22 21:01:03 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux alok@hostname:~$ ...
1
vote
1answer
293 views

PostgreSQL transaction locked database table: “idle in transaction”

I have a web application interacting with PostgreSQL (v8.4 & Centos Linux) which suddenly started locking some of the database's tables. Still have no idea what happened, since the code is not ...
1
vote
1answer
125 views

Scaling down DB where filesystem is almost full

Our DBA is on holiday, and since I know 'a bit' of MySQL, they've asked me to fix this. The data slice is at 99%, and I need to know what to get rid of. [root@servername]# find . -type f -size ...
2
votes
2answers
262 views

db2 (LUW) equivalent for oracle drop user cascade

This question is related to creating and initialising test and development databases for an application that has the database running on LUW (linux-unix-windows) On oracle, we have an os user (on ...
1
vote
1answer
236 views

db2 LUW help for an oracle user : create database hangs without any output, but database got created

I am new to db2 but have worked on oracle before. Trying to create a database and it succeeds, but the session where I issued a database creation command hangs. I have installed db2 10.5 on a 64 bit ...
0
votes
0answers
285 views

Incorrect information in .frm file after a power outage?

CentOS release 6.3 (Final) x86_64 mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1 SHOW SLAVE STATUS\G: Slave_IO_Running: Yes Slave_SQL_Running: No ...
1
vote
1answer
2k views

Enabling LOAD DATA LOCAL INFILE in mysql

LOAD DATA LOCAL INFILE is not enabled by default. Normally, it should be enabled by placing local-infile=1 in my.cnf. But it does not work for all installations. In my experience, it worked for Debian ...
5
votes
2answers
3k views

Cannot open table mysql/innodb_index_stats

After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well. The errors I ...
0
votes
1answer
1k views

MariaDB Galera Cluster Replication error, no state received?

I have a very minimal, fresh out of the box setup for MariaDB with Galera clustering. My master node of the cluster is able to run, and is reporting that there is only one node attached to the ...
0
votes
2answers
182 views

Reading CSV files located on LINUX server and updating the tables in SQL Server Database

I was wondering how do we ingest CSV files located on a Red Hat LINUX server into SQL Server Database Table. I know we can write a Stored Procedure/Bulk Insert to read the files that are located on ...
2
votes
1answer
290 views

My MySQL server time is not the same as my Server

So a month ago I had purchased a server from a hosting company. The info are; Linux Centos (latest version). I installed ZPanel which installs phpMyAdmin, MySQL and all the other good stuff. ...
2
votes
1answer
72 views

How identify tables with millions of entries

On a debian server with apache and mysql, how can I find out if any one table gets spammed? I have lots of different blogs, wordpress, wikis,... on my server of different customers. It seems like ...
0
votes
0answers
120 views

mysql died with stack trace

My mysql server died while running select queries. Status of every table is good. When I went to the error log I found this: Thread pointer: 0x2ab63e0f49e0 Attempting backtrace. You can use the ...
1
vote
2answers
71 views

Strange issue regarding my.cnf

I'm getting a weird message from phpmyadmin saying: #2006 - MySQL server has gone away What I found online is that I should increase the size of max_allowed_packet witch should be in the my.conf ...
3
votes
1answer
2k views

InnoDB log sequence number is in the future

130711 23:03:40 InnoDB: Error: page 23 log sequence number 3336825872455 InnoDB: is in the future! Current system log sequence number 235089. InnoDB: Your database may be corrupt or you may have ...