Jump to content

mstaples@resdat.com

Members
  • Content count

    5
  • Joined

  • Last visited

Community Reputation

0 Neutral

About mstaples@resdat.com

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. mstaples@resdat.com

    Orapki save to registry

    Unable to save wallet at \\HKEY_CURRENT_USER\Software\ORACLE\WALLETS\DEFAULT
  2. mstaples@resdat.com

    Orapki save to registry

    Trying to store a wallet in the windows registry using command: orapki wallet create -wallet \\HKEY_CURRENT_USER\Software\ORACLE\WALLETS\DEFAULT -auto_login_local doesn't work.
  3. mstaples@resdat.com

    Wallet install ORA 11G XE problem

    Guys thanks for the help. I got through the wallet problems by running this command. alter system set encryption wallet open identified by "passwd"; Now I am getting this. I can't seem to create a master key no matter what I do. The DP export file has these encryption attributes: Metadata encrypted = 1 Table data encrypted = 1 Encrypt Mode = Dual Here is the error. C:\oraclexe\app\oracle\oradata\admin\scripts>impdp system/taleo directory=data_pump_dir dumpfile=fnlexttemp_201603101154 _01.dp, fnlexttemp_201603101154_02.dp, fnlexttemp_201603101154_03.dp content=metadata_only encryption_password="passwd" Import: Release 11.2.0.2.0 - Production on Thu Oct 5 11:26:17 2017 Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ORA-39002: invalid operation ORA-39189: unable to decrypt dump file set ORA-28362: master key not found If I understand how this works I need the encryption_password used during the epxdp. At this point Oracle will not give me that??? There is a lot of information out there regarding ORA-28362 but not much that about error with IMPDP Thanks
  4. mstaples@resdat.com

    Wallet install ORA 11G XE problem

    Client is moving off XXXX, an Oracle Cloud app. Client is moving to a new app on SQL Server. Oracle has given me a Data Pump file. Client has no Oracle License so I am trying to load the data into a staging Oracle DB 11g XE version. The DP dump is apparently encrypted. Obviously the client does not want to buy and Oracle license just get to their own data. ANY IDEAS. This simple little data conversion is becoming a nightmare. Here are the windows 10 powershell messages. PS :\oraclexe\app\oracle\oradata\admin\scripts> ./imp1 C:\oraclexe\app\oracle\oradata\admin\scripts>impdp user/pass directory=data_pump_dir dumpfile=fnlexttemp_201603101154_01.dp, fnlexttemp_2016 03101154_02.dp, fnlexttemp_201603101154_03.dp content=metadata_only tRelease 11.2.0.2.0 - Production on Sun Oct 1 12:50:17 2017 Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ORA-39002: invalid operation ORA-39189: unable to decrypt dump file set ORA-28365: wallet is not open
  5. mstaples@resdat.com

    ORADBA WIN 10 1378

    PS C:\oraclexe\app\oracle\product\11.2.0\server\database> ./oradb Group could not be added User could not be added xxxx.user 1378 User could not be added 1378 user is an administrator, and in ORA_DBA group
×