Questions tagged [instance]

An occurrence of a database component. This can mean very different things depending on the platform.

Filter by
Sorted by
Tagged with
0
votes
1answer
1k views

ORA-01503 CREATE CONTROLFILE FAILED… while trying to create a database

i am trying to create a new database along with another database. The server already has a database running. I used DBCA command to create the new db instance. First i set the new SID and home and ...
3
votes
3answers
153 views

How to remotely connect SQL Server 2016. Since we have 2012 and 2016 in same server

Issue I am not able to connect to a SQL Server 2016 instance on a remote system/server. My Existing Environment Windows Server 2012 SQL Server 2012 and 2016 installed on same server I tried to ...
0
votes
1answer
154 views

How do I configure my SQL Server instance to use a different Edition with minimal side effects?

I'm in the process of migrating an old server running Windows 2008 R2 with SQL 2012 Express to a new server running SQL Server 2017 Standard and Windows 2016. I would like to mirror databases between ...
0
votes
0answers
9 views

Trying to create 2nd instance of mariadb on windows server

I have a windows server with MariaDB (10.2.14-MariaDB) and I'm trying to install a 2nd instance on it. I have 1 instance working using port 3307. I used mysql_install_db to install it on port 3307. I ...
1
vote
1answer
77 views

Availability groups multiple instance, multiple listeners

In my work environment, I have two database machines: DB01 DB02 Each database machine has three SQL Server instances: MSSQLSERVER FBG Central I've managed to set up availability groups with SQL ...
3
votes
1answer
103 views

SQL Server Ignoring Instance name when using port number of different instance

I saw a strange case recently and still clueless on what should be the reasoning behind it. On one of my development server, two SQL server instances are running - one is default and other one is UAT ...
2
votes
3answers
45 views

Multiple instance in one server

Could you please help to explain why one might need multiple instances of SQL Server on the same server? What is a good point to use separate instances? Why wouldn't one use two databases in one ...
0
votes
0answers
25 views

Keeping INSTANCE_NAME on Data Guard failover

I have a legacy application which uses a lot of PL/SQL stored procedures. It has a deeply ingrained need to know in which environment it is running, and uses the INSTANCE_NAME for that. For the sake ...
0
votes
2answers
55 views

How to find out the service accounts for each of my instances in the current server?

I have the following query that gives me one line for each sql server instance installed in the current server: --list the instances in the current server --marcello miorelli --16-sep-2016 ...
0
votes
1answer
128 views

What is meant by “Stand-Alone Instance of SQL Server”

I am cloning a server to perform an in-place upgrade and I will have to change the name of that server - which has a SQL Server with just one instance (default instance) installed on it. I am ...
2
votes
2answers
9k views

How to drop a DB2 instance when the instance owner was removed

This is a real sticky situation. I was handed over a machine (running an AIX 7.1), and my first task was to re-install DB2 server on it. But someone before me had conveniently removed an instance ...
2
votes
1answer
89 views

Follow up to: SQL Server 2008 R2: Problems after computer name change

The Original question can be found here: SQL Server 2008 R2: Problems after computer name change I need to know if there is a way to modify the script found in the original question to allow for ...
1
vote
1answer
59 views

How to know which instance is default in Configuration Manager if default port number is changed?

In MS SQL Server Configuration Manager I can see all the instances. I recognize the default one (by saying a default instance I mean the one that listens for 1433) by looking at TCP/IP's IP Addresses ...
1
vote
2answers
744 views

How to determine which one is my default instance in MS SQL Server?

I have two instances in my server and I want to know which one of them is the default. Can you, please, point out ways I can recognize it. By saying a default instance I mean the one that listens for ...
1
vote
0answers
203 views

Converting and/or enforcing an Ascii Character Set in Informix database from 819 or ISO Latin 1

Overview: In Informix is it possible to enforce ASCII for a database or instance. Details: I am trying to enforce ASCII in an instance of informix for a while. This is to help have a smooth ...
-1
votes
1answer
57 views

Authorized, all privileged DB user and a DB instance with the same name - does it have a name? [closed]

Is there a term that encompasses an authorized, all-privileged DB user and a DB instance with the same name? Should I call this a DB stack / DB unit / DB packet / something else? Does this "stack" ...
0
votes
1answer
33 views

When do I need more than one Oracle Instance on the same server?

I have one application server separate from an Oracle server (one physical server). I have three instances on one Oracle Database Server (another physical server). I want to have three environments ...
0
votes
1answer
6k views

Mysql 5.7 Could not create Unix socket lock file

I am trying to create multiple instances of MySQL 5.7 in the same Ubuntu 16.10 32-bit box. I have copied the original data dir to the new one. Created separate log folder for the new instance(the logs ...
1
vote
1answer
21 views

Attempting to setup a new named instance but can't get past the Feature Selection Screen

I have been going through and looking at all of the options listed via google for the better part of the day. No matter how I try to run this, whether initially from the straight GUI interface, using ...
5
votes
2answers
2k views

Installing instances of older versions of SQL Server

Are there any issues to be aware of when installing an instance of previous version of SQL Server AFTER installation of a newer version? e.g. Installing 2008 to a server with an existing 2012 instance?...
0
votes
1answer
695 views

Can an SQL Server Failover Cluster support a named instance?

If I currently have someName\instanceName on a standalone SQL Server and I want to migrate to a failover cluster, http://itknowledgeexchange.techtarget.com/sql-server/moving-a-standalone-instance-to-a-...
2
votes
2answers
4k views

SQL Server 2016 Multiple Availability Groups and instances

So we are getting ready to make a major architecture shift and I get to be on the hook for it, yay! Currently we have 22 separate availability groups each with their own windows cluster across 44 ...
2
votes
2answers
648 views

Instance Recovery in SQL Server?

When the instance crashes due to unexpected disaster in SQL Server, how does the SQL Server recover the databases? SQL Server goes through which phases to recover the data and which are the steps ...
0
votes
1answer
1k views

Which views can be queried while instance is up but database not mounted in Oracle 11G?

If I understood it correctly, when the instance is started, some views are loaded into memory and we can query against it like v$instance. And it doesn't need db to be mounted. If so, are there any ...
2
votes
1answer
644 views

Why does ORACLE cache recovery create uncommited blocks during instance recovery?

The following is an excerpt from an ORACLE book During cache recovery, Oracle replays the transactions from the online redo log files since the last checkpoint. During this roll forward operation,...
1
vote
1answer
3k views

How does SSMS connect to a server's database without the instance name?

I have a question that I am confused about. I am also new to database stuff as well so this question may be basic. For example, at my work, we use SSMS to connect to our server's databases. When ...
5
votes
1answer
1k views

How to create a server instance of just ComputerName instead of ComputerName\SQLEXPRESS

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014. I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that ...
1
vote
1answer
1k views

Multiple instance on single SQL Server

We have a server running single instance of SQL SERVER in production environment. We are planning to create another Instance of SQL SERVER in same server. My question do we have to buy a new ...
4
votes
2answers
5k views

Unable to change servername after VM Clone

For reasons out of my control I must find a solution to this issue. Simply reinstalling the instance is not an option. The server name that appears as server_id 0 in sys.servers is still showing the ...
8
votes
2answers
75k views

Delete an oracle instance, the right way

I want to delete an oracle instance (oracle 10.2.0.4.0) created in the AIX 6.0 OS. I know i can delete all the dbf and ctl files in the Terminal but i thinks that's no the best way to do it. I think ...
5
votes
4answers
2k views

A few huge instances or many small ones

I recently inherited an environment with around 4000+ databases distributed between 21 instances on 3 huge physical servers. Databases are distributed between different instances based on the name, so ...
1
vote
1answer
650 views

TSQL Solution to backup ALL databases on ALL instances of a server?

I'm pretty sure what I'm wanting with my current implementation is impossible, the sys.databases catalog view which is scoped at the service level to be aware of other SQL Server instances (lol). But ...
0
votes
2answers
603 views

SQL Server database stuck in Recovery after Restoring .BAK to same instance

We've had an issue crop up a few times -- maybe we're not using 'best practices' to restore, but appreciate any advice. We run an IIS app with a SQL Server database, and sometimes we run two+ ...
1
vote
1answer
199 views

Default instance name in a cluster

I have a cluster set up with two virtual instance names WIN2K8SQL1\INST1 WIN2K8SQL2\INST2 that was set up by the IaaS company. Now developers are complaining about the naming convention so we ...
4
votes
3answers
395 views

Why does server name need to be specified when accessing local instances?

Even though I have direct access to the physical database machine, I have to specify dbmachine\sql in the connection field, rather than just the instance name. Why is that?
0
votes
1answer
2k views

Instance name is null - SQL Server [closed]

I recently checked this in my SQL server instances: SQL Server 2012 EE: -- get current SQL Server name\instance name SELECT @@SERVERNAME -- get current machine name and instance name SELECT ...
7
votes
2answers
2k views

How can I find a table in the whole instance?

I am trying to create a report which selects data from a table called costomersHR. I cannot find it as we have hundreds of databases in the instance. How can I search for a table in the whole ...
4
votes
4answers
4k views

How to uniquely identify SQL instance

I need to find a way how to identify SQL Instance no matter what changes were done to SQL Server and\or Windows Server where it is running, because we're collecting remotely information about ...
1
vote
1answer
238 views

Run PS-Script after job is done on 3 instances - SQL Server

I have backup jobs running on a server with 3 instances. Link to script: https://ola.hallengren.com/sql-server-backup.html The solution I found for the other 2 servers with only once instance was ...
0
votes
2answers
734 views

How to connect to a named SQL Server instance without specifying its name? [closed]

Is there anyway I can connect to a SQL server that has no default instance, using just the server name? I've tried using SQL CMD, but it seems that the named instance name is required to login, ...
10
votes
4answers
30k views

SQL Server 2008 R2: Problems after computer name change

I'm having a confusing problem after changing the computer name of a remote server hosting a local SQL Server instance. Basically, a remote server was moved from one site to another. In order to ...
1
vote
1answer
1k views

What connection string to use to connect to network server?

I have a database on my computer running on SQL Server Express 2014, and I'd like other computers connected to my network to be able to connect to it using a C# program I wrote. I've done the ...
0
votes
0answers
2k views

Failure to start instance resource on1 node of a 3 node of an Oracle 12c RAC

After adding a 3rd node to our 2 node 12c RAC, one of the existing node is now unable to start the database resource. Extract from crsctl stat res -t: ora.datacdb.db 1 ONLINE ONLINE ...
5
votes
1answer
2k views

Too many mysql instances. How to kill?

I should be ashamed of myself, for asking, I know. Check out this screenshot attached. My server, which is indeed not seeing HUGE amounts of traffic, should not be this overloaded. Mysql is having ...
3
votes
1answer
5k views

ORA-12528 and ORA-12505 error on Oracle database 11g

It's been one week since I last tried to run my final project that I worked on in my last internship at some banking company. Suddenly, my webapps (Java project) in Eclipse can't start. In the log it ...
0
votes
0answers
41 views

Oracle listener up but instance connection blocked ORA-12528 / ORA-12505! [duplicate]

Its been one week since i last try to run my final project that i worked in my last internship at some banking company. Suddenly, my webapps (java project) in eclipse cant start. In the log it says ...
1
vote
1answer
146 views

SQL Server 2008 R2 enterprise named instance [closed]

I have sql server 2008 r2 installed and I am using 3 named instances (2 express and 1 developer). For a task I need to use the CDC (change data capture) which is only in the enterprise edition. I have ...
6
votes
5answers
8k views

Is it advantageous to scale out using multiple SQL Server instances on the same server?

For a use-case of 9 databases spread across 3 time zones, is it advantagous to spread the databases onto multiple SQL Server instances on the same server? What will I gain and what will I lose? ...
15
votes
3answers
4k views

What is shared between two instances on the same server?

We want to install multiple instances of SQL Server on a single Windows server. We cannot use VMs because the server is bare metal Windows 2008 R2. For security purposes we need to ensure that the ...
2
votes
1answer
1k views

postgresql 9.3: two instances on same port and two different ip adresses don't work

i'm setting up multiple instances of postgres 9.3 on the same machine (centos 7). I have 2 virtual ip addresses, one instance is bound to first address and second is bound to second one. Same ...