grid install

I installed grid successfully.
What is this error all about?





SQL> startup
ORACLE instance started.

Total System Global Area  619360256 bytes
Fixed Size                  1338280 bytes
Variable Size             373294168 bytes
Database Buffers          239075328 bytes
Redo Buffers                5652480 bytes
Database mounted.
Database opened.
SQL> select name from v$database;

NAME
---------
TRANS

SQL> select name from v$controlfiles;
select name from v$controlfiles
                 *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> desc dba_controlfiles;
ERROR:
ORA-04043: object dba_controlfiles does not exist


SQL> select name from dba_datafiles;
select name from dba_datafiles
                 *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select name from dba_data_files;
select name from dba_data_files
       *
ERROR at line 1:
ORA-00904: "NAME": invalid identifier


SQL> desc dba_data_files;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                                    VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER
 ONLINE_STATUS                                      VARCHAR2(7)

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/oracle/app/oracle/oradata/trans/users01.dbf
/oracle/app/oracle/oradata/trans/undotbs01.dbf
/oracle/app/oracle/oradata/trans/sysaux01.dbf
/oracle/app/oracle/oradata/trans/system01.dbf

SQL> shu abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@newmac trans]$ . oraenv +ASM
ORACLE_SID = [trans] ? +ASM
The Oracle base for ORACLE_HOME=/oracle/app/oracle/product/11.2.0/grid is /oracle/app/oracle
[oracle@newmac trans]$ export ORACLE_SID=trans
[oracle@newmac trans]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 14 21:25:25 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01031: insufficient privileges
SQL> exit
Disconnected
[oracle@newmac trans]$ export ORACLE_SID=trans
[oracle@newmac trans]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 14 23:04:52 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01031: insufficient privileges
SQL> shu
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> exit
Disconnected
[oracle@newmac trans]$ . oraenv trans
ORACLE_SID = [trans] ? trans
The Oracle base for ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db is /oracle/app/oracle
[oracle@newmac trans]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 14 23:05:27 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  619360256 bytes
Fixed Size                  1338280 bytes
Variable Size             373294168 bytes
Database Buffers          239075328 bytes
Redo Buffers                5652480 bytes
Database mounted.
Database opened.
SQL> show parameter inst

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
active_instance_count                integer
cluster_database_instances           integer     1
instance_groups                      string
instance_name                        string      trans
instance_number                      integer     0
instance_type                        string      RDBMS
open_links_per_instance              integer     4
parallel_instance_group              string
parallel_server_instances            integer     1
SQL> alter system set control_files='DISK1' scope=spfile;

System altered.

SQL> alter system set db_create_file_dest='disk1' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@newmac trans]$ rman sys/oracle123@trans

Argument     Value          Description
-----------------------------------------------------------------------------
target       quoted-string  connect-string for target database
catalog      quoted-string  connect-string for recovery catalog
nocatalog    none           if specified, then no recovery catalog
cmdfile      quoted-string  name of input command file
log          quoted-string  name of output message log file
trace        quoted-string  name of output debugging message log file
append       none           if specified, log is opened in append mode
debug        optional-args  activate debugging
msgno        none           show RMAN-nnnn prefix for all messages
send         quoted-string  send a command to the media manager
pipe         string         building block for pipe names
timeout      integer        number of seconds to wait for pipe input
checksyntax  none           check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "identifier": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
RMAN-01008: the bad identifier was: sys
RMAN-01007: at line 2 column 1 file: command line arguments
[oracle@newmac trans]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 14 23:08:48 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target /

connected to target database (not started)

RMAN> exit


Recovery Manager complete.
[oracle@newmac trans]$ . oraenv trans
ORACLE_SID = [trans] ?
The Oracle base for ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db is /oracle/app/oracle
[oracle@newmac trans]$ export ORACLE_SID=trans
[oracle@newmac trans]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 14 23:09:34 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target /

connected to target database (not started)

RMAN> Restore controlfile from '/oracle/app/oracle/oradata/trans/control01.ctl';

Starting restore at 14-SEP-13
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/14/2013 23:13:50
RMAN-12010: automatic channel allocation initialization failed
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

RMAN> exit


Recovery Manager complete.
[oracle@newmac trans]$ rman target sys/oracle123@trans

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 14 23:15:17 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[oracle@newmac trans]$ ls
control01.ctl  redo02.log  sysaux01.dbf  temp01.dbf     users01.dbf
redo01.log     redo03.log  system01.dbf  undotbs01.dbf
[oracle@newmac trans]$ cd ..
[oracle@newmac oradata]$ ls
stand  trans
[oracle@newmac oradata]$ cd ..
[oracle@newmac oracle]$ ls
admin        checkpoints  DEST  flash_recovery_area  product
cfgtoollogs  dest         diag  oradata              stand
[oracle@newmac oracle]$ cd product/
[oracle@newmac product]$ ls
11.2.0
[oracle@newmac product]$ cd 11.2.0/
[oracle@newmac 11.2.0]$ ls
db  grid
[oracle@newmac 11.2.0]$ cd db/
[oracle@newmac db]$ ls
apex         deinstall         jdev     OPatch       scheduler
assistants   demo              jdk      opmn         slax
bin          diagnostics       jlib     oracore      sqldeveloper
ccr          dv                ldap     oraInst.loc  sqlj
cdata        emcli             lib      ord          sqlplus
cfgtoollogs  has               log      oui          srvm
clone        hs                md       owb          sysman
config       ide               mesg     owm          timingframework
crs          install           mgw      perl         ucp
csmig        install.platform  network  plsql        uix
css          instantclient     nls      precomp      utl
ctx          inventory         oc4j     racg         wwg
cv           j2ee              odbc     rdbms        xdk
dbs          javavm            olap     relnotes
dc_ocm       jdbc              ons      root.sh
[oracle@newmac db]$ cd network/
[oracle@newmac network]$ ls
admin  doc  install  jlib  lib  log  mesg  tools  trace
[oracle@newmac network]$ cd admin/
[oracle@newmac admin]$ ls
listener.ora  samples  shrept.lst  tnsnames.ora
[oracle@newmac admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-SEP-2013 23:16:13

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                14-SEP-2013 19:26:10
Uptime                    0 days 3 hr. 50 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/newmac/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=newmac)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@newmac admin]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-SEP-2013 23:16:58

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
[oracle@newmac admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-SEP-2013 23:17:06

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /oracle/app/oracle/product/11.2.0/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/product/11.2.0/db/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/newmac/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=newmac)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                14-SEP-2013 23:17:06
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/11.2.0/db/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/newmac/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=newmac)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@newmac admin]$ rman target sys/oracle123@trans

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 14 23:17:31 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[oracle@newmac admin]$ ls
listener.ora  samples  shrept.lst  tnsnames.ora
[oracle@newmac admin]$ vi listener.ora
[oracle@newmac admin]$ vi tnsnames.ora
[oracle@newmac admin]$ lsnrctl start trans

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-SEP-2013 23:19:19

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
[oracle@newmac admin]$
jcob_lAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
Not easy to follow, but I think your issue focuses on your listener code snippet (attached, see line 6).  The first section does not identify the host.  Correct me if otherwise.  

Would you please reply with:

- the results from "echo $PATH" and also "echo $TNS_ADMIN"
- confirmation that you have one and only one TNSNAMES.ORA on the box.
- the last 50 lines or so of your listener.log; also, same from your alert_trans.log

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/product/11.2.0/db/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/newmac/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=newmac)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)[b](HOST=)(PORT=1521))[/b]
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                14-SEP-2013 23:17:06
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/11.2.0/db/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/newmac/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=newmac)(PORT=1521)))

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jcob_lAuthor Commented:
yes..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.