Questions tagged [instance]

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

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
1
vote
0answers
204 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
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 ...
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 ...
0
votes
0answers
26 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
1answer
155 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
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 ...
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 ...