今天在安装oraclerac的时候,在图形安装界面下ssh直通一直不同过。查找问题,判断是应为oracle对ssh7.2不支持。 ssh版本降下去后,可以正常安装。 或者安装完rac后,在升级ssh不受影响。 配置ssh直通 oracle11g 不支持7.2 [root@bmfw-ora1 ~]# more /tmp/Ora
今天在安装oraclerac的时候,在图形安装界面下ssh直通一直不同过。查找问题,判断是应为oracle对ssh7.2不支持。
ssh版本降下去后,可以正常安装。
或者安装完rac后,在升级ssh不受影响。
配置ssh直通oracle11g 不支持7.2
[root@bmfw-ora1 ~]# more /tmp/OraInstall2016-04-26_02-45-26PM/sshsetup2_2016-04-26_02-45-26PM.log
INFO: Environment Variables:
INFO: ORACLE_HOME = /u01/app/11.2.0/grid
INFO: PATH = /usr/bin:/usr/ccs/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/
INFO: CLASSPATH =
INFO: Username:grid
INFO: LIBRARY_LOC = /tmp/OraInstall2016-04-26_02-45-26PM/oui/lib/linux64
INFO: m_PropertiesDir = /tmp/OraInstall2016-04-26_02-45-26PM/oui/prov/resources, r_PropertiesDir = null
INFO: SSHSetup: Creating remotePaths using PATH_PROPERTIES_LOC_PROPERTY
INFO: [bmfw-ora1]
INFO: echo $HOME
INFO: Connecting to bmfw-ora1 port 22
INFO: Connection established
INFO: Remote version string: SSH-2.0-OpenSSH_7.2
INFO: Local version string: SSH-2.0-JSCH-0.1.44
INFO: CheckCiphers: aes256-ctr,aes192-ctr,aes128-ctr,aes256-cbc,aes192-cbc,aes128-cbc,3des-ctr,arcfour,arcfour128,arcfour
INFO: aes256-ctr is not available.
INFO: aes192-ctr is not available.
INFO: aes256-cbc is not available.
INFO: aes192-cbc is not available.
INFO: arcfour256 is not available.
INFO: SSH_MSG_KEXINIT sent
INFO: SSH_MSG_KEXINIT received
INFO: Disconnecting from bmfw-ora1 port 22
INFO: An error occured which will cause the program to abort. Refer to latest Log file that was supplied while running th
rrentdatetime>
SEVERE: com.jcraft.jsch.JSchException: Algorithm negotiation fail
at com.jcraft.jsch.Session.receive_kexinit(Session.java:529)
at com.jcraft.jsch.Session.connect(Session.java:291)
at com.jcraft.jsch.Session.connect(Session.java:154)
at oracle.sysman.prov.ssh.RunCommand.runCommand(RunCommand.java:150)
at oracle.sysman.prov.ssh.BaseSSHSetup.runCommandHelper(BaseSSHSetup.java:448)
at oracle.sysman.prov.ssh.BaseSSHSetup.findRemoteHome(BaseSSHSetup.java:347)
at oracle.sysman.prov.ssh.BaseSSHSetup.findRemoteHomes(BaseSSHSetup.java:234)
at oracle.sysman.prov.ssh.BaseSSHSetup.initialize(BaseSSHSetup.java:191)
at oracle.sysman.prov.ssh.OpenSSHSetup.initialize(OpenSSHSetup.java:61)
at oracle.sysman.prov.ssh.BaseSSHSetup.setUpSSH(BaseSSHSetup.java:96)
at oracle.sysman.prov.ssh.SSHSetup.setupConnectivity(SSHSetup.java:283)
at oracle.install.driver.oui.OUISSHSupportManager.establishSSHConnectivity(OUISSHSupportManager.java:167)
at oracle.install.ivw.common.view.SSHSetupPane$7.perform(SSHSetupPane.java:277)
at oracle.install.ivw.common.view.SSHSetupPane$SSHOperation.run(SSHSetupPane.java:336)
INFO: null
INFO: [bmfw-ora2]
INFO: echo $HOME
INFO: Connecting to bmfw-ora2 port 22
INFO: Connection established
INFO: Remote version string: SSH-2.0-OpenSSH_7.2
INFO: Local version string: SSH-2.0-JSCH-0.1.44
INFO: CheckCiphers: aes256-ctr,aes192-ctr,aes128-ctr,aes256-cbc,aes192-cbc,aes128-cbc,3des-ctr,arcfour,arcfour128,arcfour
INFO: aes256-ctr is not available.
INFO: aes192-ctr is not available.
INFO: aes256-cbc is not available.
INFO: aes192-cbc is not available.
INFO: arcfour256 is not available.
INFO: SSH_MSG_KEXINIT sent
INFO: SSH_MSG_KEXINIT received
INFO: Disconnecting from bmfw-ora2 port 22
INFO: An error occured which will cause the program to abort. Refer to latest Log file that was supplied while running th
rrentdatetime>
SEVERE: com.jcraft.jsch.JSchException: Algorithm negotiation fail
at com.jcraft.jsch.Session.receive_kexinit(Session.java:529)
at com.jcraft.jsch.Session.connect(Session.java:291)
at com.jcraft.jsch.Session.connect(Session.java:154)
at oracle.sysman.prov.ssh.RunCommand.runCommand(RunCommand.java:150)
at oracle.sysman.prov.ssh.BaseSSHSetup.runCommandHelper(BaseSSHSetup.java:448)
at oracle.sysman.prov.ssh.BaseSSHSetup.findRemoteHome(BaseSSHSetup.java:347)
at oracle.sysman.prov.ssh.BaseSSHSetup.findRemoteHomes(BaseSSHSetup.java:234)
at oracle.sysman.prov.ssh.BaseSSHSetup.initialize(BaseSSHSetup.java:191)
at oracle.sysman.prov.ssh.OpenSSHSetup.initialize(OpenSSHSetup.java:61)
at oracle.sysman.prov.ssh.BaseSSHSetup.setUpSSH(BaseSSHSetup.java:96)
at oracle.sysman.prov.ssh.SSHSetup.setupConnectivity(SSHSetup.java:283)
at oracle.install.driver.oui.OUISSHSupportManager.establishSSHConnectivity(OUISSHSupportManager.java:167)
at oracle.install.ivw.common.view.SSHSetupPane$7.perform(SSHSetupPane.java:277)
at oracle.install.ivw.common.view.SSHSetupPane$SSHOperation.run(SSHSetupPane.java:336)
INFO: null

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

WebStorm Mac version
Useful JavaScript development tools

SublimeText3 Linux new version
SublimeText3 Linux latest version

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Atom editor mac version download
The most popular open source editor

Dreamweaver CS6
Visual web development tools
