TNS-12533: TNS:illegal ADDRESS parameters

I was setting up an new database and adding a tns entry and I get TNS-12533: TNS:illegal ADDRESS parameters when I tnsping. Had not come across this one before. I look at my entry.


my_database =

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = my_database)
)
) <--- Turns out when I cut-n-paste I missed this last parenthesis. What a time waster.

Read More

ORA-1113 signalled during: alter database open

The ORa-1113 error means that your Backup implementation does an ALTER TABLESPACE BEGIN BACKUP and END BACKUP for each tablespace.

 Start the service.

Go to Windows command line prompt as the Administrator or account in the OS_DBA group (with the right ORACLE_SID, ORACLE_HOME and PATH)

sqlplus / as sysdba

startup mount -- or ALTER DATABASE MOUNT if it did get started but not mounted

ALTER TABLESPACE (tablespacename_that_was_in_backup_mode) END BACKUP ;
(if there were multiple tablespaces in backup mode, issue the END BACKUP for each one of them)

ALTER DATABASE OPEN ;
The other option to step 5 is the "RECOVER DATABASE" . Oracle may apply archivelogs to synchronise the datafiles back.

Read More

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

After successful creation of database. I was not able to start the listener. whenever i tried to start the listener it throws the error.


TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters


Solution : I renamed sqlnet.ora . And started the listener again.

Read More