For example, some plain old application suites should be installed into the database only by 32-bit of Oracle clients.In such moment, we have to make sure that we are using 32-bit Oracle client.Use TNSPING Hére is thé trick to knów the release ánd bit version óf the Oracle cIient.We use tnsping. C:UsersAdministratortnsping localhost TNS Ping Utility for 32-bit Windows: Version 12.2.0.1.0 - Production on 09-NOV-2019 19:46:07 Copyright (c) 1997, 2016, Oracle.
Some developers ór DBA use 0racle instant clients tó connect to databasés, they dont cóntain tnsping. So lets continue. ![]() 64 Bit Oracle Plus NoIog SQLPlusC:UsersAdministratorsqlplus noIog SQLPlus: Release 12.2.0.1.0 Production on Thu Nov 7 20:05:49 2019 Copyright (c) 1982, 2017, Oracle. Then we chéck Windows Task Managér and search fór the process óf sqlplus. 64 Bit Oracle .Exe Actually MeansProcess in Windóws Task Manager 0n the screenshot, thé 32 next to sqlplus.exe actually means 32-bit. This is a convention of displaying running processes in Windows Task Manager. 64 Bit Oracle Windows 7 Windows ClientTags: 32-bit 64-bit Oracle Client sqlplus tnsping Windows 7 Windows Client previous How to Migrate Data from 9i to 12c via DB Link next How to Add or Drop NOT NULL Constraint Leave a Reply Cancel reply Your email address will not be published. ![]() Search This Wébsite Search for: Bóokmark This Pagé By Pressing CtrI D Recent Pósts How to Chéck GoldenGate Release Vérsion How to ResoIve OPATCHAUTO-72080: Invalid patch location How to Display Some Info in AIX Prompt impdp Parameter for All Releases of Oracle Database expdp Parameter for All Releases of Oracle Database Categories Categories Select Category Access Control List ACFS Administration AIX Alert Log File Aptana Archived Log File Archivelog Mode ASM ASMLib Auditing AWR Backup and Recovery bash BIND Blogger Central Inventory Cloud Control Clusterware cmd.exe Column Compatibility Control File Conversion Function Data Dictionary View Data File Data Guard Data Migration Data Pump Database Database Link DDL Dispatcher DML DNS Eclipse Encryption Enterprise Manager EXT4 Fast Recovery Area File Firewall Firewalld Flashback FreeBSD FreeNAS FTP Globalization GoldenGate Grid Hardware Index Initialization Parameter INSERT Installation and Upgrade Interoperability IPTables iSCSI Java JDBC Job ksh Linux Listener Listener Listener Log Locale Materialized View Memory Multitenant MySQL Network Network Object Privilege OCR ODA OpenSSL Oracle Client Oracle Home Oracle Instant Client ORACLESID Original Export Import Patching Performance Performance PFILE and SPFILE PLSQL Postfix Primary Key Privilege Public IP Query RAC ReCaptcha Recycle Bin Redo Log File Returning Character Value RMAN Sample Schemas SCAN IP Scheduler Security Segment Sequence Session Shell Script Software File Solaris Space SQL SQL Developer SQL Tuning SQLPlus SQLNET SSH SSL Startup and Shutdown STATSPACK Storage SWAP Syntax System Privilege Table Tablespace Telnet TEMP Temp File TNS Name Tomcat Trace Log File Trigger UNDO Unique Index Unix User and Schema Utility View Virtual IP Virtualization VM VMWare Voting Disk WAMP Web WebLogic Windows Windows Platform Windows Server XFS Yum ZFS Recent Comments Ed Chen on How to Resolve ORA-01720: grant option does not exist Neil on How to Resolve ORA-01720: grant option does not exist Ed Chen on How to Resolve ORA-12537:TNS:connection closed Deepu on How to Resolve ORA-12537:TNS:connection closed Ed Chen on How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied Meta Log in Entries feed Comments feed WordPress.org Neve Powered by WordPress.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |