We changed our privacy policy. Read more.

Hot answers tagged

12

Depending on YouTube video from @Philᵀᴹ, I have done this problem and I will try to list all I know and every step as following content, Hopefully I can help someone who has the same issues. Download and Install Toad for Oracle v12.10 Open it you should can not use like as below error message Download Instant Client 12.2 Unzip it and move it to anywhere ...


9

Easily solved: export ORACLE_HOME=/usr/lib/oracle/12.1/client64 export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH Stick those lines in your ~/.bash_profile if you want them to persist for a given user, or in /etc/bashrc to persist for all users.


9

LINUX.X64_193000_client.zip is a fully featured installer where you can choose what to install and where, then the installer copies the files to the destination and registers the client. LINUX.X64_193000_client_home.zip is an "image" of and "Administrator" type installation, that you unzip to the destination folder then register it. Simplified Image-Based ...


8

Since 9.3, you can do this using \gset in psqlrc: select split_part(version(),' ',2) pmt \gset \set PROMPT1 '%:pmt:' Or, as 'the value of the selected prompt variable is printed literally, except where a percent sign (%) is encountered': select split_part(version(),' ',2) "PROMPT1" \gset If your version is <9.3, it's still possible, but much uglier, e....


7

I think that what you're looking for are the SET STATISTICS commands: SET STATISTICS TIME SET STATISTICS IO They work for me using sqlcmd on windows:


6

Highly recommend to use latest SSMS. You can download the latest version of SSMS from https://msdn.microsoft.com/en-us/library/mt238290.aspx Previous versions are https://msdn.microsoft.com/en-us/library/mt238488.aspx


6

psql "meta-commands" Commands in psql that start with back-slash (\) are called "meta-commands" and they don't follow the usual semicolon rules but are instead terminated by a newline. A small excerpt from man psql Parsing for arguments stops at the end of the line, or when another unquoted backslash is found. An unquoted backslash is taken as the ...


6

You haven't installed any client because SQL Developer is a Java application, and it uses the Oracle JDBC driver by default, which is located under jbdc/lib inside the directory of SQL Developer and it is included in the zip file you downloaded. SQL Developer is able to use an Oracle client as well. Yes, you need to have something for connecting to Oracle ...


5

pgAdmin keeps throwing up a connection timeout every 10 minutes or so. I would think that the problem might be related to a router (or, in some cases, a stateful firewall) between your pgAdmin client and the PostgreSQL server. This is quite common when you are at home (or in the office) and your router is performing NAT (Network Address Translation). After ...


4

I agree with Joe's answer but want to mention about a built in switch which give you few more data point. You can do it with -p switch. Prints performance statistics for every result set. The following is an example of the format for performance statistics: Where: x = Number of transactions that are processed by SQL Server . t1 = Total time for ...


3

Your original connection string: sqlplus64 "user/pw@pashratgdb01.lex.bb.com:1876/atgpen1.lex.bb.com" This specifices atgpen1.lex.bb.com as a service name. The JDBC syntax you used specifies a SID. Service name identifies a service within a database. SID identifies an instance within a database. Those two are not the same. Instead of this: jdbc:oracle:...


3

The Instant Client is easier to install and more lightweight. It doesn't even need to be installed, you can just unzip it and use it. You don't need an Oracle Home either. On the other hand, it does not support deprecated features like Oracle Names. If you don't need any feature the instant client omits, I suggest you use it. It looks like you are covered ...


3

You do not have to install an Oracle Client for following cases: Your application is based on Java/JDBC, like SQL Developer Your application uses the Oracle Data Provider for .NET Managed Driver (ODP.NET Managed Driver) Your application uses a third-party Oracle Driver, e.g. Devart or Progress (but I am not 100% sure about that) For almost any other ...


3

Place your tnsnames.ora in a directory of your choice, then set the TNS_ADMIN environment variable. Open CMD, enter sysdm.cpl In the Advanced tab, select Environment Variables Under "System Variables", click on 'New' and enter TNS_ADMIN as the name, and the path where your TNSNAMES.ORA resides as your value Windows steps from here. On Linux, it's as easy ...


2

Well, sort of. In vim, save your work to a different file... :w myfile.sql [enter] Then exit vim with an artificial error so the mysql client won't bother to re-read the temporary file. :cq [enter] Then clear the input buffer in mysql. \c [enter] Then do what you've gotta do. Then re-launch vim \e [enter] The editor will have your last command in ...


2

You should not install more than one Oracle Client (per architecture) on one machine. For sure they do not work in parallel. By heart I know several issues: You would have to change PATH settings in order to determine which Client you want to use. TNS_ADMIN environment variable is used by both versions and must be set accordingly. Oracle OleDB provider ...


2

Reference: https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility With -q you can execute multiple query, as you do not get your prompt back until you hit ctrl+c. -q" cmdline query " Executes a query when sqlcmd starts, but does not exit sqlcmd when the query has finished running. Multiple-semicolon-delimited queries can be executed. Use quotation ...


2

Use default_time_zone=UTC in my.cnf. Ref: https://stackoverflow.com/questions/4562456/mysql-setting-time-zone-in-my-cnf-options-file


2

The public link below gives an overview of the four installation type options for the 11gR2 client: http://docs.oracle.com/cd/E11882_01/install.112/e24322/install_overview.htm#LACLI1245 Instant Client: Enables you to install only the shared libraries required by Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), Pro*C, or Java database ...


2

Any data that can change should not be hard-coded into an app. Especially if your app already uses a database. Create a table to store currencies so you can update the list of currencies without needing to rewrite and redistribute the app. As pointed out by Gareth Lyons in a comment, referential integrity relies on the database being self-contained; that ...


2

Prior to 12c, Oracle made only the base releases publicly avialable on OTN, to download patch set releases, you needed to have a valid licence and support contract. If you have a valid licence and support contract, you can still download 11.2.0.3 from https://support.oracle.com Or using this link: https://updates.oracle.com/Orion/Services/download/...


2

Write a bug report! http://bugs.mysql.com. 26542310314 MOD 2^32 = 772506538 That is, the 64-bit connection_id was chopped to 32 bits to send the KILL, thereby sending it to the wrong id. Not many users get past 4 billion connections. How long has your server been up? I hope the code is not reconnecting for every query. Change logs ----- 2014-09-25 5.7....


2

DBForge Studio has exactly what you are looking for. Once installed, go to Tools -> Skin -> Visual Studio 2013 Dark. Everything will be dark (The database tree view, the query windows, the table results, etc).


2

HeidiSQL has some nice dark themes.


2

When the remote PostgreSQL server goes down, the remote OS knows that and tells your OS that the connection has closed, by sending a TCP FIN. When the network goes down, there is no one who knows what happened (or at least no way for them to tell you what happened) so no TCP FIN. So you have to wait for the TCP connection itself to give up. If you want ...


2

Sadly, no, but there are a few options which may help --skip-column-names, -NDo not write column names in results. --skip-line-numbers, -L Do not write line numbers for errors. Useful when you want to compare result files that include error messages. --silent, -s Silent mode. Produce less output. This option can be given multiple times to produce less and ...


2

From a technical standpoint, there are no problems with multiple applications, running on multiple different machines, connecting to the same SQL Server instance. If you experience the failover scenario that you described, it's possible that the reporting workload will interfere with your other workloads from a performance standpoint. In other words, all ...


2

I've found this article to be quite useful. Assuming you know how PostgreSQL HBA generally works (i.e., how pg_hba.conf and postgresql.conf work), you do the following: start up certbot and have letsencrypt generate the cert where it typically does create a script to let letsencrypt copy renewed certs and keys to $PGDATA make sure postgresql.conf and pg_hba....


2

I had the pleasure of maintaining a one-man application that used enums for everything, and I can say as a young DBA it was a nightmare. I had to contact the app developer a dozen times just to get the values for his enums to build my own lookup tables. The best part was when the customer wanted an additional option for one of them, and he just inserted the ...


2

Aliases on Windows are set using the SQL Server Configuration Manager GUI. The Linux equivalent is mssql-conf, but there isn't an equivalent to aliases on Linux. (I don't think this is a case of "isn't supported yet" related to Linux support being relatively new. My guess on the future is just a hunch & guessing rather than fact.) If you need ...


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