Jump to content

VME

Members
  • Content count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

About VME

  • Rank
    Newbie
  1. Hello, We will perform eletrical maintenance in one of our server rooms. So all servers have to be stopped. We have an Oracle cluster on grid 12.1.0.2 (active/passive) with ASM. We stopped db resource on the node wich will be shutdown and started them on the other node. The below resources are open on the node that we have to stop: -ora.MGMTLSNR -ora.cvu -ora.mgmtdb -ora.oc4j 1) Is a downtime of active instances on the other node is to be expected if we shutdown the node wich host theese services? 2) If we use "srvctl relocate resource_name -node node_name" to switchover theese resources (MGMTLSN,cvu,mgmtdb,oc4j) to the other node, is a downtime of active instances on the other node is to be expected too? Thank you in advance. Regards, VME
  2. Hello, After long searchs, it seams that there is no possibilities to use SQLNETAuthentication to connect as sysdba on a puggable database with impdp and expdp. The below syntaxe doesn't work for connect to a pdb: \"pdb1/as sysdba\" So i decide to use Oracle Wallet to avoid password display in my scripts. Have a nice day and thank you for your help! VME
  3. Hello Mrs Burleson, Thank a lot for your assistance. Here are my answers: pdb and cdb are already declared in my tnsnames.ora and i'm able to connect like this: sqlplus sys/****@pdb as sysdba sqlplus sys/****@cdb as sysdba So i tried your command line but i got a syntax pb. expdp '\pdb1/ as sysdba\' full=Y directory=... LRM-00101: unknown parameter name 'sysdbafull' But with this command, error messages are different: expdp \"pdb1/as sysdba\" full=Y directory=... Export: Release 12.1.0.2.0 - Production on Fri Mar 2 09:35:34 2018 Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved. UDE-01005: operation generated ORACLE error 1005 ORA-01005: null password given; logon denied Username: But when i grab my credentials, i got again the UDE-01034: operation generated ORACLE error 1034 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 2311 Additional information: 1975425287 UDE-00003: all allowable logon attempts failed Then i tried something and the result seems to be a bad news: export ORACLE_SID=pdb1 sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 2 09:43:47 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> exit Disconnected export ORACLE_SID=cdb1 sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 2 09:44:00 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production With the Automatic Storage Management option SQL> So i think my expdp as sysdba on a pdb and without credentials isn't possible... I probably should try to export with the cdb wherewas pdb... best regards VME
  4. Hi everyone! I'm happy to post there because there is a long time i solve my problem's by reading this forum but today, i need help and i m not able to find any solution... Here is the perimeter: I am on AIX, with Oracle RAC 12c and Oracle 11g environment. Databases are backuped with some sh scripts. On the Oracle 12c environnement, i have a cdb named db1 and i have a pdb named pdb1. OS authentication is active (SQLNET.AUTHENTICATION=NTS) and i can log my user system with (in 11g and in 12c): export ORACLE_SID=db1 sqlplus system/pwd Today, the system's password is displayed into my sh script. I have to hide the password in the sh script. On Oracle 11c, no problem, i can export with the following command: expdp \"/as sysdba\" full=Y directory=...... But on Oracle 12c, I'm not abble to run an expdp as sysdba in the same way, i got this errors: UDE-01034: operation generated ORACLE error 1034 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 2311 Additional information: 1410328243 UDE-00003: all allowable logon attempts failed Here is the var i set at the beginning of my (11g and 12c) scripts: export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/xxxx/dbhome_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib export OPATCH_LIB=/u01/app/oracle/xxx/dbhome_1/OPatch export PATH=$ORACLE_HOME/bin:$PATH:$OPATCH_LIB export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 Same errors when i set ORACLE_SID=pdb1 or ORACLE_SID=db1 This export command is working on Oracle 11g 'cause i do not have cdb and pdb => I think this is the problem) its look like i have to alter session set container=pdb1 while exporting x) Can someone help me?? Thank you in advance, and have a nice day! best regards VME
×