Tag Info

Hot answers tagged

3

This is really a Unix/Linux question, but it does relate to Oracle, so I'll give an answer. In Unix, the system makes great use of what it calls "spawning" (or "giving birth"). When you run a command, a new process is created which takes all of its information from the parent. Essentially, it's a copy of the parent - it's a new bash shell, which then sets ...


3

You can do this two ways. Use the mysql client SOURCE command. mysql> SOURCE mysql_stuff.txt or mysql> \. mysql_stuff.txt or, you can use the mysql client from the shell. $> mysql -u my_user -pmy_password my_schema < mysql_stuff.txt Note - no space between -p and the actual password. If you don't put in the password, you will be prompted for ...


2

This syntax does not use the listener at all: sqlplus -prelim / as sysdba But you faced an authentication error, because the OS group based SYSDBA authentication failed. Check the below: cat $ORACLE_HOME/rdbms/lib/config.c There you should see a line like this: #define SS_DBA_GRP "John" Only those users can use / as sysdba that are members of the OS ...


1

My reason why to not to use innodb_file_per_table is performance. I did some tests for our database with 450 tables on mysql 5.5.45 Linux CentOS release 6.7 For unit tests which inserts fixtures into the database before each test (not using all tables everytime) and also tests itself does work with database a lot (inserts, update, deletes, selects) the ...


1

With the changing of the clock times on the Master there might be loss of data for the slave a slave may replay a query it already processed Rather than risk either of these extremes, you should schedule a brief downtime. Here is what you should do: STEP 01: Stop all writes to the Master SET GLOBAL read_only = 1; FLUSH TABLES WITH READ LOCK; STEP ...


1

"The listener supports no services" says it all. Is your database running? sqlplus /nolog as sysdba This should tell you if you are connected to an idle instance or if the database is running. Is the database is running? Are you using dynamic or static registration? Once the database has been registered with the listener you should be able to connect. ...


1

The best way would be to enable binary logging on the Slave. Why ? With binary logging enabled on the Slave, each INSERT, UPDATE, DELETE recorded in the binary logs comes with the server_id where the SQL statement originated. What if log-slave-updates was enabled ? If you have log-slave-updates enabled on the Slave, every INSERT, UPDATE, DELETE from the ...



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