ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA

While trying to install Oracle Database 11gR2 on Windows 2012R2 I faced the following error :-

ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA

After checking the logs and investigate about the issue  :-

The password was containing “@” after removed it from the password everything works perfectly.


connection to database cannot be established – DBCA

Environment :-

Oracle Grid Infrastructure
Nodes # : 4
Operating system : Redhat 6.6

When trying to configure enterprise manager the following error appeared :-

Connection to the database cannot be established because the listener could be down. Please make sure that the service is registered with a listener and the listener is up.

The listener is up, VIP is working on all nodes without any issue when check dbca logs looking for more details i found this error :-

dbca trace in $ORACLE_BASE/cfgtoollogs/dbca.

ORA-1017: invalid username/password

Both was correct, because of this i recreate password file on all nodes and restart my operation it’s working without any issue this time.

Osama Mustafa

Configure RMAN Backup On Windows

Database is supported on windows and some people using Windows As Production and RMAN need to be configured to ensure backup for Database in such failure or something to do this follow the below steps :-

  • Create first text file called backup and change the format to “bat”, inside the file add the following lines :-

cd E:\app\ADM-BSS01\product\11.2.0\dbhome_1\BIN
rman @E:\RMAN\Scripts\backup.rman

  • Create 3 folders in E for example :-
    • backup
    • Archivelog
    • Controlfile
  • Create second file name it Backup.rman and add the Rman Script like below 

connect target /
backup AS COMPRESSED BACKUPSET tag Full_database_open format ‘E:\RMAN\backup\db_%t_%s_p%p.bkp’ database;
backup AS COMPRESSED BACKUPSET archivelog all format ‘E:\RMAN\backup\archivelog\al_%t_%s_p%p.arch’ delete all input;
backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format ‘E:\RMAN\backup\cf_%t_%s_p%p.bkp’;
backup tag ORCL_CONTROL current controlfile format ‘E:\RMAN\Controlfile\%d_%T_%s_%p_CONTROL’;
delete noprompt expired backup;
release channel c1;
release channel c2;
release channel c3;
release channel c4;

  • Follow the screen now :-
      • Add Task Name and Description :-
      • Add The Time for this Task in this tab 
      • Another Screen :-
      • In This Screen Add Bat File in our case backup.bat

      Enable/Disable SSH For Root User

      Sometimes for any reason you want to enable root ssh using any SSH Client such as putty and only the administrator can login to do this follow the below steps :-

      • vi /etc/ssh/sshd_config
      • search for line as follow :-
        • PermitRootLogin yes and change it to –>  PermitRootLogin no
      • Search for the following lines as well :-
        • DenyUsers root user2 user3
      • Remove the root from Deny User
        • DenyUsers user2 user3
      • /etc/init.d/sshd restart

      Stopping sshd: [ OK ]

      Starting sshd: [ OK ]

      If you want to disable the SSH login for root just keep everything like the above.

      Osama Mustafa

      Oracle Streams ORA-44001: invalid schema

      SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 job finished
      ERROR at line 1:
      ORA-23616: Failure in executing block 7 for script
      13F5CD569383406C82E7F63EE3F927E0 with
      ORA-44001: invalid schema
      ORA-06512: at “SYS.DBMS_RECO_SCRIPT_INVOK”, line 139
      ORA-06512: at “SYS.DBMS_STREAMS_RPC”, line 465
      ORA-06512: at “SYS.DBMS_RECOVERABLE_SCRIPT”, line 659
      ORA-06512: at “SYS.DBMS_RECOVERABLE_SCRIPT”, line 682
      ORA-06512: at “SYS.DBMS_STREAMS_MT”, line 7972
      ORA-06512: at “SYS.DBMS_STREAMS_ADM”, line 2674
      ORA-06512: at line 5

      The error related to apply_queue parameter in oracle stream is not set with valid value, therefore set the parameter correctly like the below

      apply_queue_user => ‘STREAM_ADMIN’ 

      Osama Mustafa 

      [INS-30131] Initial setup required for execution of installer validation failed.

      When trying to install Oracle client 12c the above error appeared , this issue can happened on windows Or linux.

      The cause i really simple :-

      On linux there is no enough space under /tmp.

      On windows the solution like the following :-

      • Open Windows Services.
      • Stop Oracle Services –> OracleRemExec
      • Remove the OracleRemExecService
      • then try to install Oracle client again

      Thank you 
      Osama Mustafa

      Creating a Local Yum Repository Using ISO Image

      In this post i will show you how to create Yum repository Using ISO Image, will save more time :-

      • Download The ISO Image and Upload it to the server.
      • Create Folder Under Root User Like the below

      cp /OEL6.6. iso /ISOs

      • now create mount point for this ISO.

      mkdir p /var/ISO/OEL6.6
      Run the below command to mount it :-

      mount o loop,ro /ISOs/OEL6.6. iso /var/ISO/OEL6.6

      • Now under /etc/yum.respos.d you can rename it or set enable=0
      •  Create the following file /etc/yum.respos.d/OEL66.repo
      • Edit the file and add 

      name=Oracle Linux 6.6

      • Run the below command to clean yum

      yum clean all
      yum respolist

      The output should be like the below :-

      repo id repo name status
      OL66 Oracle Linux 6.6 25,459 

      Thank you
      Osama Mustafa

      New Features in ORAchk

      The new ORAchk release is now available to download from http://support.oracle.com

      Is your database healthy ?

      ORAchk can be used with any database depend on your Platform Solaris Intel, Solaris SPARC, ,HP , Linux , you can check the Oracle Support Document :-

      ORAchk – Health Checks for the Oracle Stack (Doc ID 1268927.2)

      That include the userGuide and how to Use ORAchk with any platforms,

      New Features :-

      Database performance, install, scalability & ASM
      Cross stack checks for Oracle Applications running on Solaris & Oracle Hardware
      Enterprise Manager Agents performance and failure to run
      Oracle EBS Accounts Payables

      Usually the usage like the below :-

      ./orachk  —> regular healtcheck  + HA best practices
      ./orachk-c hacheck —> HA best practices Only

      Osama Mustafa